SQL exercises
Language 
November 21, 09:58 MSK
Login:

Password:

forgot password?
Registration

Personal page
Developers & Thanks
For employers
References
Feedback
Support SQL-EX.RU




Feedback

Author Comment            page [1] 2 3 4
Sandro Herrera (SandroHV),
Ex Design Engineer from Analog Devices Inc.,
05/07/2020
I wanted to thank you guys for the support when I got stuck on an excercise and for the time you have spent creating the site and writing the book.
Two and half months ago my knowledge of SQL was NULL (really... all I knew about SQL is that some people call it SEQUEL).
After struggling through the 152 Learning exercises, I can say I now know something about SQL, possibly more than I thought I was going to learn.
I finished 5th in the Learning ranking ... somehow..., which was a pleasant surprise.
Special thanks to Valentin, Dmitry and Pavel for the help in getting me unstuck from exercises and for clarifying excercise questions when I was confused. All the best from the other side of the Pacific Ocean,
Sandro
Dvoryaninov Victor,
Business analyst at CJSC "VTB Capital" (Moscow),
01/27/2016
I joined this website being a mature specialist already. I started working with MS SQL Server back in 2001, version 7.0. Then, there was Sybase that hadn’t much difference in syntax. Thus, my original intention was to demonstrate how "cool" I was:). The learning stage has been breezed through very swiftly – experience matters, after all! But then... It’s been... mind-boggling! A mental teardown – in the good sense of the word. An overhaul of my knowledge and skills.
To sum it up:
a lot has been said about this website being a real treasure for newbies - and I fully agree with that! But even for those considering themselves specialists, established developers, completing at least the first rating stage is simply a must.
The most important thing this website gives you is full confidence in yourself, your professional qualities, knowledge and abilities.
During my professional carrier, I've tried a number of roles – developer, team lead, data analyst. Coding, checking code written by subordinates, analyzing code written by predecessors in order to reveal the business logic and formulate optimization tasks. Constructive discussions with colleagues – a very important thing! For those who have undergone the training of this site it’s not a big deal. There's nothing anymore that can confound or scare you. The ease based on the knowledge and skills gained on this website will amaze you – "Why do others have so much trouble with that!"
On a separate note, I'd like to point out the friendliness and constructiveness of the exercise forum threads. I hardly encountered such atmosphere on other professional sites. Kudos to all who have created and maintains this website! And an extra thank you to Sergey Moiseenko!
I.B.Tleukenov (Rokford),
MSc in Business Engineering (Novosibirsk),
02/01/2015
Few days ago I’ve solved last exercise of first rating stage, so I get my first certificate “Basic knowledge” on sql-ex. I will want to describe my feelings of interaction with site.
4 october 2014 I started to learn basic of database theory and SQL. My knowledges in this direction were empty. In my opinion, sql-tutorial and leaning stage are the best for beginner. I spent three month to solve all exercises of leaning stage.
I like rating system on first rating stage. When I performed my goals I founded another users on a site they had same scores and time solution, so I started to compete with them. It was amazing. I have solved all exercises on first stage in one month.
Thanks to creators and authors of exercises!
Also special thanks qwrqwr for unusual cases.
Kobelyatskyy Mykhaylo (kiiki),
MSc in Financial Economics (Lund University),
06/01/2014
I accidentally saw SQL-EX and solved a couple of exercises on the learning stage. I didn't have any previous experience with relational databases and I think that I was caught on simplicity of initial tasks and clarity of explaining articles. But as I went further I became more and more interested in the subject and after I had obtained the first certificate, I decided to strive for the second one. Now I have both, but I am still tempted to proceed when I see next unsolved exercise.
The process of education is extremely interesting and addictive. Some of the exercises are pure masterpieces. Many of them require not only solid T-SQL skills, but also building of sophisticated logical algorithms and conducting mathematical computations. The data manipulation techniques that I learned here allow me to perform for several seconds operations that were unrealizable or took lots of time in Excel. You get used to work with all possible types of data, learn how to cope with gaps and inconsistencies in databases structure, become proficient in twisting, stacking and joining tables in absolutely crazy ways. Moreover you can extend your skills by adopting methods of other participants.
I want to thank creators of this site, technical support and all amazing people here who create unique atmosphere of friendly intellectual competition. I am really proud to be a part of this community.
As a person who didn't have any relation to programming but found this site extremely useful, I would primarily like to recommend it to quantitative and data analysts of all kinds. I think that SQL-EX will also be very helpful for people who want to become programmers but are not sure what niche to choose. Knowledge of SQL and relational databases can be both good addition to another programming languages and self standing specialization. So I encourage everybody to prove your skills. But beware, once you get a flavour of it - it may be impossible to stop.
Jimmy Tan (kof1979),
Software engineer (Singapore),
12/03/2012
Dear SQL-Ex Team, I am a software engineer from Singapore. Before I found this website, i though my SQL was better than average. Until I started SQL exercises then I realised how weak my SQL was. I am extremely excited for learning so many "amazing" skills. These skills are very practical and cannot be easily found in books. Thanks for all the effort for creating and maintaining such a great site! I wish all the best to sql-ex and express my gratitude from the other side of the world from. Thanks!
Tsuranov E.V. (Цуранов Эдуард),
Lead coder, Vladivostok,
04/11/2012
A unique website that allows you to increase your knowledge with the help of various stimuli, including elements of competition, rankings, certificates, problem solving, searching for a fancy solution to a specific task, exchange of solutions on the forum.
While solving tasks, you can discover new things, get great aesthetic pleasure, as well as learn new features of SQL not yet known to you (looking for fancy solutions inspires to do so). By solving tasks, a certain approach to solution finding, based on efforts to understand the specifics and the essence of the task, can be formed.
What’s very important, in the forum threads you can find new ideas and language constructions shared by others and pick up a lot of interesting information, especially in case you couldn’t find a clever solution to a task.
All this, I believe, can significantly increase your knowledge and skill level.
Vladislav Bryzgunov (lorins_),
programmer at Rombo-projects, Ltd (systems integrator),
Moscow
11/22/2011
I registered on this site about a year ago. Before that my knowledge of SQL just let me join two tables using JOIN statement. And even then I used Access Query Builder for the most part. Implementing of all business logic in my company software required skills of working with Recordset objects (DAO, ADO).
When solving problems on this site I’ve got an invaluable experience of building SQL queries. Once I rewrote one of modules of a pricing application using my new knowledge. The result exceeded all expectations. The time of procedure execution decreased by hundreds of times! I think it speaks for itself. I think that certain IT professionals need not only to have an idea of SQL but to know it.
There are no projects as good as “SQL exercises”. Of course, they may exist, but this project is a unique one. It offers practical work which let students to acquire a deep and working knowledge. There is another benefit. Solving the problems of SQL-EX at least supports mental abilities (yes, yes, they become weaker eventually) and even develop them. Many exercises are hard, and one has, as they say, to rack his brains over the solution. I have felt again like a school boy, sent to a competition on mathematics :)
It should be noted that a lot of interesting and smart people are present at the site forum. Its atmosphere is warm and friendly. Contentious issues cause a discussion, not a dispute nor outright insults, like on some forums (guess which :)).
So, I say great thanks to the “SQL exercises” team. Especially I thank the project head Sergey Moiseyenko.
Dmytro Boiko (Angellore),
BI Consultant at BITerra s. r. o.
Kyiv, Ukraine
11/14/2011
My acquaintance with site sql-ex began four years ago when I started to work. One of my friends told me, when you solve one hundred tasks you will become a good specialist. So I started this trip. And I was not disappointed! Because:
1. solving tasks at sql-ex is very efficient: after solving the problem it is possible to see how other guys solved it;
2. support and the people are very friendly;
3. rating system really motivates.
I want to thank all developers of the site and all those who helps to develop such a wonderful resource that can be used not only for teaching but also for leisure.
Dmitriy Sabitov (railgun3r),
Goverment Organization "Territorial fund of information on Natural Resources and Environment Protection of the Republic of Komi", specialist (entry level programmer),
05/10/2011
As a participant of third stage, who "fit" at the 31 th position (this is not the end XD) in the TOP100 and who resolved exercise number 143 (most rated among all exercises), I also would like to write a few words of appreciation project.
Firstly, when I first got into web-address bar "sql-ex.ru" I did not know about SQL practically nothing (Perhaps only the basic operators). I struggled with the learning phase for several months. I read the forum, I pestered tech support, asking for tips on difficult tasks. Only because it was terribly interesting to solve ingenious puzzles. And because I wanted to prepare to pass the exam in college. Then I even managed to perform tasks on rating stage (1'st and 2'nd) and get the Basic Requirement sertificate. However, in the end, I accidentally slept through an exam. *fail* ))), but it does not matter ...
It is important that this project really helped me. I learned about "sql-ex" by a fluke. "sql-ex" helped me learn how to write queries of any complexity. In fact, it was just fun to write sql-queries. Though, I thought that these skills (construct most hardest sql-queries) obviously don't need in my life. Because SQL is normally used only for simple selections from tables of local DB or web-DB. NOTHING OF THE KIND!!! As soon as I got a job "entry-level programmer" I understand how important is it to construct most hardest sql-queries. Often I am asked to write a crazy sql-queries with a mix of a dozen tables, with a variety of tricky partitions, etc... (Just for reporst or something else...). Often when I working it is necessary to use methods like "For XML Path", "XML nodes", etc. These methods have the documentation, but they are very rare in the tutorial books. In the exercises on this site, these methods are very common.
In general, whole-heartedly thank the project and all who support and develop.
Author Comment            page [1] 2 3 4




Home
Week news
Certification
SQL exercises
Forums
Ratings
HELP
Performance
Profile
References
Copyright SQL-EX © 2002-2024. All rights reserved.
contact