SQL exercises

May 30, 07:19 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, 40, 233, 234, 262)

No	person	exs	score	minutes	last_ex
1	Chernov D.V. (Kursist)¹	10/10(2)	18	1188	sel 234 (2020-02-28)
2	Doschenko V.N. (mcrain)²	10/10(0)	18	3000	dml 42 (2020-04-08)
3	Koptel'tsev V. (selber)³⁵	10/10(2)	18	8183	sel 234 (2020-05-07)
4	Kreslavskij O.M. (Arcan)⁵	9/10(0)	15	130	sel 262 (2020-01-27)
5	Sigankov V.I. (vasilyvanc)³¹	9/10(0)	15	854	dml 42 (2019-12-02)
6	Krasovskij E.A. (pegoopik)³	9/10(1)	15	1813	dml 42 (2019-12-09)
7	Karasyova N.V. (vlksm)⁹	9/10(0)	15	2076	sel 262 (2020-04-25)
8	Filippkin D.V. (_dimon_)¹²	8/10(0)	14	381	sel 262 (2020-04-13)
9	Samarin A. (not.yet.sql.master)¹²⁸	7/10(0)	12	283	dml 42 (2020-05-09)
10	Milenkov (wqer)⁹⁵	7/10(0)	12	2050	dml 42 (2020-01-13)
11	Dubinskij A.V. (_velial)⁸	7/10(0)	12	2914	dml 42 (2019-12-25)
12	Varenikov D.M. (Dmitriy Varenikov)²⁰	7/10(0)	12	22498	dml 42 (2020-02-08)
13	Shkarednyj I.N. (Gosha)³⁴	7/10(0)	9	9001	sel 233 (2019-08-06)
14	Fedevych V.I. (labuch_fedev)³²	7/10(0)	8	281	sel 262 (2020-03-19)
15	Timofeeva E.V. (Umrikhina)²³	6/10(0)	8	281	dml 41 (2019-11-27)
16	Buldenkov D.A. (eXeQuThor)¹³⁰	6/10(0)	8	344	dml 41 (2019-10-28)
17	Fokin A. (Vizitor )⁴¹	6/10(0)	8	836	dml 41 (2019-08-16)
18	Dmitriev A. (Havr)¹⁴³	6/10(0)	8	1480	dml 41 (2019-07-30)
19	Vasilevskaya E.A. (kattiks)¹³⁶	6/10(0)	8	3445	sel 12 (2019-08-09)
20	Williams B. (BW)³⁶	6/10(0)	8	81405	dml 41 (2020-02-20)
21	Boiko D. (Angellore)⁶	6/10(0)	6	414	sel 12 (2019-05-23)
22	Kostomarov A.V. (al29)⁴	5/10(0)	6	8389	sel 262 (2019-06-25)
23	Latyntsev N.G. (aks_nsk)⁵⁰	5/10(0)	5	43	sel 12 (2019-05-11)
24	Petrov Y. (YuriPetrov)³³	5/10(0)	5	44	sel 12 (2019-07-04)
25	Kopylov A.V. (alegzey)²⁷⁵	5/10(0)	5	61	dml 40 (2019-09-02)
26	Balbekov A.G. (NtFire)²⁷⁹	5/10(0)	5	131	dml 40 (2019-09-03)
27	Zhulanov S.G. (borey.mdb)¹⁴²	5/10(0)	5	974	sel 12 (2019-07-20)
28	Kurochkin P.A. (qwrqwr)¹⁰	5/10(0)	5	1137	sel 12 (2019-04-14)
29	Pusev D.V. (Pusev_Denis)²⁹	5/10(0)	5	1785	sel 233 (2020-03-14)
30	Demin D. (demind74)¹³³	4/10(0)	4	21	dml 40 (2019-07-01)
31	Pyatiletov A. (MontaG)⁵⁵	4/10(0)	4	23	sel 12 (2019-06-30)
32	Panfilov A. (alexey.p4nfilov)¹³¹	4/10(0)	4	54	dml 40 (2019-06-06)
33	Pavlov A.V. (Anton)⁵⁶	4/10(0)	4	225	sel 40 (2019-06-04)
34	Osin V. (anyman1979)¹⁴⁴	3/10(0)	3	39	dml 40 (2019-11-03)
35	Azanov E.D. (Eugene_Azanov)⁹⁹⁷	2/10(0)	2	23	sel 40 (2020-05-19)
36	Zajtsev R.A. (PrideGoldFish)⁹²⁷	2/10(0)	2	24	sel 40 (2019-07-14)
37	Starodubtsev P. (PashaKirill)⁹⁸⁸	2/10(0)	2	25	sel 40 (2020-05-21)
38	Akhmedzyanov (datyzayebal)⁹⁸⁹	2/10(0)	2	26	sel 40 (2020-05-14)
39	Khamidov D. (damirr)⁵¹¹	2/10(0)	2	26	sel 40 (2020-05-15)
40	Efimova V. (captainX)⁴⁹⁰	2/10(0)	2	29	sel 40 (2020-03-13)
41	Familiya (WereWolf777)¹¹⁸	2/10(0)	2	35	sel 40 (2019-01-07)
42	Neboronov M.M. (maksoooun)⁵⁷³	2/10(0)	2	36	sel 12 (2019-07-06)
43	Kvochkin V. (ASEVlad)¹¹³³	2/10(0)	2	39	sel 40 (2020-01-25)
44	Borisenkov D.V. (xuser)⁹⁸	2/10(0)	2	40	sel 40 (2019-11-22)
45	Kisselev D. (ryan9)⁵⁹⁷	2/10(0)	2	41	sel 12 (2019-06-28)
46	Yakovlev M.V. (MikhailYakovlev535)²²⁸	2/10(0)	2	44	sel 12 (2019-07-09)
47	Tarshin S.N. (tsn)¹⁵⁴	2/10(0)	2	46	sel 12 (2019-07-01)
48	Vasil'ev A.A. (TruthFinder)⁷⁴⁰	2/10(0)	2	46	sel 40 (2019-10-06)
49	Burdenko Ya. (Bsl)¹¹³²	2/10(0)	2	48	sel 40 (2019-10-19)
50	Gireiko E. (Zubryonok)²⁵⁶	2/10(0)	2	57	sel 12 (2019-09-05)
51	Filatova O.E. (PolitechFox)¹⁰⁷⁶	2/10(0)	2	58	sel 40 (2019-07-08)
52	Podmarev E.A. (Podmarev)⁶¹²	2/10(0)	2	64	sel 40 (2020-04-12)
53	Burmistrov V.V. (Razorkell)³⁵³	2/10(0)	2	65	sel 40 (2019-08-07)
54	Safonov A.A. (funnym33)⁴⁹⁹	2/10(0)	2	69	sel 40 (2019-08-16)
55	Kuydinov D. (sh4rk717)⁶⁷⁰	2/10(0)	2	77	sel 40 (2019-09-21)
56	Shalavin D.E. (Juster81)²⁵⁰	2/10(0)	2	77	sel 40 (2019-09-25)
57	Rebrin A. (Hydra86)⁷⁵³	2/10(0)	2	80	sel 12 (2019-06-30)
58	Lyubomudrov R.G. (PB-77)⁶⁸⁵	2/10(0)	2	81	sel 40 (2019-11-06)
59	Litvinov V.V. (NewsMan)²⁵⁷	2/10(0)	2	81	sel 12 (2019-09-04)
60	Baskakov A. (solertia)⁵¹⁷	2/10(0)	2	90	sel 40 (2020-03-23)
61	Popov S.V. (PopovSV)⁷⁵⁵	2/10(0)	2	92	sel 40 (2019-09-23)
62	Komarov A.N. (Shveda Saulya)³¹⁷	2/10(0)	2	99	sel 40 (2020-03-02)
63	Chukanov V.S. (VSC)⁴³⁹	2/10(0)	2	103	sel 12 (2020-03-17)
64	Pronina (Nnet)⁵⁴⁵	2/10(0)	2	104	sel 40 (2019-07-10)
65	Novozhilov A. (BertokMo)⁶⁷³	2/10(0)	2	107	sel 40 (2020-02-13)
66	Tymochko T. (Sunny_boy)⁷⁵⁸	2/10(0)	2	108	sel 40 (2020-01-15)
67	Alborov K.R. (albor)⁵⁷²	2/10(0)	2	108	sel 12 (2019-07-03)
68	Ushakov A.K. (andrew_ushakov)³⁶⁴	2/10(0)	2	112	sel 40 (2020-02-03)
69	Solov'yov E.I. (ty7ic)³⁸⁹	2/10(0)	2	112	sel 12 (2019-07-01)
70	Leschyov S.V. (SPMV)¹⁸⁰	2/10(0)	2	119	dml 38 (2019-01-07)
71	Kon'kov D. (training123)⁷¹⁹	2/10(0)	2	120	sel 12 (2019-07-04)
72	Shabanov R.R. (Vertel)¹¹⁴⁰	2/10(0)	2	122	sel 12 (2019-11-13)
73	Chmelyov G.A. (Grigory630)¹¹⁵²	2/10(0)	2	123	sel 40 (2020-04-18)
74	Krasavin A.A. (alexey.krasavin)⁶⁴¹	2/10(0)	2	125	sel 40 (2019-09-25)
75	Pantileenko D. (iriswind1)³⁶⁵	2/10(0)	2	134	sel 40 (2019-08-09)
76	Poroshkova (vvvvvloi)⁸⁶⁷	2/10(0)	2	148	sel 40 (2020-05-06)
77	Verdiyev A. (Nuklinoid)⁷¹⁰	2/10(0)	2	172	sel 12 (2019-07-05)
78	Grebla A.I. (A1412)⁵⁵⁸	2/10(0)	2	177	sel 12 (2019-06-29)
79	Gribkov (Lenarino)⁵⁶⁷	2/10(0)	2	192	sel 40 (2019-09-01)
80	Legoshin V.V. (Vasiliy Legoshin)⁷⁵⁹	2/10(0)	2	195	sel 40 (2020-05-22)
81	Smolyar P. (smolyar)⁹⁸¹	2/10(0)	2	219	sel 40 (2020-05-06)
82	Grishunin M.F. (MikhailFG)⁸⁶	2/10(0)	2	229	sel 40 (2019-01-25)
83	Mikhed (am37)¹¹⁶⁴	2/10(0)	2	239	sel 40 (2020-03-09)
84	Shmigirev A.E. (Shmigirev)³⁹⁰	2/10(0)	2	260	sel 40 (2019-07-02)
85	Tyannikov V.P. (TVP)³¹³	2/10(0)	2	266	sel 40 (2020-02-14)
86	Sazonov A.V. (AlexSZ)⁷²³	2/10(0)	2	314	sel 40 (2019-09-20)
87	Arzamasov M.A. (Michael.Arz)⁴⁵²	2/10(0)	2	327	sel 12 (2019-09-05)
88	Bogdanov K.A. (KAB956)³⁷⁶	2/10(0)	2	432	sel 40 (2019-07-13)
89	Nikolaj (Bulocka_c_izumom)⁴²⁷	2/10(0)	2	434	sel 40 (2020-03-09)
90	Igumnov (HermanI)⁴⁷⁰	2/10(0)	2	469	sel 40 (2020-01-03)
91	alex (alex882)⁴⁰⁰	2/10(0)	2	495	sel 12 (2019-07-26)
92	Vestnikov D.A. (letsstudybegin)³²²	2/10(0)	2	576	sel 12 (2019-07-10)
93	Egorov A.Yu. (Anthe)⁷¹⁸	2/10(0)	2	601	sel 40 (2019-12-24)
94	Nechaeva O.A. (Nechaeva Olga)²⁹²	2/10(0)	2	620	sel 40 (2020-01-31)
95	Selezen' A.N. (Artny)³²⁵	2/10(0)	2	667	sel 12 (2019-07-01)
96	Stepanov A.S. (Stepanov Aleksej)⁷⁶⁵	2/10(0)	2	711	sel 40 (2019-07-29)
97	Zemlyanukhin N.V. (NIKITA123321)⁷⁶³	2/10(0)	2	732	sel 40 (2019-07-16)
98	Lazareva E. (lea_22)³⁴⁹	2/10(0)	2	770	sel 12 (2019-07-18)
99	Golubeva (Sutie)⁷³⁶	2/10(0)	2	772	sel 40 (2019-09-19)
100	Vasyaeva N.A. (V_Natali)³⁰⁷	2/10(0)	2	779	sel 40 (2019-12-12)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References