SQL exercises

December 02, 07:41 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, 45DML, 7, 57, 112, 234, 235, 236)

No	person	exs	score	minutes	last_ex
1	Koptel'tsev V. (selber)³⁰	10/10(2)	20	1077	dml 45 (2021-11-27)
2	Chernov D.V. (Kursist)¹	10/10(3)	20	1482	dml 45 (2021-11-28)
3	Sigankov V.I. (vasilyvanc)³¹	8/10(0)	12	500	sel 236 (2021-08-14)
4	Varenikov D.M. (Dmitriy Varenikov)¹⁹	8/10(0)	12	5870	sel 235 (2021-08-13)
5	Kreslavskij O.M. (Arcan)⁵	7/10(0)	11	78	sel 235 (2021-07-14)
6	Karasyova N.V. (vlksm)⁹	7/10(0)	10	1969	sel 236 (2021-07-29)
7	Gireiko E. (Zubryonok)¹³²	6/10(0)	9	41	sel 7 (2021-09-20)
8	Litvinov V.V. (NewsMan)¹³³	6/10(0)	9	861	sel 7 (2021-09-10)
9	Petrov Y. (YuriPetrov)³⁴	6/10(0)	9	1468	sel 7 (2021-08-15)
10	Komarov A.N. (Shveda Saulya)⁶⁷	6/10(0)	9	1746	sel 7 (2021-10-22)
11	Kurochkin P.A. (qwrqwr)¹⁰	6/10(0)	9	1786	sel 7 (2021-03-11)
12	Novikov P.A. (PNA921)¹⁴⁵	6/10(0)	9	2761	sel 7 (2021-11-02)
13	Slepnev S.V. (SergSlep)¹⁴⁴	6/10(0)	9	4365	sel 7 (2021-07-12)
14	Il'in A.N. (ani42)¹³⁰	6/10(0)	9	6105	sel 112 (2021-10-20)
15	Shkarednyj I.N. (Gosha)³⁵	6/10(1)	9	68663	sel 7 (2021-08-17)
16	Filippkin D.V. (_dimon_)¹¹	5/10(0)	8	80	dml 44 (2021-02-17)
17	Matveeva D.D. (darya_matveeva)¹⁴³	5/10(0)	8	928	dml 44 (2021-04-08)
18	Milenkov (wqer)⁹⁶	5/10(0)	8	1836	dml 44 (2021-03-08)
19	Filipas I.M. (Axocopan)²²⁵	5/10(0)	8	2402	dml 44 (2021-09-11)
20	Dubinskij A.V. (_velial)⁸	5/10(0)	8	3176	sel 57 (2021-02-23)
21	Konotopov S. (kinkou)¹⁴⁶	5/10(0)	8	6329	sel 112 (2021-02-15)
22	Doschenko V.N. (mcrain)³	3/10(0)	8	2633	dml 43 (2020-06-24)
23	Yakovlev M.V. (MikhailYakovlev535)¹³¹	4/10(0)	7	1296	sel 7 (2021-07-28)
24	Kostomarov A.V. (al29)²	4/10(0)	6	69572	sel 234 (2021-04-17)
25	Samarin A. (not.yet.sql.master)¹²⁹	1/10(0)	4	460	dml 42 (2020-05-09)
26	Krasovskij E.A. (pegoopik)⁴	1/10(0)	4	9837	dml 42 (2019-12-09)
27	Zajtsev V.S. (Sleeping)²²	3/10(0)	3	42	sel 7 (2021-09-07)
28	Fedevych V.I. (labuch_fedev)³³	3/10(0)	3	59	sel 112 (2021-07-20)
29	Nikolaj (Bulocka_c_izumom)¹⁷⁴	3/10(0)	3	430	sel 7 (2021-07-11)
30	Tarshin S.N. (tsn)¹⁵³	3/10(0)	3	2541	sel 57 (2021-08-23)
31	Komov K.N. (zigmund1)¹⁸⁵	3/10(0)	3	4690	sel 7 (2021-07-19)
32	Yartsev Yu. (Yury66)¹⁸⁷	3/10(0)	3	54778	sel 7 (2021-07-23)
33	Boiko D. (Angellore)⁶	3/10(0)	3	94029	sel 112 (2021-09-04)
34	Bezhaev A.Yu. (Baser)⁷	2/10(2)	2		sel 236 (2021-07-24)
35	Boyarskij V.A. (ChronoMorzh)⁵⁷⁴	2/10(0)	2	51	sel 57 (2021-10-11)
36	Chebykin D.N. (GriGrim)³⁷	2/10(0)	2	57	sel 112 (2020-12-19)
37	Mikhailov S. (curiouser)³³¹	2/10(0)	2	59	sel 7 (2021-11-22)
38	Mitroshin D.G. (d_mit)²⁵⁹	2/10(0)	2	74	sel 7 (2021-07-12)
39	Gapanovich P.A. (drestar1)²⁵⁴	2/10(0)	2	105	sel 57 (2021-09-18)
40	gls G.G. (gls52)²⁴⁷	2/10(0)	2	124	sel 7 (2021-08-24)
41	Zelentsov I.A. (Overcomzi)⁶³⁸	2/10(0)	2	162	sel 7 (2021-09-12)
42	Zakharchenko S. (SergeyZ06)⁷⁴⁸	2/10(0)	2	218	sel 57 (2021-11-08)
43	Markin N. (Qmaro)⁴⁹⁶	2/10(0)	2	484	sel 7 (2021-07-16)
44	Akol'zin M.S. (maksimok2991)¹⁹⁸	2/10(0)	2	618	sel 112 (2021-03-14)
45	Rylov A.V. (LexaR2D2)⁴⁷³	2/10(0)	2	636	sel 57 (2021-11-29)
46	Solov'yov E.I. (ty7ic)³⁰⁹	2/10(0)	2	692	sel 7 (2021-07-29)
47	Zhdamorev (zda)²⁰⁵	2/10(0)	2	699	sel 7 (2021-09-08)
48	Kozlov V. (SN 209)¹³⁷	2/10(0)	2	740	sel 112 (2021-07-05)
49	Drozdov A.S. (ELVISNEVERDIES1)⁵⁴⁸	2/10(0)	2	829	sel 7 (2021-08-16)
50	Popov S.V. (PopovSV)⁷⁴⁵	2/10(0)	2	835	sel 7 (2021-07-19)
51	Fulman N. (Nir_)⁴⁶²	2/10(0)	2	837	sel 57 (2021-11-01)
52	Kuydinov D. (sh4rk717)⁶⁴¹	2/10(0)	2	866	sel 7 (2021-07-27)
53	Ladanov N.V. (XAKEP_BBC)⁴⁵⁵	2/10(0)	2	1403	sel 7 (2021-10-25)
54	Lyaschenko S.N. (pimen78)²⁸²	2/10(0)	2	1730	sel 7 (2021-07-16)
55	SmirnOFF (select0r)⁷⁵⁵	2/10(0)	2	1770	sel 7 (2021-10-16)
56	Lazareva E. (lea_22)³³⁰	2/10(0)	2	2170	sel 7 (2021-07-13)
57	Avdeev A. (Energo-a)⁵⁸⁹	2/10(0)	2	2858	sel 57 (2021-10-26)
58	Cherpak V.E. (OakTree)⁵⁹²	2/10(0)	2	2901	sel 7 (2021-07-22)
59	Tsuranov E.V. (Tsuranov Eduard)⁵²⁵	2/10(0)	2	3992	sel 57 (2021-10-02)
60	Gubarev L.I. (Livan)⁴²⁹	2/10(0)	2	4607	sel 7 (2021-08-23)
61	Mahammadli M. (mahammadali25)⁷²⁰	2/10(0)	2	4763	sel 57 (2021-10-20)
62	Khomutova (anzhela6660)⁷¹²	2/10(0)	2	4796	sel 7 (2021-08-09)
63	Novozhilov A. (BertokMo)⁶⁷⁰	2/10(0)	2	5357	sel 7 (2021-08-19)
64	bitsadze K.R. (furie)²⁴⁵	2/10(0)	2	6575	sel 7 (2021-09-06)
65	Dichenko M. (Dimibor)⁷⁵⁰	2/10(0)	2	10212	sel 57 (2021-11-28)
66	Savin A.Yu. (mirovingin)²⁵³	2/10(0)	2	12140	sel 7 (2021-11-03)
67	Veselov A.N. (almw)⁴³³	2/10(0)	2	14251	sel 7 (2021-08-04)
68	Antunez Garcia F. (antunez)⁶⁸²	2/10(0)	2	27946	sel 7 (2021-07-29)
69	Vestnikov D.A. (letsstudybegin)²⁷⁵	2/10(0)	2	60188	sel 7 (2021-12-02)
70	Kalyuzhnyj D.S. (mazepa)²⁷⁹	2/10(0)	2	92072	sel 57 (2021-07-18)
71	Shavkunov K.V. (Purposef)⁸⁹⁴	2/10(0)	2	163427	sel 7 (2021-11-21)
72	Ovsyankin V.S. (Kazaam)¹⁵¹	1/10(0)	1	15	sel 7 (2021-11-25)
73	Tsarapkin D.I. (Tsarapkin)²⁰⁴	1/10(0)	1	28	sel 7 (2021-11-09)
74	Pimenova M. (Self-in-use)¹⁴⁸¹	1/10(0)	1	30	sel 7 (2021-11-29)
75	Zubkov A.S. (Atrum)¹²⁰¹	1/10(0)	1	34	sel 7 (2021-10-21)
76	savchenko (dzhav)²⁷⁶⁸	1/10(0)	1	34	sel 7 (2021-10-25)
77	M (mmalikov)⁵⁰⁰³	1/10(0)	1	35	sel 7 (2021-11-10)
78	Yakushev E.A. (Ejhi)⁹⁸⁰	1/10(0)	1	40	sel 7 (2021-07-16)
79	Yatsenko A.A. (YmKa98)²⁵⁹⁶	1/10(0)	1	49	sel 7 (2021-07-21)
80	Vinogradova S.M. (Tigra1)²²²	1/10(0)	1	52	sel 7 (2021-11-15)
81	Orlova A. (alex_or)³³¹²	1/10(0)	1	55	sel 7 (2021-09-21)
82	Fyodorov D. (AstroZomb)⁴²⁵	1/10(0)	1	56	sel 7 (2021-11-12)
83	Aronov O. (aronov.oleg)¹⁴²	1/10(0)	1	67	sel 57 (2020-12-09)
84	Pusev D.V. (Pusev_Denis)¹⁷	1/10(0)	1	75	sel 112 (2020-06-06)
85	Poltorakin (poltorakin)¹³⁷⁹	1/10(0)	1	85	sel 7 (2021-10-02)
86	Kinder M.M. (Kind)³⁴³	1/10(0)	1	93	sel 7 (2021-09-10)
87	Sopulyak (takoysebeproger)²²⁶³	1/10(0)	1	112	sel 7 (2021-10-25)
88	Sergeev (post_prog)⁵³⁶	1/10(0)	1	114	sel 57 (2021-01-01)
89	Markov (yaroslavv)⁷⁶³	1/10(0)	1	116	sel 57 (2020-12-14)
90	Fimin (icprog)²⁹⁴	1/10(0)	1	119	sel 7 (2021-11-10)
91	Mikhed A.V. (am37)⁷²⁷	1/10(0)	1	126	sel 7 (2021-08-30)
92	Gajchuk A.S. (asgaychuk)³⁶⁹	1/10(0)	1	132	sel 57 (2021-05-21)
93	Zhdanov K.V. (scuder)⁴⁷⁸	1/10(0)	1	163	sel 57 (2021-04-03)
94	Boldyrev G.V. (grif85)¹²³⁹	1/10(0)	1	196	sel 7 (2021-07-23)
95	Morzhov M.S. (Galliot)¹⁹²⁵	1/10(0)	1	203	sel 7 (2021-09-03)
96	Petrov D.B. (GiBis)²⁸⁰	1/10(0)	1	237	sel 57 (2020-12-04)
97	Prokof'eva I.V. (IrinaP)⁷⁶²	1/10(0)	1	248	sel 57 (2021-01-12)
98	Isaev V.Yu. (Valer4N1)¹³⁷²	1/10(0)	1	367	sel 7 (2021-11-08)
99	ol O. (svinokiller)⁴³⁶	1/10(0)	1	396	sel 57 (2021-05-06)
100	Krasavin A.A. (alexey.krasavin)⁶⁴²	1/10(0)	1	665	sel 57 (2021-02-17)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References