SQL exercises

August 04, 18:06 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

(39DML, 40DML, 41DML, 42DML, 43DML, 12, 112, 233, 234, 262)

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

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References