SQL exercises

May 28, 15:47 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: 12536
Involved in second stage rating: 3356

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	LastSolved	LastVisit
1	Chernov D.V. (Kursist)	247	307	42	642	1326	46.720	18 Apr 2020	28 May 2020
2	Krasovskij E.A. (pegoopik)	245	307	42	638	3459	21.259	09 Dec 2019	26 May 2020
3	Kreslavskij O.M. (Arcan)	245	307	42	637	4827	36.681	18 Apr 2020	26 May 2020
4	Doschenko V.N. (mcrain)	241	307	42	624	3122	47.293	08 Apr 2020	15 Apr 2020
5	Boiko D. (Angellore)	239	307	40	620	4307	41.233	23 May 2019	02 Apr 2020
6	Kostomarov A.V. (al29)	238	307	38	619	2622	44.605	25 Jun 2019	28 May 2020
7	Dubinskij A.V. (_velial)	235	307	42	615	4227	33.348	25 Dec 2019	25 May 2020
8	Karasyova N.V. (vlksm)	238	307	42	615	5103	37.521	25 Apr 2020	26 May 2020
9	Bezhaev A.Yu. (Baser)	236	307	34	605	2924	31.847	04 May 2018	30 Mar 2020
10	Filippkin D.V. (_dimon_)	228	307	42	595	4498	28.659	18 Apr 2020	18 May 2020
11	Kurochkin P.A. (qwrqwr)	232	307	40	595	3813	32.124	19 Apr 2020	27 May 2020
12	Movlyanov A.P. (Oct)	219	305	29	554	1307	32.280	23 Jan 2017	27 Aug 2018
13	Vyazovetskov A.S. (alex_v)	218	303	23	531	4368	32.632	17 May 2018	11 Mar 2020
14	Sal'nikov S.A. ($erges)	202	303	25	515	2533	14.376	02 Feb 2015	14 May 2020
15	Kukushkin S.A. (smog)	199	305	29	490	2379	30.101	03 Oct 2017	16 Apr 2020
16	Varenikov D.M. (Dmitriy Varenikov)	189	305	42	468	5226	34.965	08 Feb 2020	23 Mar 2020
17	Timofeeva E.V. (Umrikhina)	184	304	41	464	4234	16.474	27 Nov 2019	30 Dec 2019
18	Aliev R. (y4nzi)	186	307	33	454	249	21.710	25 Jan 2018	24 Mar 2019
19	Koptel'tsev V. (selber)	176	307	42	446	2829	29.450	13 May 2020	28 May 2020
20	Grinkevich D.L. (Dmitrij Grinkevich)	181	303	27	435	2060	24.051	31 May 2017	25 Apr 2020
21	Yatsuk A.A. (Faust_zp)	167	301	24	433	1985	19.027	12 Jul 2012	15 Feb 2019
22	Sigankov V.I. (vasilyvanc)	174	307	42	431	2365	26.133	13 May 2020	28 May 2020
23	Zajtsev V.S. (Sleeping)	186	307	27	428	3617	21.641	17 Apr 2018	04 Mar 2019
24	Williams B. (BW)	177	307	41	427	4029	37.299	20 Feb 2020	21 May 2020
25	Chebykin D.N. (GriGrim)	177	307	34	426	4959	26.510	29 Dec 2019	12 Feb 2020
26	Fedevych V.I. (labuch_fedev)	174	305	40	425	2272	23.902	20 Apr 2020	20 Apr 2020
27	Petrov Y. (YuriPetrov)	174	305	40	421	3063	21.276	04 Jul 2019	15 Sep 2019
28	Fokin A. (Vizitor )	161	303	41	419	2905	12.077	17 Aug 2019	06 Sep 2019
29	Shkarednyj I.N. (Gosha)	169	305	41	419	4957	31.120	13 Aug 2019	27 May 2020
30	Pusev D.V. (Pusev_Denis)	168	254	40	418	927	23.602	23 May 2020	23 May 2020
31	Drozdkov A.N. (anddros)	168	303	24	413	2246	10.078	21 Jul 2014	29 Jan 2015
32	Latyntsev N.G. (aks_nsk)	164	307	40	407	2701	17.030	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)	157	303	39	381	2482	22.432	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)	157	305	31	377	1539	28.195	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	26 May 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)	148	303	25	357	1446	14.901	18 Jan 2015	11 Feb 2018
45	Grishunin M.F. (MikhailFG)	137	301	38	357	776	22.985	25 Jan 2019	18 Dec 2019
46	Halushka B. (halushka)	149	303	20	353	285	16.367	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)	138	303	27	334	2261	12.573	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	29 Apr 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	06 Sep 2018
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	Khromulyak O.M. (ChOleg)	126	254	25	316	2075	27.985	25 Jul 2015	30 Aug 2018
71	Zhulanov S.G. (borey.mdb)	119	125	40	315	798	14.413	20 Jul 2019	29 Jul 2019
72	Derzhal'tsev V.A. (MadVet)	122	259	22	315	2083	17.972	29 Dec 2010	14 Oct 2015
73	Zin4uk V. (Zin4uk Vadim)	126	260	24	315	1342	20.737	24 Jun 2014	02 Sep 2014
74	Panfilov A. (alexey.p4nfilov)	118	125	40	314	147	11.651	06 Jun 2019	21 Aug 2019
75	Osin V. (anyman1979)	117	125	40	313	800	6.050	03 Nov 2019	03 Nov 2019
76	Kirdan (shipwright)	118	126	38	313	1955	18.918	05 Dec 2018	05 Dec 2018
77	Kabanets E.G. (azkaban)	129	303	25	311	2234	15.224	30 Dec 2015	31 Dec 2015
78	Aronov O. (aronov.oleg)	123	136	34	309	3038	16.387	19 Dec 2019	24 Mar 2020
79	Vorob'ev E.V. (Johnnymnemonic)	127	137	25	309	3500	21.126	09 Jun 2017	22 Aug 2019
80	Vysotskij M.N. (IvanMan)	123	136	26	307	1376	15.975	12 Jan 2016	12 Jan 2016
81	Vojtov A. (Lesha.V)	117	125	35	306	708	15.089	25 Jul 2018	06 Nov 2019
82	Vas'kov E.V. (Johan)	124	260	24	304	2585	14.199	16 Aug 2013	18 Apr 2019
83	Zvon (pavel1211)	117	125	34	304	1754	15.772	06 Jul 2018	04 Nov 2019
84	Kozlov V. (SN 209)	117	125	34	304	3300	19.586	26 May 2018	30 Aug 2018
85	Kozlova M.S. (Margarita_K)	117	126	33	303	310	16.841	11 Jan 2018	05 Sep 2019
86	Shuravin E.P. (dumkan)	119	131	28	301	186	14.542	13 Apr 2016	21 Oct 2019
87	Antonovich M. (Masha279)	116	125	33	301	391	15.368	27 Dec 2017	06 Feb 2018
88	Ermolov N. (SQL_DBA)	120	133	27	301	1093	18.295	05 Jul 2016	31 Jan 2018
89	Grecha (grecha)	126	256	24	300	170	8.314	26 Feb 2014	11 Mar 2016
90	Grishin (alvigr)	125	302	24	300	1096	13.801	10 Dec 2014	19 Jan 2015
91	Katyukova I.A. (IrinkaR)	120	260	26	299	3374	10.773	15 Nov 2016	14 May 2020
92	Ovsyankin V.S. (Kazaam)	119	129	27	294	3453	10.701	07 Feb 2019	14 Feb 2019
93	Polyakov S.G. (Ivanoff Alex)	119	142	24	294	1703	20.254	29 Nov 2013	21 Nov 2019
94	Egorov Yu.A. (Yury Egorov)	124	260	23	290	1773	11.771	16 Apr 2016	16 Apr 2016
95	Agirre Kordova A.K. (Cordova)	117	125	26	288	267	9.950	04 Sep 2018	20 Sep 2018
96	Rakhmatullin R. (Ranil)	117	125	27	288	1953	19.924	07 Oct 2018	24 Feb 2020
97	Korol'kov A.A. (Brat Esteban)	117	125	26	287	3852	18.796	18 Sep 2018	21 Jan 2020
98	LisperWhisper (LisperWhisper)	116	133	24	284	2455	10.187	16 Apr 2019	16 Dec 2019
99	Bryzgunov V.A. (lorins_)	116	301	23	279	1126	13.681	23 Oct 2013	10 Nov 2017
100	Tarshin S.N. (tsn)	116	122	26	278	2881	11.316	16 Jul 2019	03 Feb 2020

Home
Week news