SQL exercises

January 18, 14:25 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
семинары по экологии
ipkspb.ru

Top 100 results achieved on 10 latest exercises

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

No	person	exs	score	minutes	last_ex
1	Chernov D.V. (Kursist)¹	10/10(3)	18	1303	sel 57 (2020-10-10)
2	Koptel'tsev V. (selber)³¹	10/10(2)	18	1740	sel 57 (2020-10-13)
3	Doschenko V.N. (mcrain)²	8/10(0)	16	3612	dml 43 (2020-06-24)
4	Kreslavskij O.M. (Arcan)⁵	9/10(0)	15	125	sel 57 (2020-10-10)
5	Filippkin D.V. (_dimon_)¹¹	9/10(0)	15	330	sel 112 (2021-01-08)
6	Sigankov V.I. (vasilyvanc)³⁰	9/10(0)	15	811	sel 57 (2020-10-11)
7	Karasyova N.V. (vlksm)⁹	9/10(0)	15	1911	dml 43 (2020-11-18)
8	Varenikov D.M. (Dmitriy Varenikov)¹⁹	9/10(0)	15	16988	sel 57 (2020-12-10)
9	Komarov A.N. (Shveda Saulya)¹¹⁹	8/10(0)	13	1799	sel 57 (2020-12-20)
10	Shkarednyj I.N. (Gosha)³⁴	8/10(1)	13	55454	sel 57 (2020-11-16)
11	Kurochkin P.A. (qwrqwr)¹⁰	8/10(0)	13	98755	dml 43 (2020-12-14)
12	Milenkov (wqer)⁹⁵	7/10(0)	12	2147	sel 57 (2020-12-28)
13	Dubinskij A.V. (_velial)⁸	7/10(0)	12	2905	sel 112 (2020-08-27)
14	K S. (kinkou)³²²	7/10(0)	12	5414	dml 43 (2021-01-11)
15	Krasovskij E.A. (pegoopik)³	6/10(0)	12	2411	dml 42 (2019-12-09)
16	Yakovlev M.V. (MikhailYakovlev535)¹³⁰	6/10(0)	11	1107	dml 43 (2020-07-08)
17	Samarin A. (not.yet.sql.master)¹²⁹	5/10(0)	10	391	dml 42 (2020-05-09)
18	Slepnev S.V. (SergSlep)⁴²⁰	5/10(0)	7	1467	dml 41 (2021-01-08)
19	Timofeeva E.V. (Umrikhina)²⁴	4/10(0)	6	412	dml 41 (2019-11-27)
20	Buldenkov D.A. (eXeQuThor)¹³²	4/10(0)	6	506	dml 41 (2019-10-28)
21	Fokin A. (Vizitor )⁴¹	4/10(0)	6	1229	dml 41 (2019-08-16)
22	Dmitriev A. (Havr)¹⁴⁶	4/10(0)	6	1414	dml 41 (2019-07-30)
23	Vasilevskaya E.A. (kattiks)¹³⁹	4/10(0)	6	5106	sel 12 (2019-08-09)
24	Williams B. (BW)³⁶	4/10(0)	6	121443	dml 41 (2020-02-20)
25	Kostomarov A.V. (al29)⁴	4/10(0)	5	90	sel 57 (2020-11-30)
26	Fedevych V.I. (labuch_fedev)³³	4/10(0)	5	124	sel 262 (2020-03-19)
27	Boiko D. (Angellore)⁶	3/10(0)	3	20	sel 12 (2019-05-23)
28	Latyntsev N.G. (aks_nsk)⁵⁰	3/10(0)	3	24	sel 12 (2019-05-11)
29	Gireiko E. (Zubryonok)¹⁸¹	3/10(0)	3	29	sel 112 (2020-12-04)
30	Kopylov A.V. (alegzey)²⁸⁴	3/10(0)	3	38	dml 40 (2019-09-02)
31	Chebykin D.N. (GriGrim)³⁷	3/10(0)	3	42	sel 112 (2020-12-19)
32	Balbekov A.G. (NtFire)²⁸⁸	3/10(0)	3	43	dml 40 (2019-09-03)
33	Petrov Y. (YuriPetrov)³⁵	3/10(0)	3	57	sel 12 (2019-07-04)
34	Pusev D.V. (Pusev_Denis)¹⁸	3/10(0)	3	69	sel 112 (2020-06-06)
35	Zajtsev V.S. (Sleeping)²³	3/10(0)	3	86	sel 12 (2020-11-04)
36	Litvinov V.V. (NewsMan)¹⁷⁸	3/10(0)	3	164	sel 112 (2020-11-28)
37	bitsadze K.R. (furie)²³⁸	3/10(0)	3	537	dml 40 (2020-10-01)
38	Nikolaj (Bulocka_c_izumom)²⁷⁰	3/10(0)	3	586	sel 112 (2020-12-27)
39	Zhulanov S.G. (borey.mdb)¹⁴⁵	3/10(0)	3	851	sel 12 (2019-07-20)
40	Novikov (PNA921)²¹⁵	3/10(0)	3	1551	sel 57 (2021-01-15)
41	Osin V. (anyman1979)¹⁴⁸	2/10(0)	2	12	dml 40 (2019-11-03)
42	Demin D. (demind74)¹³⁵	2/10(0)	2	19	dml 40 (2019-07-01)
43	Pyatiletov A. (MontaG)⁵⁵	2/10(0)	2	20	sel 12 (2019-06-30)
44	Panfilov A. (alexey.p4nfilov)¹³³	2/10(0)	2	40	dml 40 (2019-06-06)
45	Pavlov A.V. (Anton)⁵⁶	2/10(0)	2	45	dml 40 (2019-06-03)
46	Tarshin S.N. (tsn)¹⁵⁶	2/10(0)	2	46	sel 112 (2020-07-30)
47	Aronov O. (aronov.oleg)¹³⁷	2/10(0)	2	48	sel 57 (2020-12-09)
48	Sergeev (post_prog)⁶¹¹	2/10(0)	2	84	sel 57 (2021-01-01)
49	Prokof'eva I.V. (IrinaP)⁸⁵⁴	2/10(0)	2	208	sel 57 (2021-01-12)
50	Vestnikov D.A. (letsstudybegin)³¹²	2/10(0)	2	236	sel 57 (2021-01-17)
51	Petrov D.B. (GiBis)²⁶⁸	2/10(0)	2	264	sel 57 (2020-12-04)
52	Markov (yaroslavv)⁷³³	2/10(0)	2	299	sel 57 (2020-12-14)
53	Vasil'ev A.A. (TruthFinder)⁵⁴⁹	2/10(0)	2	653	sel 57 (2020-12-08)
54	Akol'zin M.S. (maksimok2991)¹¹⁸⁰	2/10(0)	2	683	sel 57 (2021-01-18)
55	Yartsev Yu. (Yury66)²¹¹	2/10(0)	2	792	sel 112 (2020-08-27)
56	Kasumov M.M. (MaratKasumov)⁴⁷⁰	2/10(0)	2	812	sel 57 (2021-01-04)
57	Svitochev I.O. (Svitochev)³³⁵	2/10(0)	2	815	sel 57 (2020-12-08)
58	Drozdov A.S. (ELVISNEVERDIES1)⁶⁹³	2/10(0)	2	832	sel 57 (2020-12-21)
59	gls G.G. (gls52)³⁹⁹	2/10(0)	2	913	sel 57 (2020-12-11)
60	Cherpak V.E. (OakTree)⁵⁸⁴	2/10(0)	2	1268	sel 57 (2020-11-19)
61	Trofimov (learn_jack)³²⁶	2/10(0)	2	1316	sel 57 (2020-11-17)
62	Ikramov R. (ARNET)⁵⁵¹	2/10(0)	2	1409	sel 57 (2021-01-09)
63	Ladanov N.V. (XAKEP_BBC)⁷⁴⁵	2/10(0)	2	2009	sel 57 (2020-11-28)
64	Lazareva E. (lea_22)³⁴⁹	2/10(0)	2	2087	sel 57 (2020-11-19)
65	Mikhailov S. (curiouser)³⁴⁶	2/10(0)	2	3049	sel 57 (2020-11-18)
66	Pravdyuk R.M. (Pro100geniy)⁷³⁶	2/10(0)	2	3150	sel 57 (2020-11-15)
67	Smol'nikova M.A. (fora)⁵²⁴	2/10(0)	2	4060	sel 57 (2020-12-01)
68	Chernikova D.D. (darya_chernikova)²⁷²	2/10(0)	2	5369	sel 57 (2020-12-16)
69	Komov K.N. (zigmund1)²³⁷	2/10(0)	2	6646	sel 57 (2020-12-28)
70	Shustov V.V. (shustovvlad)⁶⁴⁴	2/10(0)	2	61234	sel 57 (2020-11-30)
71	Verdiyev A. (Nuklinoid)⁶⁷⁶	1/10(0)	1	5	sel 12 (2019-07-05)
72	Maksimov A.A. (AntonMaksimov77778888)⁴⁹⁰⁷	1/10(0)	1	6	sel 12 (2020-07-09)
73	Belyaev (andruwa)¹⁰¹⁷	1/10(0)	1	8	sel 12 (2020-05-12)
74	alex (alex882)⁴⁰⁸	1/10(0)	1	8	sel 12 (2019-07-26)
75	Petropavlov (sqlstuding)²⁵⁵⁹	1/10(0)	1	9	sel 12 (2020-03-22)
76	Kuz'mitskij Ya.O. (YaroslavYaroslav)¹⁰⁵⁶	1/10(0)	1	10	sel 12 (2020-06-19)
77	Pronina (Nnet)⁵⁵⁸	1/10(0)	1	11	sel 12 (2019-07-10)
78	Ovsyankin V.S. (Kazaam)¹⁴⁴	1/10(0)	1	11	sel 12 (2020-08-23)
79	Gulyaev S. (sergey.g)³³⁰	1/10(0)	1	12	sel 12 (2019-07-02)
80	Medyakov A.V. (Sky34)¹³⁶⁵	1/10(0)	1	12	sel 12 (2020-05-02)
81	Neboronov M.M. (maksoooun)⁵⁸⁹	1/10(0)	1	13	sel 12 (2019-07-06)
82	Vanteev A.G. (vanteevart)³⁸¹	1/10(0)	1	16	sel 12 (2019-08-30)
83	Lyubomudrov R.G. (PB-77)⁷⁰⁵	1/10(0)	1	16	sel 12 (2019-10-31)
84	Kisselev D. (ryan9)⁶¹³	1/10(0)	1	16	sel 12 (2019-06-28)
85	Khamidov D. (damirr)³⁶⁰	1/10(0)	1	17	sel 12 (2020-05-12)
86	Trukhina (anntrukhina)³²⁶⁶	1/10(0)	1	17	sel 12 (2020-05-22)
87	Gorshelev M.O. (eximka)³⁵⁹	1/10(0)	1	18	sel 12 (2020-09-23)
88	Samorodov F.A. (Spetsialist)¹⁶⁷²	1/10(0)	1	19	sel 12 (2020-05-06)
89	Koletvinova A. (Poganka)³²⁰	1/10(0)	1	19	sel 12 (2019-07-01)
90	Kharitskij D.K. (Rognak)⁷⁵⁴	1/10(0)	1	19	sel 12 (2020-05-13)
91	Fomichev A.V. (Fomichev)¹⁷¹	1/10(0)	1	20	sel 12 (2019-10-22)
92	Efimova V. (captainX)⁵⁰⁰	1/10(0)	1	21	sel 12 (2019-11-05)
93	Smirnov S.V. (Wild_Sery)¹³⁸⁰	1/10(0)	1	22	sel 12 (2019-07-02)
94	Sh (Prokastinatsiya)³⁷⁵⁴	1/10(0)	1	22	sel 12 (2020-10-30)
95	Kuanchaleev A.B. (Avangard)²⁵²	1/10(0)	1	22	sel 12 (2020-05-19)
96	Dedyukiev K. (ogir)¹⁰⁸¹	1/10(0)	1	22	sel 12 (2020-04-29)
97	Mityurin V. (mitvol)¹⁶¹	1/10(0)	1	23	sel 12 (2020-05-27)
98	Azanov E.D. (Eugene_Azanov)¹⁰²⁷	1/10(0)	1	24	sel 12 (2020-05-14)
99	Borisenkov D.V. (xuser)⁹⁸	1/10(0)	1	25	sel 12 (2019-11-22)
100	Shalavin D.E. (Juster81)²⁵⁹	1/10(0)	1	25	sel 12 (2019-09-25)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References