SQL exercises

July 27, 12:53 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)¹	9/10(3)	16	1512	sel 235 (2021-07-10)
3	Kreslavskij O.M. (Arcan)⁵	8/10(0)	13	82	sel 235 (2021-07-14)
4	Sigankov V.I. (vasilyvanc)³¹	8/10(0)	13	557	sel 235 (2021-07-18)
5	Karasyova N.V. (vlksm)⁹	7/10(0)	11	2031	dml 44 (2021-05-05)
6	Varenikov D.M. (Dmitriy Varenikov)¹⁹	7/10(0)	11	6251	sel 7 (2021-03-24)
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	Kurochkin P.A. (qwrqwr)¹⁰	6/10(0)	9	1786	sel 7 (2021-03-11)
10	Slepnev S.V. (SergSlep)¹⁴¹	6/10(0)	9	4365	sel 7 (2021-07-12)
11	Gireiko E. (Zubryonok)¹⁴²	5/10(0)	8	45	dml 44 (2021-04-19)
12	Matveeva D.D. (darya_matveeva)¹⁴⁰	5/10(0)	8	928	dml 44 (2021-04-08)
13	Litvinov V.V. (NewsMan)¹⁴³	5/10(0)	8	1025	dml 44 (2021-04-04)
14	Petrov Y. (YuriPetrov)³⁴	5/10(0)	8	1757	sel 112 (2021-05-26)
15	Milenkov (wqer)⁹⁶	5/10(0)	8	1836	dml 44 (2021-03-08)
16	Komarov A.N. (Shveda Saulya)⁷⁰	5/10(0)	8	2093	dml 44 (2021-01-29)
17	Dubinskij A.V. (_velial)⁸	5/10(0)	8	3176	sel 57 (2021-02-23)
18	Konotopov S. (kinkou)¹⁴⁴	5/10(0)	8	6329	sel 112 (2021-02-15)
19	Kostomarov A.V. (al29)²	5/10(0)	8	55686	sel 234 (2021-04-17)
20	Shkarednyj I.N. (Gosha)³⁵	5/10(1)	8	81846	dml 44 (2021-01-25)
21	Yakovlev M.V. (MikhailYakovlev535)¹³⁰	3/10(0)	6	1708	sel 57 (2021-07-24)
22	Krasovskij E.A. (pegoopik)⁴	2/10(0)	6	4941	dml 42 (2019-12-09)
23	Fedevych V.I. (labuch_fedev)³³	4/10(0)	5	71	sel 112 (2021-07-20)
24	Samarin A. (not.yet.sql.master)¹²⁹	1/10(0)	4	460	dml 42 (2020-05-09)
25	Nikolaj (Bulocka_c_izumom)¹⁷²	3/10(0)	3	430	sel 7 (2021-07-11)
26	Komov K.N. (zigmund1)¹⁹⁸	3/10(0)	3	4690	sel 7 (2021-07-19)
27	Yartsev Yu. (Yury66)¹⁸⁵	3/10(0)	3	54778	sel 7 (2021-07-23)
28	Bezhaev A.Yu. (Baser)⁷	2/10(2)	2		sel 236 (2021-07-24)
29	Zajtsev V.S. (Sleeping)²³	2/10(0)	2	55	sel 112 (2020-11-03)
30	Chebykin D.N. (GriGrim)³⁷	2/10(0)	2	57	sel 112 (2020-12-19)
31	Mitroshin D.G. (d_mit)²⁸⁸	2/10(0)	2	74	sel 7 (2021-07-12)
32	Markin N. (Qmaro)⁴⁹⁰	2/10(0)	2	484	sel 7 (2021-07-16)
33	Il'in A.N. (ani42)³⁶⁶	2/10(0)	2	535	sel 57 (2021-07-15)
34	Akol'zin M.S. (maksimok2991)¹⁹⁶	2/10(0)	2	618	sel 112 (2021-03-14)
35	Kozlov V. (SN 209)¹³⁴	2/10(0)	2	740	sel 112 (2021-07-05)
36	Popov S.V. (PopovSV)⁷³⁴	2/10(0)	2	835	sel 7 (2021-07-19)
37	Novikov (PNA921)¹⁷³	2/10(0)	2	1552	sel 57 (2021-01-15)
38	Lyaschenko S.N. (pimen78)³⁹⁰	2/10(0)	2	1730	sel 7 (2021-07-16)
39	Lazareva E. (lea_22)³²³	2/10(0)	2	2170	sel 7 (2021-07-13)
40	Cherpak V.E. (OakTree)⁵⁸⁴	2/10(0)	2	2901	sel 7 (2021-07-22)
41	Kalyuzhnyj D.S. (mazepa)²⁷⁴	2/10(0)	2	92072	sel 57 (2021-07-18)
42	Yakushev E.A. (Ejhi)⁹⁶⁹	1/10(0)	1	40	sel 7 (2021-07-16)
43	Yatsenko A.A. (YmKa98)²⁵⁷⁷	1/10(0)	1	49	sel 7 (2021-07-21)
44	Tarshin S.N. (tsn)¹⁶¹	1/10(0)	1	62	sel 112 (2020-07-30)
45	Aronov O. (aronov.oleg)¹³⁹	1/10(0)	1	67	sel 57 (2020-12-09)
46	Pusev D.V. (Pusev_Denis)¹⁷	1/10(0)	1	75	sel 112 (2020-06-06)
47	Mikhailov S. (curiouser)³²⁷	1/10(0)	1	86	sel 57 (2020-11-18)
48	Sergeev (post_prog)⁵³¹	1/10(0)	1	114	sel 57 (2021-01-01)
49	Markov (yaroslavv)⁷⁵⁰	1/10(0)	1	116	sel 57 (2020-12-14)
50	Zakharchenko S. (SergeyZ06)¹⁷³⁸	1/10(0)	1	120	sel 7 (2021-07-27)
51	Gajchuk A.S. (asgaychuk)³⁶⁴	1/10(0)	1	132	sel 57 (2021-05-21)
52	Zhdanov K.V. (scuder)⁴⁷³	1/10(0)	1	163	sel 57 (2021-04-03)
53	gls G.G. (gls52)⁴⁰⁷	1/10(0)	1	169	sel 57 (2020-12-11)
54	Zelentsov I.A. (Overcomzi)⁷⁴⁹	1/10(0)	1	173	sel 57 (2021-02-10)
55	Boldyrev G.V. (grif85)¹²²⁸	1/10(0)	1	196	sel 7 (2021-07-23)
56	Petrov D.B. (GiBis)²⁷⁵	1/10(0)	1	237	sel 57 (2020-12-04)
57	Prokof'eva I.V. (IrinaP)⁷⁴⁸	1/10(0)	1	248	sel 57 (2021-01-12)
58	Vestnikov D.A. (letsstudybegin)²⁷³	1/10(0)	1	359	sel 57 (2021-01-17)
59	ol O. (svinokiller)⁴³³	1/10(0)	1	396	sel 57 (2021-05-06)
60	Gubarev L.I. (Livan)⁴³¹	1/10(0)	1	607	sel 57 (2021-02-15)
61	Krasavin A.A. (alexey.krasavin)⁶³²	1/10(0)	1	665	sel 57 (2021-02-17)
62	Marchenkov (Decoe)⁷⁰⁸	1/10(0)	1	898	sel 57 (2021-03-22)
63	Kasumov M.M. (MaratKasumov)⁴⁷⁷	1/10(0)	1	907	sel 57 (2021-01-04)
64	Trofimov (learn_jack)³³²	1/10(0)	1	1061	sel 57 (2020-11-17)
65	Kuydinov D. (sh4rk717)⁶⁴³	1/10(0)	1	1142	sel 57 (2021-03-21)
66	Krylosov A.Yu. (Alexey Kry)⁷⁵⁶	1/10(0)	1	1200	sel 57 (2021-05-28)
67	Vasil'ev A.A. (TruthFinder)⁴⁵⁵	1/10(0)	1	1248	sel 57 (2020-12-08)
68	Zhdamorev (zda)²¹⁴	1/10(0)	1	1305	sel 57 (2021-01-29)
69	Solov'yov E.I. (ty7ic)³³⁹	1/10(0)	1	1316	sel 57 (2021-07-07)
70	Rzazade N.M. (Natiq849)⁴⁷⁸	1/10(0)	1	1382	sel 57 (2021-06-01)
71	Tatsyuk O.A. (archi_98)⁶²¹	1/10(0)	1	1510	sel 57 (2021-02-18)
72	Svitochev I.O. (Svitochev)³⁴²	1/10(0)	1	1555	sel 57 (2020-12-08)
73	Vasilevskaya E.A. (kattiks)¹³⁸	1/10(0)	1	1564	sel 57 (2021-04-18)
74	Khomutova (anzhela6660)¹⁰⁰⁶	1/10(0)	1	1566	sel 57 (2021-06-11)
75	Ikramov R. (ARNET)⁵⁴⁰	1/10(0)	1	1574	sel 57 (2021-01-09)
76	Gurin A.S. (SenyaGurin)⁶⁸⁰	1/10(0)	1	1581	sel 57 (2021-06-25)
77	Kostyushko Yu.V. (kostushko)³⁴⁷	1/10(0)	1	1611	sel 57 (2021-04-27)
78	Drozdov A.S. (ELVISNEVERDIES1)⁶³⁶	1/10(0)	1	1635	sel 57 (2020-12-21)
79	Pravdyuk R.M. (Pro100geniy)⁷⁵⁴	1/10(0)	1	1769	sel 57 (2020-11-15)
80	Yanin M.Yu. (Mikhkha)⁷²⁷	1/10(0)	1	2758	sel 57 (2021-04-05)
81	Ladanov N.V. (XAKEP_BBC)⁷⁶³	1/10(0)	1	2792	sel 57 (2020-11-28)
82	Ivanovv V.V. (vvaannyaya)²³⁵¹	1/10(0)	1	3181	sel 7 (2021-07-21)
83	Dmitrenko (Ben_Fra)⁴⁷⁸⁸	1/10(0)	1	3225	sel 7 (2021-07-23)
84	Yarovaya Yu.V. (YuliyaYar)⁷⁶⁷	1/10(0)	1	3248	sel 57 (2021-05-26)
85	SmirnOFF (select0r)⁷⁶⁵	1/10(0)	1	3494	sel 57 (2021-04-01)
86	Rodionov S. (oldos)³³¹	1/10(0)	1	3912	sel 57 (2021-02-27)
87	Vlasov (HandKot_)¹⁷⁶	1/10(0)	1	4333	sel 57 (2021-02-19)
88	bitsadze K.R. (furie)²⁴⁴	1/10(0)	1	4757	sel 57 (2021-06-07)
89	Sajfullina E.F. (elena-fairy)⁶²³	1/10(0)	1	5478	sel 57 (2021-05-28)
90	Menyajlo S.S. (Kagerorus)⁷⁶⁹	1/10(0)	1	5943	sel 57 (2021-01-30)
91	Smol'nikova M.A. (fora)⁵³⁴	1/10(0)	1	7001	sel 57 (2020-12-01)
92	Shustov V.V. (shustovvlad)⁶⁵⁷	1/10(0)	1	8639	sel 57 (2020-11-30)
93	Kokunina M.V. (Liss-miss)⁷⁵³	1/10(0)	1	9863	sel 57 (2021-04-12)
94	Veselov A.N. (almw)⁵⁰⁵	1/10(0)	1	10013	sel 57 (2021-01-21)
95	Novozhilov A. (BertokMo)⁶⁷⁴	1/10(0)	1	10543	sel 57 (2021-03-16)
96	Russkikh A. (mandarinchik)³⁹⁵	1/10(0)	1	11194	sel 57 (2021-03-12)
97	Koletvinova A. (Poganka)³²¹	1/10(0)	1	19183	sel 57 (2021-03-14)
98	Savin A.Yu. (mirovingin)²⁵⁸	1/10(0)	1	24260	sel 57 (2021-04-02)
99	Shmigirev A.E. (Shmigirev)³⁹⁴	1/10(0)	1	29261	sel 57 (2021-07-07)
100	Antunez Garcia F. (antunez)⁷⁶⁸	1/10(0)	1	54483	sel 57 (2021-02-18)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References