SQL exercises

July 05, 07:37 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

"Liberal" rating

Exercise solution time exceeding 6 hours is replaced by 6 hours.
Only 2nd and 3rd stage exercises are considered in solution time (Days_2).
Scores - sum of points on 2nd & 3rd stage exercises and DML exercises solved.

Involved in rating: 12594
Involved in second stage rating: 3387

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	LastSolved	LastVisit
1	Chernov D.V. (Kursist)	248	307	43	646	1400	46.793	01 Jul 2020	04 Jul 2020
2	Krasovskij E.A. (pegoopik)	244	307	42	638	3459	21.256	09 Dec 2019	26 Jun 2020
3	Kreslavskij O.M. (Arcan)	244	307	43	638	4899	36.671	29 Jun 2020	04 Jul 2020
4	Doschenko V.N. (mcrain)	240	307	43	625	3199	47.276	24 Jun 2020	25 Jun 2020
5	Boiko D. (Angellore)	238	307	40	620	4307	41.230	23 May 2019	02 Apr 2020
6	Kostomarov A.V. (al29)	238	307	38	619	2622	44.605	25 Jun 2019	02 Jul 2020
7	Dubinskij A.V. (_velial)	234	307	43	616	4396	33.345	11 Jun 2020	25 Jun 2020
8	Karasyova N.V. (vlksm)	237	307	42	615	5103	37.514	25 Apr 2020	02 Jul 2020
9	Bezhaev A.Yu. (Baser)	235	307	34	605	2924	31.836	04 May 2018	30 Mar 2020
10	Kurochkin P.A. (qwrqwr)	233	307	40	598	3888	32.170	03 Jul 2020	04 Jul 2020
11	Filippkin D.V. (_dimon_)	227	307	43	596	4549	28.654	08 Jun 2020	02 Jul 2020
12	Movlyanov A.P. (Oct)	218	305	29	554	1307	32.274	23 Jan 2017	27 Aug 2018
13	Vyazovetskov A.S. (alex_v)	217	301	23	531	4368	32.628	17 May 2018	11 Mar 2020
14	Sal'nikov S.A. ($erges)	201	302	25	515	2533	14.372	02 Feb 2015	02 Jul 2020
15	Kukushkin S.A. (smog)	198	305	29	490	2379	30.096	03 Oct 2017	04 Jun 2020
16	Varenikov D.M. (Dmitriy Varenikov)	189	305	43	471	5372	35.206	03 Jul 2020	04 Jul 2020
17	Timofeeva E.V. (Umrikhina)	183	304	41	464	4234	16.466	27 Nov 2019	30 Dec 2019
18	Koptel'tsev V. (selber)	179	307	43	457	2870	30.011	23 Jun 2020	04 Jul 2020
19	Aliev R. (y4nzi)	185	307	33	454	249	21.707	25 Jan 2018	24 Mar 2019
20	Pusev D.V. (Pusev_Denis)	175	254	40	436	969	25.153	04 Jul 2020	05 Jul 2020
21	Grinkevich D.L. (Dmitrij Grinkevich)	180	302	27	435	2060	24.044	31 May 2017	25 Apr 2020
22	Sigankov V.I. (vasilyvanc)	174	307	43	434	2414	26.360	01 Jul 2020	05 Jul 2020
23	Yatsuk A.A. (Faust_zp)	167	301	24	433	1985	19.027	12 Jul 2012	15 Feb 2019
24	Zajtsev V.S. (Sleeping)	185	307	27	428	3617	21.637	17 Apr 2018	04 Mar 2019
25	Williams B. (BW)	176	307	41	427	4029	37.258	20 Feb 2020	15 Jun 2020
26	Chebykin D.N. (GriGrim)	176	307	34	426	4959	26.505	29 Dec 2019	12 Feb 2020
27	Fedevych V.I. (labuch_fedev)	174	305	40	425	2272	23.902	20 Apr 2020	20 Apr 2020
28	Petrov Y. (YuriPetrov)	173	305	40	421	3063	21.267	04 Jul 2019	15 Sep 2019
29	Shkarednyj I.N. (Gosha)	170	305	41	420	5252	31.120	03 Jun 2020	03 Jul 2020
30	Fokin A. (Vizitor )	160	302	41	419	2905	12.074	17 Aug 2019	06 Sep 2019
31	Drozdkov A.N. (anddros)	167	302	24	413	2246	10.076	21 Jul 2014	05 Jun 2020
32	Latyntsev N.G. (aks_nsk)	163	307	40	407	2701	17.015	21 May 2019	24 Nov 2019
33	Shaymardanov M.M. (xLiSPirit)	160	301	34	401	2794	19.658	18 May 2018	20 Dec 2018
34	Kuznetsov V.S. (herrRo)	153	260	23	392	1171	19.267	08 Feb 2012	18 Jun 2013
35	Pyatiletov A. (MontaG)	156	302	39	381	2482	22.426	30 Jun 2019	30 Jun 2019
36	Pavlov A.V. (Anton)	154	261	40	380	5051	22.791	11 Jun 2019	18 Aug 2019
37	F (uff)	156	305	31	377	1539	28.186	22 Jan 2018	20 Aug 2018
38	Titovskij P.S. (kli3ma)	148	260	28	371	1906	14.305	15 Jun 2016	15 Jun 2016
39	Tarasov D.B. (Gavrila)	145	301	23	367	2432	20.319	23 Apr 2012	08 Jan 2018
40	Milenkov (wqer)	136	148	42	363	1344	19.287	13 Jan 2020	29 Jun 2020
41	Shindin A.V. (AlShin)	141	259	23	362	3622	20.347	18 Sep 2018	06 Oct 2018
42	Agapov V. (KERBEROS)	142	302	24	360	2414	16.012	02 Apr 2013	24 Sep 2016
43	Utyonkov M.N. (=Maxim=)	152	302	24	358	4541	15.063	08 Oct 2018	11 Dec 2018
44	Vakhrameev A. (WY)	147	302	25	357	1446	14.889	18 Jan 2015	28 Jun 2020
45	Grishunin M.F. (MikhailFG)	137	301	38	357	776	22.985	25 Jan 2019	18 Dec 2019
46	Halushka B. (halushka)	148	302	20	353	285	16.362	19 Oct 2015	22 Jan 2016
47	Samarin A. (not.yet.sql.master)	131	137	42	351	262	5.110	09 May 2020	17 May 2020
48	Familiya (WereWolf777)	131	170	38	345	3576	14.272	07 Jan 2019	07 Jan 2019
49	Orlov M.V. (Eagleoff)	133	259	23	344	1299	18.403	07 Nov 2011	05 Dec 2019
50	Suprun D. (TimonSP)	132	143	29	343	3033	8.096	09 Jan 2017	26 Feb 2019
51	Proskurin Yu.N. (Xonner)	139	301	29	342	2647	15.922	23 Jun 2018	04 Jan 2020
52	Ilyasov V. (VadimI)	135	260	29	341	1109	11.206	13 Mar 2017	03 Apr 2017
53	Zotov P.G. (Ozzy)	131	259	23	340	1391	19.032	31 Dec 2011	18 Aug 2016
54	Frolov (dr.shtopor)	131	148	28	336	865	22.040	05 Apr 2016	31 Dec 2019
55	Kalinin K.A. (kalinin_k)	136	301	23	335	399	11.768	30 Jun 2012	19 Nov 2014
56	Maslyaev V.S. (Velmont)	137	302	27	334	2261	12.570	02 Feb 2018	02 Jul 2019
57	Sivoglazov M.A. (Gaizenberg)	140	301	24	334	842	16.588	10 Nov 2015	05 Mar 2020
58	Demin D. (demind74)	126	133	40	330	301	9.227	01 Jul 2019	20 Aug 2019
59	Skorohod I. (Dracul4ik)	131	254	25	328	2300	23.592	12 Sep 2017	10 Sep 2019
60	Ivanova O.A. (_Olga24)	126	138	29	326	803	14.472	14 Aug 2016	14 Aug 2016
61	Vasilevskaya E.A. (kattiks)	124	130	41	326	907	21.906	30 Aug 2019	10 Jun 2020
62	Dvoryaninov V. (Valdaj)	134	301	23	325	1291	18.081	28 Dec 2012	28 Apr 2020
63	Azbel' E.G. (enull)	128	143	25	325	3441	21.408	21 Feb 2018	05 May 2020
64	Menshov S. (SergM)	130	260	26	323	3733	13.504	02 Jun 2017	16 Jun 2020
65	X D. (railgun3r)	129	302	24	322	1378	22.579	16 Aug 2014	03 Nov 2015
66	Martynyuk (Wiedzmen)	134	251	23	321	2190	15.083	10 Mar 2015	08 Feb 2016
67	Kolesnikov (hard)	125	133	34	320	1583	19.579	24 Nov 2018	27 Jan 2019
68	Buldenkov D.A. (eXeQuThor)	119	125	41	317	4456	11.810	28 Oct 2019	02 Dec 2019
69	Dmitriev A. (Havr)	119	125	41	317	334	12.756	30 Jul 2019	12 Sep 2019
70	Komarov A.N. (Shveda Saulya)	120	126	40	317	258	13.945	04 Jul 2020	04 Jul 2020
71	Khromulyak O.M. (ChOleg)	126	254	25	316	2075	27.985	25 Jul 2015	30 Aug 2018
72	Zhulanov S.G. (borey.mdb)	119	125	40	315	798	14.413	20 Jul 2019	29 Jul 2019
73	Derzhal'tsev V.A. (MadVet)	122	259	22	315	2083	17.972	29 Dec 2010	14 Oct 2015
74	Zin4uk V. (Zin4uk Vadim)	126	260	24	315	1342	20.737	24 Jun 2014	02 Sep 2014
75	Panfilov A. (alexey.p4nfilov)	118	125	40	314	147	11.651	06 Jun 2019	21 Aug 2019
76	Osin V. (anyman1979)	117	125	40	313	800	6.050	03 Nov 2019	03 Nov 2019
77	Kirdan (shipwright)	118	126	38	313	1955	18.918	05 Dec 2018	05 Dec 2018
78	Yakovlev M.V. (MikhailYakovlev535)	117	303	41	312	1838	13.906	04 Jul 2020	04 Jul 2020
79	Kabanets E.G. (azkaban)	128	302	25	311	2234	15.222	30 Dec 2015	31 Dec 2015
80	Aronov O. (aronov.oleg)	123	136	34	309	3038	16.387	19 Dec 2019	24 Mar 2020
81	Vorob'ev E.V. (Johnnymnemonic)	127	137	25	309	3500	21.126	09 Jun 2017	22 Aug 2019
82	Vysotskij M.N. (IvanMan)	123	136	26	307	1376	15.975	12 Jan 2016	12 Jan 2016
83	Vojtov A. (Lesha.V)	117	125	35	306	708	15.089	25 Jul 2018	06 Nov 2019
84	Vas'kov E.V. (Johan)	124	260	24	304	2585	14.199	16 Aug 2013	11 Jun 2020
85	Zvon (pavel1211)	117	125	34	304	1754	15.772	06 Jul 2018	04 Nov 2019
86	Kozlov V. (SN 209)	117	125	34	304	3300	19.586	26 May 2018	03 Jun 2020
87	Kozlova M.S. (Margarita_K)	117	126	33	303	310	16.841	11 Jan 2018	05 Sep 2019
88	Shuravin E.P. (dumkan)	119	131	28	301	186	14.542	13 Apr 2016	21 Oct 2019
89	Ermolov N. (SQL_DBA)	120	133	27	301	1093	18.295	05 Jul 2016	31 Jan 2018
90	Grecha (grecha)	126	256	24	300	170	8.314	26 Feb 2014	11 Mar 2016
91	Grishin (alvigr)	125	302	24	300	1096	13.801	10 Dec 2014	19 Jan 2015
92	Katyukova I.A. (IrinkaR)	120	260	26	299	3374	10.773	15 Nov 2016	14 May 2020
93	Ovsyankin V.S. (Kazaam)	119	129	27	294	3453	10.701	07 Feb 2019	14 Feb 2019
94	Polyakov S.G. (Ivanoff Alex)	119	142	24	294	1703	20.254	29 Nov 2013	03 Jul 2020
95	Egorov Yu.A. (Yury Egorov)	124	260	23	290	1773	11.771	16 Apr 2016	16 Apr 2016
96	Rakhmatullin R. (Ranil)	118	125	27	289	2579	20.174	24 Jun 2020	25 Jun 2020
97	Agirre Kordova A.K. (Cordova)	117	125	26	288	267	9.950	04 Sep 2018	23 Jun 2020
98	Korol'kov A.A. (Brat Esteban)	117	125	26	287	3852	18.796	18 Sep 2018	21 Jan 2020
99	LisperWhisper (LisperWhisper)	116	133	24	284	2455	10.187	16 Apr 2019	16 Dec 2019
100	Tarshin S.N. (tsn)	116	122	26	278	2881	11.316	16 Jul 2019	03 Feb 2020

Home
Week news