SQL exercises January 09, 11:24 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

Distribution of the certificated professionals by age (percentage)
About certification All Certified Professionals

Age Percent

Under 30 years old 1.7

Between 30 and 40 25.2

Between 40 and 50 50.3

After 50 years old 22.8

Representation of the certificated professionals by regions

id_cont id_reg Region Qty Percent

1 37 MOSKVA (Russia) 378 39.4

2 32 UKRAINE 81 8.4

1 67 SANKT-PETERBURG (Russia) 67 7.0

1 48 NOVOSIBIRSK (Russia) 38 4.0

1 63 ROSTOV-NA-DONU (Russia) 23 2.4

2 3 BELARUS 20 2.1

1 21 EKATERINBURG (Russia) 20 2.1

1 6 BARNAUL (Russia) 19 2.0

1 58 PERM' (Russia) 16 1.7

1 30 KRASNODAR (Russia) 14 1.5

8 3 KAZAKHSTAN 13 1.4

1 82 UFA (Russia) 12 1.3

1 45 NIZhNIJ NOVGOROD (Russia) 10 1.0

1 68 SARATOV (Russia) 10 1.0

1 69 SMOLENSK (Russia) 9 0.9

1 90 TULA (Russia) 9 0.9

1 66 SAMARA (Russia) 8 0.8

1 19 VORONEZh (Russia) 7 0.7

1 25 KAZAN' (Russia) 7 0.7

1 89 YaROSLAVL' (Russia) 7 0.7

3 16 ISRAEL 6 0.6

1 4 ARKhANGEL'SK (Russia) 6 0.6

1 94 KALUGA (Russia) 6 0.6

1 29 KOSTROMA (Russia) 6 0.6

1 31 KRASNOYaRSK (Russia) 6 0.6

1 85 ChELYaBINSK (Russia) 6 0.6

1 15 VLADIVOSTOK (Russia) 5 0.5

1 24 IRKUTSK (Russia) 5 0.5

1 98 LIPETsK (Russia) 5 0.5

1 64 RYaZAN' (Russia) 5 0.5

1 93 TAMBOV (Russia) 5 0.5

1 75 TOMSK (Russia) 5 0.5

1 92 ChEBOKSARY (Russia) 5 0.5

1 87 ChITA (Russia) 5 0.5

1 5 ASTRAKhAN' (Russia) 4 0.4

1 8 BELGOROD (Russia) 4 0.4

1 97 KALININGRAD (Russia) 4 0.4

1 102 KURSK (Russia) 4 0.4

1 57 PENZA (Russia) 4 0.4

1 78 ULAN-UDE (Russia) 4 0.4

2 23 MOLDOVA 3 0.3

2 25 POLAND 3 0.3

6 11 USA 3 0.3

1 16 VOLGOGRAD (Russia) 3 0.3

1 23 IZhEVSK (Russia) 3 0.3

1 32 KURGAN (Russia) 3 0.3

1 47 NOVOKUZNETsK (Russia) 3 0.3

1 52 OREL (Russia) 3 0.3

1 53 ORENBURG (Russia) 3 0.3

1 95 STAVROPOL' (Russia) 3 0.3

1 72 TVER' (Russia) 3 0.3

1 77 TYuMEN' (Russia) 3 0.3

1 101 UL'YaNOVSK (Russia) 3 0.3

5 1 AUSTRALIA 2 0.2

8 2 AZERBAIJAN 2 0.2

2 8 DENMARK 2 0.2

2 10 ENGLAND 2 0.2

8 8 GEORGIA 2 0.2

1 1 ABAKAN (Russia) 2 0.2

1 100 VLADIMIR (Russia) 2 0.2

1 17 VOLOGDA (Russia) 2 0.2

1 99 KEMEROVO (Russia) 2 0.2

1 46 NOVGOROD (Russia) 2 0.2

1 51 OMSK (Russia) 2 0.2

1 71 SYKTYVKAR (Russia) 2 0.2

1 83 KhABAROVSK (Russia) 2 0.2

1 70 KhANTY-MANSIJSK (Russia) 2 0.2

1 91 ELISTA (Russia) 2 0.2

7 4 BRAZIL 1 0.1

6 2 CANADA 1 0.1

4 13 EGYPT 1 0.1

2 11 ESTONIA 1 0.1

2 13 FRANCE 1 0.1

2 20 ITALY 1 0.1

2 21 LATVIA 1 0.1

2 22 LITHVA 1 0.1

5 3 NEW ZEALAND 1 0.1

8 5 TAJIKISTAN 1 0.1

3 22 Thailand 1 0.1

8 6 TURKMENISTAN 1 0.1

1 10 BLAGOVESchENSK (Russia) 1 0.1

1 13 BRYaNSK (Russia) 1 0.1

1 96 VLADIKAVKAZ (Russia) 1 0.1

1 105 Gorno-Altajsk (Russia) 1 0.1

1 106 Joshkar-Ola (Russia) 1 0.1

1 12 MAKhAChKALA (Russia) 1 0.1

1 38 MURMANSK (Russia) 1 0.1

1 42 NERYuNGRI (Russia) 1 0.1

1 44 NIZhNEVARTOVSK (Russia) 1 0.1

1 104 Saransk (Russia) 1 0.1

1 103 YuZhNO-SAKhALINSK (Russia) 1 0.1

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

Distribution of the certificated professionals by age (percentage) About certification All Certified Professionals

Representation of the certificated professionals by regions

Distribution of the certificated professionals by age (percentage)
About certification All Certified Professionals