SQL exercises January 05, 17:02 MSK ???-100

SQL Exercises is intended for acquiring good practical experience, which is focused on data operation, namely on SQL DML. Certain exercises for beginners are provided on the site, they are supplied with the necessary reference source on SQL syntax with a great number of examples. Apart from them, 3 rating stages are suggested, they are aimed at testing of specialists and their certification. The source is absolutely free of charge, and the certificate purchase has a voluntary basis.
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.

 • Top 100
 • Top 100 on latest exercises
 • "Liberal" rating
 • Olympic rating
 • TOP 100 of Learning Stage
 • Rating by summation of ranks
 • Top 10 (photos)
 • Last-week results
 • Rating of second-stage exercises (average)
 • Rating of 2nd-stage exercises (median)
 • Author's rating • 2nd stage rating up to exercise:
  enter No 
 • Rating on the exercise:
  enter No
 • Optimistic rating
  enter factor

 • Today statistics
 • Site's old residents
 • Recent leaders activity
 • Сhanges in exercises' TOP 10
 • Results' chart

 • Site rules
 • SELECT (learning stage)
 • SELECT (learning stage,
   choosing DBMS)
 • SELECT (rating stages)
 • DML 
 • Transact-SQL tests
 • Data simulation
 • Data simulation (DML);
 • Visual simulation (painting)
 • Exercises voting (SELECT)
 • Exercises voting (DML)

 • Learning stage
 • Rating stages
 • Favorites
 • Search
 • Blogs

 • About certification
 • Certified professionals
 • Statistics
 • Statistics over regions (map)
 • Confirm certificate

• SQL(DML) help
• SQL Tutorial
• FAQ
• Guide to Exercise Authors
• Databases' scripts
• Download books
• Send message

• Query plan
• Rating by cost
• Optimization competition rules
• Optimization competition

For employers

Support SQL-EX.RU

Comparative graphs of solution's time and queries' performance on cost's estimation of the performance's plan (SELECT)

To add the graph of the participant, enter his nickname and press the button "+" (the maximum of 5 participants is allowed). Then rebuild graphs with help of the "GO" button.
To clear the list of participants, press button "CLEAR". After changing the parametrs (such as scale's type and number of points on graph) press button "GO" to rebuild the graph.

Add nickname to the list:

Participant list

Detailed navigation:

Type of graph By solution's time
By estimated cost

Show the graph of average rating

Show the graph of minimal cost

Show the graph of last cost

[フレーム]

Home
Week news

• Certified professionals
• Statistics

• SELECT (learning stage)
• SELECT (learn, choose DBMS)
• SELECT (rating stages)
• DML
• Data simulation

• Learning stage
• Rating stages
• Favorites
• Search

• Top 100
• Today statistics
• Recent leaders activity • Rating of 2nd-stage exercises (median)

• SQL(DML) help
• SQL Tutorial
• FAQ
• Send message

• Query plan
• Rating by cost
• Optimization competition

Profile
References