SQL exercises

June 04, 21:47 MSK

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.

Ratings

  • 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

Statistics

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

SQL exercises

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

Forums

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

Certification

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

HELP

Query optimization

For employers

Support SQL-EX.RU

То рено дастер
Все характеристики Рено Дастера, результаты тест драйва и цены на авто
reno-max.ru
Компьютерная помощь онлайн бесплатно
Бесплатная фэнтезийная онлайн-игра. Адреса магазинов.
liveexpert.ru

Top 100 results achieved on 10 latest exercises

(38DML, 39DML, 40DML, 41DML, 42DML, 12, 233, 234, 235, 262)

No	person	exs	score	minutes	last_ex
1	Chernov D.V. (Kursist)¹	10/10(2)	18	1185	sel 235 (2020-06-04)
2	Doschenko V.N. (mcrain)²	9/10(0)	17	3313	dml 42 (2020-04-08)
3	Koptel'tsev V. (selber)³⁵	9/10(2)	17	9345	sel 234 (2020-05-07)
4	Kreslavskij O.M. (Arcan)⁵	8/10(0)	14	142	sel 262 (2020-01-27)
5	Sigankov V.I. (vasilyvanc)³¹	8/10(0)	14	919	dml 42 (2019-12-02)
6	Krasovskij E.A. (pegoopik)³	8/10(1)	14	2068	dml 42 (2019-12-09)
7	Karasyova N.V. (vlksm)⁹	8/10(0)	14	2325	sel 262 (2020-04-25)
8	Filippkin D.V. (_dimon_)¹²	7/10(0)	13	418	sel 262 (2020-04-13)
9	Samarin A. (not.yet.sql.master)¹²⁸	6/10(0)	11	328	dml 42 (2020-05-09)
10	Milenkov (wqer)⁹⁵	6/10(0)	11	1916	dml 42 (2020-01-13)
11	Dubinskij A.V. (_velial)⁸	6/10(0)	11	3383	dml 42 (2019-12-25)
12	Varenikov D.M. (Dmitriy Varenikov)²⁰	6/10(0)	11	25048	dml 42 (2020-02-08)
13	Shkarednyj I.N. (Gosha)³⁴	7/10(1)	9	10206	sel 235 (2020-06-03)
14	Fedevych V.I. (labuch_fedev)³²	6/10(0)	7	320	sel 262 (2020-03-19)
15	Timofeeva E.V. (Umrikhina)²³	5/10(0)	7	333	dml 41 (2019-11-27)
16	Buldenkov D.A. (eXeQuThor)¹³⁰	5/10(0)	7	407	dml 41 (2019-10-28)
17	Fokin A. (Vizitor )⁴¹	5/10(0)	7	985	dml 41 (2019-08-16)
18	Dmitriev A. (Havr)¹⁴³	5/10(0)	7	1138	dml 41 (2019-07-30)
19	Vasilevskaya E.A. (kattiks)¹³⁶	5/10(0)	7	4089	sel 12 (2019-08-09)
20	Williams B. (BW)³⁶	5/10(0)	7	97156	dml 41 (2020-02-20)
21	Boiko D. (Angellore)⁶	5/10(0)	5	191	sel 12 (2019-05-23)
22	Kostomarov A.V. (al29)⁴	4/10(0)	5	10148	sel 262 (2019-06-25)
23	Latyntsev N.G. (aks_nsk)⁵⁰	4/10(0)	4	23	sel 12 (2019-05-11)
24	Kopylov A.V. (alegzey)²⁷⁵	4/10(0)	4	35	dml 40 (2019-09-02)
25	Petrov Y. (YuriPetrov)³³	4/10(0)	4	45	sel 12 (2019-07-04)
26	Balbekov A.G. (NtFire)²⁷⁹	4/10(0)	4	46	dml 40 (2019-09-03)
27	Zhulanov S.G. (borey.mdb)¹⁴²	4/10(0)	4	857	sel 12 (2019-07-20)
28	Kurochkin P.A. (qwrqwr)¹⁰	4/10(0)	4	1416	sel 12 (2019-04-14)
29	Pusev D.V. (Pusev_Denis)²⁹	4/10(0)	4	2209	sel 233 (2020-03-14)
30	Demin D. (demind74)¹³³	3/10(0)	3	19	dml 40 (2019-07-01)
31	Pyatiletov A. (MontaG)⁵⁵	3/10(0)	3	19	sel 12 (2019-06-30)
32	Osin V. (anyman1979)¹⁴⁴	3/10(0)	3	39	dml 40 (2019-11-03)
33	Panfilov A. (alexey.p4nfilov)¹³¹	3/10(0)	3	51	dml 40 (2019-06-06)
34	Pavlov A.V. (Anton)⁵⁶	3/10(0)	3	125	dml 40 (2019-06-03)
35	Verdiyev A. (Nuklinoid)⁷¹⁰	1/10(0)	1	5	sel 12 (2019-07-05)
36	Akhmedzyanov (datyzayebal)⁹⁹⁰	1/10(0)	1	8	sel 12 (2020-05-12)
37	alex (alex882)⁴⁰⁰	1/10(0)	1	8	sel 12 (2019-07-26)
38	Petropavlov (sqlstuding)²³⁸⁹	1/10(0)	1	9	sel 12 (2020-03-22)
39	Pronina (Nnet)⁵⁴⁵	1/10(0)	1	11	sel 12 (2019-07-10)
40	Medyakov A.V. (Sky34)¹³²³	1/10(0)	1	12	sel 12 (2020-05-02)
41	Gulyaev S. (sergey.g)³²⁶	1/10(0)	1	12	sel 12 (2019-07-02)
42	Neboronov M.M. (maksoooun)⁵⁷³	1/10(0)	1	13	sel 12 (2019-07-06)
43	Kisselev D. (ryan9)⁵⁹⁷	1/10(0)	1	16	sel 12 (2019-06-28)
44	Vanteev A.G. (vanteevart)³⁷⁴	1/10(0)	1	16	sel 12 (2019-08-30)
45	Lyubomudrov R.G. (PB-77)⁶⁸⁵	1/10(0)	1	16	sel 12 (2019-10-31)
46	Trukhina (anntrukhina)²⁹⁶⁶	1/10(0)	1	17	sel 12 (2020-05-22)
47	Yakovlev M.V. (MikhailYakovlev535)²¹⁴	1/10(0)	1	17	sel 12 (2019-07-09)
48	Khamidov D. (damirr)⁵¹¹	1/10(0)	1	17	sel 12 (2020-05-12)
49	Kharitskij D.K. (Rognak)³²⁹³	1/10(0)	1	19	sel 12 (2020-05-13)
50	Samorodov F.A. (Spetsialist)¹⁶²⁵	1/10(0)	1	19	sel 12 (2020-05-06)
51	Koletvinova A. (Poganka)³¹⁷	1/10(0)	1	19	sel 12 (2019-07-01)
52	Fomichev A.V. (Fomichev)¹⁶⁹	1/10(0)	1	20	sel 12 (2019-10-22)
53	Efimova V. (captainX)⁴⁹⁰	1/10(0)	1	21	sel 12 (2019-11-05)
54	Dedyukiev K. (ogir)¹⁰⁵²	1/10(0)	1	22	sel 12 (2020-04-29)
55	Smirnov S.V. (Wild_Sery)¹³³⁹	1/10(0)	1	22	sel 12 (2019-07-02)
56	Familiya (WereWolf777)¹¹⁸	1/10(0)	1	22	dml 38 (2018-12-11)
57	Kuanchaleev A.B. (Avangard)²⁴⁴	1/10(0)	1	22	sel 12 (2020-05-19)
58	Mityurin V. (mitvol)¹⁵⁹	1/10(0)	1	23	sel 12 (2020-05-27)
59	Azanov E.D. (Eugene_Azanov)⁹⁹⁸	1/10(0)	1	24	sel 12 (2020-05-14)
60	Borisenkov D.V. (xuser)⁹⁸	1/10(0)	1	25	sel 12 (2019-11-22)
61	Shalavin D.E. (Juster81)²⁵⁰	1/10(0)	1	25	sel 12 (2019-09-25)
62	Egorova E.A. (Egorova_Elena)⁴⁶³⁴	1/10(0)	1	25	sel 12 (2020-01-27)
63	Iskhokov F.S. (Faridun89)¹⁹¹⁷	1/10(0)	1	26	sel 12 (2020-04-23)
64	Valeev R.D. (ValRus)¹²²⁹	1/10(0)	1	27	sel 12 (2020-02-10)
65	Starodubtsev P. (PashaKirill)⁹⁸⁹	1/10(0)	1	27	sel 12 (2020-04-23)
66	Sokolov A.V. (Falcon06)⁶⁸³	1/10(0)	1	28	sel 12 (2020-04-03)
67	Zajtsev R.A. (PrideGoldFish)⁹²⁹	1/10(0)	1	28	sel 12 (2019-07-11)
68	Aronov O. (aronov.oleg)¹³⁷	1/10(0)	1	29	sel 12 (2019-12-19)
69	Burdenko Ya. (Bsl)¹¹³²	1/10(0)	1	30	sel 12 (2019-07-01)
70	Rebrin A. (Hydra86)⁷⁵³	1/10(0)	1	30	sel 12 (2019-06-30)
71	Ivanova S. (moonfish)¹¹⁶³	1/10(0)	1	30	sel 12 (2019-09-14)
72	Leschyov S.V. (SPMV)¹⁸⁰	1/10(0)	1	30	dml 38 (2019-01-07)
73	Tarshin S.N. (tsn)¹⁵⁴	1/10(0)	1	30	sel 12 (2019-07-01)
74	Kvochkin V. (ASEVlad)¹¹³³	1/10(0)	1	31	sel 12 (2020-01-10)
75	Mamichev S.G. (SergeyMamichev)¹²⁵³	1/10(0)	1	31	sel 12 (2020-04-26)
76	Pantileenko D. (iriswind1)³⁶⁵	1/10(0)	1	31	sel 12 (2019-08-09)
77	Gireiko E. (Zubryonok)²⁵⁶	1/10(0)	1	34	sel 12 (2019-09-05)
78	Russkikh A. (mandarinchik)⁴⁶⁴	1/10(0)	1	34	sel 12 (2020-01-25)
79	bitsadze K.R. (furie)²⁹⁷	1/10(0)	1	38	sel 12 (2019-09-04)
80	Kudravtsev V.S. (Vitaliy_Kudravtsev)⁹³⁸	1/10(0)	1	38	sel 12 (2019-11-08)
81	Gajchuk A.S. (asgaychuk)³⁶⁶	1/10(0)	1	39	sel 12 (2019-08-19)
82	Petrova K.O. (Lanelia)¹⁵⁸³	1/10(0)	1	41	sel 12 (2020-05-17)
83	Chechulin (Sinde)¹³⁰³	1/10(0)	1	41	sel 12 (2020-02-18)
84	Murtazaliev M.G. (Magmur)¹²⁵⁶	1/10(0)	1	41	sel 12 (2020-05-04)
85	Nazhestkin I.A. (gausseuler60)⁴⁵⁸⁶	1/10(0)	1	44	sel 12 (2019-07-04)
86	Yolokhov V.Yu. (Vladimir Elokhov)³⁵⁴²	1/10(0)	1	46	sel 12 (2019-10-17)
87	Ostrovskij A.A. (aleost)³³⁵	1/10(0)	1	47	sel 12 (2019-07-04)
88	Alborov K.R. (albor)⁵⁷²	1/10(0)	1	50	sel 12 (2019-07-03)
89	Lazareva E. (lea_22)³⁴⁹	1/10(0)	1	50	sel 12 (2019-07-18)
90	Savin A.Yu. (mirovingin)³¹³	1/10(0)	1	51	sel 12 (2019-08-12)
91	Antunez Garcia F. (antunez)¹⁵²¹	1/10(0)	1	51	sel 12 (2020-03-11)
92	Poroshkova (vvvvvloi)⁷⁷⁰	1/10(0)	1	51	sel 12 (2020-04-02)
93	Sajgakova A.V. (Ametist)²⁸⁶	1/10(0)	1	52	sel 12 (2019-07-06)
94	Filatova O.E. (PolitechFox)¹⁰⁷⁶	1/10(0)	1	54	sel 12 (2019-06-30)
95	Dudochkin A. (dandr)⁴¹⁴	1/10(0)	1	55	sel 12 (2019-11-15)
96	Grishunin M.F. (MikhailFG)⁸⁶	1/10(0)	1	57	dml 38 (2018-12-10)
97	Vasil'ev A.A. (TruthFinder)⁷⁴⁰	1/10(0)	1	59	sel 12 (2019-07-08)
98	Baskakov A. (solertia)⁵¹⁷	1/10(0)	1	64	sel 12 (2020-03-17)
99	Igor (Igor_lai)¹¹⁹³	1/10(0)	1	66	sel 12 (2019-10-04)
100	Chukanov V.S. (VSC)⁴⁴⁰	1/10(0)	1	66	sel 12 (2020-03-17)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References