SQL exercises Language  December 20, 05:12 MSK
Login:

Password:

forgot password?
Registration

Transact-SQL tests
Modelling of data
Personal
page
Exercises voting
Developers & Thanks
For employers
References
Feedback
Support SQL-EX.RU



Poll
Would you get the following certificate?
Yes
No
Such certificate is necessary on a site, but not for me
Probably I would get it for supporting the project
Such certificate is unnecessary one



View Results
AddThis Social Bookmark Button
Номинант Премии Рунета 2005

Site news 2014-11-08
All the news    Week news
Certified within this week:

Borschev I.A. (borsch)


Confirm certificate
Happy Birthday to:
Zryumov E.A. (Zryumov)
Nikotin V.M. (@Nikotin)
!!!

New on SQL-EX.RU Certified professionals on the Google map.
Databases' scripts can now be loaded on the site: download.
Now You can solve the learn-stage's exercises with using Oracle also.

There are exercises on SELECT statement (presently 123 exercises on learn stage and 213 exercises on rating stages) and on other data manipulation operators - INSERT, UPDATE, DELETE (25 exercises). The rating of members is carried on SELECT exercises. See
test conditions.
Interactive SQL ebook The book "SQL. Problems and solutions" , which is analyzing the characteristic mistakes admitted at the solution of the learn-stage exercises on the site, was originally published in Peter Publishing Company.

Locations of visitors to this page
Newsletters of our site (in Russian) on Subscribe.Ru:
Read last news letter


прочитать чужие смс
Today we have 74 visitors (12 new).
16 exercises solved (0 on SELECT and 16 on DML),
on learning stage - 143



  

Practical skills of SQL language

This site will help everyone to gain or improve skills in building SQL Data Manipulation Language statements. To train You will have to build yourself the SQL statements for retrieval or modification of specific data required in the exercises. When Your query is incorrect, You will be able to see rows returned by the correct query along with that returned by Your query. Furthermore, you may execute arbitrary DML statements on available databases by setting the "Without checking" option. There are four levels of difficulty (from 1 to 4), You may see it in second column of exercises list. We propose the exercises on retrieving data (SELECT statement) and the exercises on modifying data (INSERT, UPDATE, and DELETE statements). Your success in the solving the exercises are shown by a rating of participants. As this takes place, there are three stages: the first one (first 15 exercises) is performed without time control for an individual exercise, the second one (begins with the exercise #16) controls time for completion of each task. At the third stage which refers to optimizing and begins with exercise #139, it is required not only to solve an exercise correctly, but also time of execution of inquiry should be commensurable with time of execution of the author's solution.
Exercises of the first stage are available without registration and may be solved in any order You like. The solution of the rest of exercises requires registration. REGISTRATION IS FREE as this for all other services of the site. In the third column of exercises list You will be able to see ("OK") notes with the numbers of done exercises, but that is available only to the registered users. In fact, that is the main reason for registration. If You would like to visit our web site again, You won't have to recollect which exercises You have done already and which You haven't. If You don't want to register, You may enter as a guest, but in that case Your results won't be traced by the system. Registered users also may discuss the solutions to exercises in our forum.

NOTE: The query stated incorrectly may return the "correct" data on a current state of database. For this reason You should not be surprised if the results of incorrect query are coincide with the results of right one with Your query is estimated as incorrect by the Verifying system.

NOTE: Your browser should support Cookies and Javascript to provide correct usage of this site. If you use content filter, it should allow opening child windows to explore help pages.

Certification

Successful testing of yours can be confirmed by the certificate "SQL Data Manipulation Language Specialist". We support quality of our certificate by periodically replacing exercises and changing the certificate requirements. More about certification. What does the certificate give to you?

SQL syntax used

User's queries are executed by SQL server that brings some limitations to the syntax of SQL statements. Now we use Microsoft SQL Server 2012 on the rating stages, and MySQL 5.5.11, PostgreSQL 9.0, and Oracle Database 11g on the learn stage in addition. That is why You should follow the syntax of these realizations when building queries. It should be noted that SQL syntax, implemented in Microsoft SQL Server, is close to that of SQL-92 standard. But there are some distinctions, among them is absence of NATURAL JOIN of tables. Supplied help on SQL Data Manipulation Language is held in accordance with SQL-92 standard and contains information necessary for solving the exercises. In the same place it is possible to find features of used realization (SQL Server 2005).

Top 10 results

Person ScoresDaysDays_2 Days_3Scores_3
Filippkin D.V. (_dimon_) 5762128188.032 121.723 198
Bezhaev A.Yu. (Baser) 5761637162.739 140.533 198
Kreslavskij O.M. (Arcan) 5762824234.256 178.343 198
Kurochkin P.A. (qwrqwr) 5731812232.975 159.138 195
Boiko D. (Angellore) 57126653277.320 1687.159 193
Karasyova N.V. (vlksm) 5673126231.095 182.922 189
Sal'nikov S.A. ($erges) 547248516.887 13.871 170
Yatsuk A.A. (Faust_zp) 4761985144.239 108.840 137
Kuznetsov V.S. (herrRo) 4351170478.617 73.335 122
Kukushkin S.A. (smog) 4781345944.171 1062.788 121

Top 100 | Candidates
Last-week results
Rating of second-stage exercises (average)
Site news
Week news
Profile
References
Rambler's Top100
Copyright SQL-EX © 2002-2013. All rights reserved.
contact