SQL exercises

September 18, 03:38 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 (SELECT)
  • Exercises voting (DML)

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

(42DML, 43DML, 44DML, 7, 57, 112, 234, 235, 236, 262)

No	person	exs	score	minutes	last_ex
1	Koptel'tsev V. (selber)³¹	10/10(2)	17	1077	sel 236 (2021-07-25)
2	Chernov D.V. (Kursist)¹	10/10(3)	17	1311	sel 236 (2021-08-02)
3	Sigankov V.I. (vasilyvanc)³⁰	9/10(0)	14	510	sel 236 (2021-08-14)
4	Varenikov D.M. (Dmitriy Varenikov)¹⁹	9/10(0)	14	5381	sel 235 (2021-08-13)
5	Kreslavskij O.M. (Arcan)⁵	8/10(0)	13	82	sel 235 (2021-07-14)
6	Karasyova N.V. (vlksm)⁹	8/10(0)	12	1792	sel 236 (2021-07-29)
7	Filippkin D.V. (_dimon_)¹¹	6/10(0)	10	78	dml 44 (2021-02-17)
8	Doschenko V.N. (mcrain)³	4/10(0)	10	2127	dml 43 (2020-06-24)
9	Litvinov V.V. (NewsMan)¹⁴¹	6/10(0)	9	861	sel 7 (2021-09-10)
10	Petrov Y. (YuriPetrov)³⁴	6/10(0)	9	1468	sel 7 (2021-08-15)
11	Kurochkin P.A. (qwrqwr)¹⁰	6/10(0)	9	1786	sel 7 (2021-03-11)
12	Slepnev S.V. (SergSlep)¹⁴²	6/10(0)	9	4365	sel 7 (2021-07-12)
13	Shkarednyj I.N. (Gosha)³⁵	6/10(1)	9	68663	sel 7 (2021-08-17)
14	Gireiko E. (Zubryonok)¹⁴³	5/10(0)	8	45	dml 44 (2021-04-19)
15	Matveeva D.D. (darya_matveeva)¹⁴⁰	5/10(0)	8	928	dml 44 (2021-04-08)
16	Milenkov (wqer)⁹⁶	5/10(0)	8	1836	dml 44 (2021-03-08)
17	Komarov A.N. (Shveda Saulya)⁷⁰	5/10(0)	8	2093	dml 44 (2021-01-29)
18	Filipas I.M. (Axocopan)⁴⁰¹	5/10(0)	8	2402	dml 44 (2021-09-11)
19	Dubinskij A.V. (_velial)⁸	5/10(0)	8	3176	sel 57 (2021-02-23)
20	Konotopov S. (kinkou)¹⁴⁴	5/10(0)	8	6329	sel 112 (2021-02-15)
21	Kostomarov A.V. (al29)²	5/10(0)	8	55686	sel 234 (2021-04-17)
22	Yakovlev M.V. (MikhailYakovlev535)¹³⁰	4/10(0)	7	1296	sel 7 (2021-07-28)
23	Krasovskij E.A. (pegoopik)⁴	2/10(0)	6	4941	dml 42 (2019-12-09)
24	Fedevych V.I. (labuch_fedev)³³	4/10(0)	5	71	sel 112 (2021-07-20)
25	Samarin A. (not.yet.sql.master)¹²⁹	1/10(0)	4	460	dml 42 (2020-05-09)
26	Zajtsev V.S. (Sleeping)²²	3/10(0)	3	42	sel 7 (2021-09-07)
27	Nikolaj (Bulocka_c_izumom)¹⁷³	3/10(0)	3	430	sel 7 (2021-07-11)
28	Tarshin S.N. (tsn)¹⁵⁶	3/10(0)	3	2541	sel 57 (2021-08-23)
29	Komov K.N. (zigmund1)¹⁹²	3/10(0)	3	4690	sel 7 (2021-07-19)
30	Yartsev Yu. (Yury66)¹⁸⁵	3/10(0)	3	54778	sel 7 (2021-07-23)
31	Boiko D. (Angellore)⁶	3/10(0)	3	94029	sel 112 (2021-09-04)
32	Bezhaev A.Yu. (Baser)⁷	2/10(2)	2		sel 236 (2021-07-24)
33	Chebykin D.N. (GriGrim)³⁷	2/10(0)	2	57	sel 112 (2020-12-19)
34	Mitroshin D.G. (d_mit)²⁵⁵	2/10(0)	2	74	sel 7 (2021-07-12)
35	gls G.G. (gls52)³⁴⁹	2/10(0)	2	124	sel 7 (2021-08-24)
36	Zelentsov I.A. (Overcomzi)⁷³⁸	2/10(0)	2	162	sel 7 (2021-09-12)
37	Markin N. (Qmaro)⁴⁹³	2/10(0)	2	484	sel 7 (2021-07-16)
38	Il'in A.N. (ani42)²⁰²	2/10(0)	2	535	sel 57 (2021-07-15)
39	Akol'zin M.S. (maksimok2991)¹⁹⁷	2/10(0)	2	618	sel 112 (2021-03-14)
40	Solov'yov E.I. (ty7ic)³⁰⁶	2/10(0)	2	692	sel 7 (2021-07-29)
41	Zhdamorev (zda)²⁰⁴	2/10(0)	2	699	sel 7 (2021-09-08)
42	Kozlov V. (SN 209)¹³⁴	2/10(0)	2	740	sel 112 (2021-07-05)
43	Drozdov A.S. (ELVISNEVERDIES1)⁵⁵⁶	2/10(0)	2	829	sel 7 (2021-08-16)
44	Popov S.V. (PopovSV)⁷³⁶	2/10(0)	2	835	sel 7 (2021-07-19)
45	Kuydinov D. (sh4rk717)⁶³⁴	2/10(0)	2	866	sel 7 (2021-07-27)
46	Novikov (PNA921)¹⁵⁸	2/10(0)	2	1552	sel 57 (2021-01-15)
47	Lyaschenko S.N. (pimen78)²⁹⁰	2/10(0)	2	1730	sel 7 (2021-07-16)
48	Lazareva E. (lea_22)³²⁶	2/10(0)	2	2170	sel 7 (2021-07-13)
49	Cherpak V.E. (OakTree)⁵⁸⁶	2/10(0)	2	2901	sel 7 (2021-07-22)
50	Gubarev L.I. (Livan)⁴²⁸	2/10(0)	2	4607	sel 7 (2021-08-23)
51	Khomutova (anzhela6660)⁷⁴⁹	2/10(0)	2	4796	sel 7 (2021-08-09)
52	Novozhilov A. (BertokMo)⁶⁶³	2/10(0)	2	5357	sel 7 (2021-08-19)
53	bitsadze K.R. (furie)²⁴⁴	2/10(0)	2	6575	sel 7 (2021-09-06)
54	Veselov A.N. (almw)⁴³⁹	2/10(0)	2	14251	sel 7 (2021-08-04)
55	Antunez Garcia F. (antunez)⁶⁷⁵	2/10(0)	2	27946	sel 7 (2021-07-29)
56	Kalyuzhnyj D.S. (mazepa)²⁷⁶	2/10(0)	2	92072	sel 57 (2021-07-18)
57	Yakushev E.A. (Ejhi)⁹⁷¹	1/10(0)	1	40	sel 7 (2021-07-16)
58	Yatsenko A.A. (YmKa98)²⁵⁸²	1/10(0)	1	49	sel 7 (2021-07-21)
59	Aronov O. (aronov.oleg)¹³⁹	1/10(0)	1	67	sel 57 (2020-12-09)
60	Pusev D.V. (Pusev_Denis)¹⁷	1/10(0)	1	75	sel 112 (2020-06-06)
61	Mikhailov S. (curiouser)³³⁰	1/10(0)	1	86	sel 57 (2020-11-18)
62	Kinder M.M. (Kind)³⁴⁰	1/10(0)	1	93	sel 7 (2021-09-10)
63	Avdeev A. (Energo-a)²¹⁷⁷	1/10(0)	1	94	sel 7 (2021-09-12)
64	Sergeev (post_prog)⁵³²	1/10(0)	1	114	sel 57 (2021-01-01)
65	Markov (yaroslavv)⁷⁵³	1/10(0)	1	116	sel 57 (2020-12-14)
66	Zakharchenko S. (SergeyZ06)¹²⁵¹	1/10(0)	1	120	sel 7 (2021-07-27)
67	Mikhed A.V. (am37)⁷¹⁸	1/10(0)	1	126	sel 7 (2021-08-30)
68	Gajchuk A.S. (asgaychuk)³⁶⁷	1/10(0)	1	132	sel 57 (2021-05-21)
69	Zhdanov K.V. (scuder)⁴⁷⁵	1/10(0)	1	163	sel 57 (2021-04-03)
70	Boldyrev G.V. (grif85)¹²³⁰	1/10(0)	1	196	sel 7 (2021-07-23)
71	Morzhov M.S. (Galliot)¹⁹¹¹	1/10(0)	1	203	sel 7 (2021-09-03)
72	Petrov D.B. (GiBis)²⁷⁷	1/10(0)	1	237	sel 57 (2020-12-04)
73	Prokof'eva I.V. (IrinaP)⁷⁵²	1/10(0)	1	248	sel 57 (2021-01-12)
74	Vestnikov D.A. (letsstudybegin)²⁷⁵	1/10(0)	1	359	sel 57 (2021-01-17)
75	ol O. (svinokiller)⁴³⁴	1/10(0)	1	396	sel 57 (2021-05-06)
76	Krasavin A.A. (alexey.krasavin)⁶³⁵	1/10(0)	1	665	sel 57 (2021-02-17)
77	Fedakov A.P. (Aleksa2021)¹⁸⁷⁷	1/10(0)	1	730	sel 7 (2021-09-04)
78	Marchenkov (Decoe)⁷¹⁰	1/10(0)	1	898	sel 57 (2021-03-22)
79	Kasumov M.M. (MaratKasumov)⁴⁷⁹	1/10(0)	1	907	sel 57 (2021-01-04)
80	Tikhonov A. (_Saw)⁴⁸⁹	1/10(0)	1	962	sel 7 (2021-08-27)
81	Trofimov (learn_jack)³³⁵	1/10(0)	1	1061	sel 57 (2020-11-17)
82	Krylosov A.Yu. (Alexey Kry)⁷⁵⁹	1/10(0)	1	1200	sel 57 (2021-05-28)
83	Vasil'ev A.A. (TruthFinder)⁴⁵⁷	1/10(0)	1	1248	sel 57 (2020-12-08)
84	Rzazade N.M. (Natiq849)⁴⁸⁰	1/10(0)	1	1382	sel 57 (2021-06-01)
85	Tatsyuk O.A. (archi_98)⁶²³	1/10(0)	1	1510	sel 57 (2021-02-18)
86	Svitochev I.O. (Svitochev)³⁴⁴	1/10(0)	1	1555	sel 57 (2020-12-08)
87	Vasilevskaya E.A. (kattiks)¹³⁸	1/10(0)	1	1564	sel 57 (2021-04-18)
88	Ikramov R. (ARNET)⁵⁴¹	1/10(0)	1	1574	sel 57 (2021-01-09)
89	Gurin A.S. (SenyaGurin)⁶⁸²	1/10(0)	1	1581	sel 57 (2021-06-25)
90	Kostyushko Yu.V. (kostushko)³⁵¹	1/10(0)	1	1611	sel 57 (2021-04-27)
91	Pravdyuk R.M. (Pro100geniy)⁷⁵⁷	1/10(0)	1	1769	sel 57 (2020-11-15)
92	Yanin M.Yu. (Mikhkha)⁷³⁰	1/10(0)	1	2758	sel 57 (2021-04-05)
93	Ladanov N.V. (XAKEP_BBC)⁷⁶⁶	1/10(0)	1	2792	sel 57 (2020-11-28)
94	Ivanovv V.V. (vvaannyaya)²³⁵⁶	1/10(0)	1	3181	sel 7 (2021-07-21)
95	Dmitrenko (Ben_Fra)⁴⁴⁸²	1/10(0)	1	3225	sel 7 (2021-07-23)
96	Yarovaya Yu.V. (YuliyaYar)⁷⁷⁰	1/10(0)	1	3248	sel 57 (2021-05-26)
97	SmirnOFF (select0r)⁷⁶⁸	1/10(0)	1	3494	sel 57 (2021-04-01)
98	Rodionov S. (oldos)³³⁴	1/10(0)	1	3912	sel 57 (2021-02-27)
99	Vlasov (HandKot_)¹⁷⁶	1/10(0)	1	4333	sel 57 (2021-02-19)
100	Sajfullina E.F. (elena-fairy)⁶²⁵	1/10(0)	1	5478	sel 57 (2021-05-28)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References