SQL exercises

Language

February 05, 20:28 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.

Login: Password:
	forgot password? Registration

Ratings

  • Top 100
  • "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

  • SELECT (learning stage)
  • SELECT (learning stage,
      choosing DBMS)
  • SELECT (rating stages)
  • DML

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search

Certification

  • About certification
  • The first certificate in SQL
  • Certified professionals
  • Statistics
  • Confirm certificate

HELP

Query optimization

Transact-SQL tests

Modelling of data

Exercises voting

For employers

Support SQL-EX.RU

Poll

Would you get the following certificate?

"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: 7005
Involved in second stage rating: 2339

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	LastSolved	LastVisit
1	>Bezhaev A.Yu. (Baser)	168	254	23	416	644	23.437	05 Feb 2012	05 Feb 2012
2	Kurochkin P.A. (qwrqwr)	170	254	23	416	816	24.214	04 Feb 2012	05 Feb 2012
3	Kreslavskij O.M. (Arcan)	169	254	23	413	1831	23.325	04 Feb 2012	05 Feb 2012
4	Karasyova N.V. (vlksm)	169	254	23	413	2100	26.222	04 Feb 2012	05 Feb 2012
5	Yatsuk A.A. (Faust_zp)	168	254	23	412	1811	18.260	20 Jan 2012	05 Feb 2012
6	Kuznetsov V.S. (herrRo)	166	254	23	408	1159	20.182	27 Jan 2012	04 Feb 2012
7	Sal'nikov S.A. ($erges)	162	254	23	399	1431	10.000	27 Jan 2012	05 Feb 2012
8	Boiko D. (Angellore)	162	254	23	395	1642	27.064	04 Feb 2012	05 Feb 2012
9	Dubinskij A.V. (_yizraor)	154	254	23	381	1316	20.073	05 Jan 2012	30 Jan 2012
10	Tarasov D.B. (Gavrila)	152	254	23	374	2299	20.417	12 Dec 2011	30 Jan 2012
11	Shindin A.V. (AlShin)	145	252	23	368	929	20.611	05 May 2011	21 May 2011
12	Drozdkov A.N. (anddros)	147	253	23	364	1280	8.896	28 Nov 2011	30 Dec 2011
13	Orlov M.V. (Eagleoff)	146	254	23	362	1299	18.688	07 Nov 2011	05 Feb 2012
14	Zotov P.G. (Ozzy)	144	253	23	358	1391	20.108	31 Dec 2011	05 Feb 2012
15	Derzhal'tsev V.A. (MadVet)	135	253	22	340	2083	18.569	29 Dec 2010	26 Sep 2011
16	Dvoryaninov V. (Valdaj)	136	252	23	330	919	16.858	22 Dec 2011	01 Feb 2012
17	Krasovskij E.A. (Pegoopik)	136	254	23	322	592	14.091	02 Feb 2012	03 Feb 2012
18	Filippkin D.V. (_dimon_)	135	254	23	319	1488	12.367	21 Jan 2012	04 Feb 2012
19	Kalinin K.A. (kalinin_k)	131	254	23	313	246	10.036	29 Jan 2012	05 Feb 2012
20	Utyonkov M.N. (=Maxim=)	131	254	23	306	2090	12.905	22 Jan 2012	04 Feb 2012
21	Sviridov K.Yu. (orange)	121	162	23	302	1305	11.937	15 Jun 2011	03 Feb 2012
22	Sukhnev D.A. (mz)	123	251	23	297	1862	14.812	15 Aug 2011	03 Dec 2011
23	Martynyuk (Wiedzmen)	123	251	23	295	1038	12.497	13 Jan 2012	13 Jan 2012
24	Sabitov D. (railgun3r)	123	254	23	294	347	21.365	20 Oct 2011	21 Jan 2012
25	Vas'kov E.V. (Johan)	122	252	23	293	1974	12.977	14 Dec 2011	23 Dec 2011
26	Shaymardanov M.M. (xLiSPirit)	127	254	23	292	498	12.350	03 Feb 2012	05 Feb 2012
27	Umrikhina E.V. (Umrikhina)	112	253	23	291	949	9.675	29 Nov 2010	29 Sep 2011
28	Zin4uk V. (Zin4uk Vadim)	121	254	23	290	444	18.505	08 Jan 2012	08 Jan 2012
29	Nashyn E. (O.o)	120	174	23	287	265	17.749	31 Mar 2011	03 Feb 2012
30	Pechatnov V.V. (pvv)	114	253	21	280	1085	11.288	08 Oct 2010	02 Feb 2012
31	Familiya (WereWolf777)	116	170	23	278	1033	11.590	21 Jan 2012	03 Feb 2012
32	Chebykin D.N. (GriGrim)	118	183	23	278	2071	16.659	01 Feb 2012	05 Feb 2012
33	Polyakov S.G. (Ivanoff Alex)	112	142	23	271	979	17.159	06 Dec 2011	03 Feb 2012
34	Bazavluk M. (DoNotLook)	111	173	23	269	184	18.116	10 Jun 2011	18 Jun 2011
35	Sribnyak A. (silver)	112	137	23	269	1367	18.332	12 Nov 2011	08 Jan 2012
36	Kozharinov A. (bubala)	110	137	23	266	310	10.270	25 Aug 2011	05 Dec 2011
37	Usik V.N. (Vladius)	110	140	22	265	848	13.633	14 Jul 2011	14 Jul 2011
38	Sadovnikov A.N. (raul)	108	166	23	263	2178	10.180	26 May 2011	30 Jun 2011
39	Fajnberg M.L. (burnall)	109	251	23	263	954	11.623	25 Jan 2012	04 Feb 2012
40	Sidorov A.V. (OPM)	108	137	23	262	607	10.962	16 Jul 2011	24 Jan 2012
41	Suprun D. (TimonSP)	109	142	23	260	1133	5.510	28 Oct 2011	12 Dec 2011
42	Bryzgunov V.A. (lorins_)	108	133	23	258	460	10.982	27 Dec 2011	28 Dec 2011
43	Malyshok A.A. (Magnetic)	106	137	23	258	1246	17.013	27 Jun 2011	03 Feb 2012
44	Timchenko S. (timka__s)	108	132	23	257	88	4.764	28 Jan 2012	01 Feb 2012
45	Efimova O.Yu. (El'ga)	108	132	23	257	1221	19.882	13 Jan 2012	30 Jan 2012
46	Williams (BW)	108	137	23	257	1029	20.072	04 Dec 2011	03 Feb 2012
47	Gorbunov A.V. (risp)	107	136	23	253	1135	7.456	18 Jan 2012	03 Feb 2012
48	Valuev D.I. (Fiolent)	102	251	23	252	2715	13.435	09 Feb 2011	04 Feb 2012
49	Rybkina T.V. (Rybka)	104	145	22	252	156	13.879	30 Aug 2010	31 Mar 2011
50	Titovskij P.S. (kli3ma)	105	129	23	251	290	6.571	12 Jan 2012	03 Feb 2012
51	Zhukov S.M. (__Sai)	104	131	23	250	586	17.348	13 Sep 2011	09 Nov 2011
52	Katyukova I.A. (IrinkaR)	102	137	23	247	1189	8.665	22 Nov 2010	14 Feb 2011
53	Semaka A.A. (tolikas)	103	131	23	246	907	11.154	18 Jan 2012	18 Jan 2012
54	Kashkarov D.S. (frosten)	102	127	23	245	331	12.077	18 Dec 2011	04 Feb 2012
55	Skuz D.V. (Dima_SV)	102	136	23	244	411	10.446	16 Oct 2011	16 Oct 2011
56	Lyubchenko V.A. (IAS56)	98	251	22	244	1471	19.276	14 Sep 2010	28 Jan 2012
57	Senkevich S.V. (GreyC)	90	253	21	242	358	11.924	26 Jan 2009	01 Jan 2010
58	Tverdokhleb O.V. (Tverdokhlib)	99	129	23	242	238	13.457	02 Jul 2011	09 Jan 2012
59	Egorov Yu.A. (Yury Egorov)	101	125	23	241	222	6.367	17 Jan 2012	05 Feb 2012
60	Egorov A.B. (ABEgorov)	95	251	22	241	752	8.495	26 Feb 2010	17 May 2011
61	Menshov S. (SergM)	101	125	23	241	1766	8.878	13 Jan 2012	05 Feb 2012
62	Tselischev M.A. (m.a)	101	125	23	241	468	9.751	02 Jan 2012	26 Jan 2012
63	Kholtygin S.A. (vavilen)	101	125	23	241	283	9.797	03 Feb 2012	03 Feb 2012
64	Kudryakov A.I. (AKudrakov)	95	152	22	238	757	12.654	05 Feb 2010	05 May 2010
65	San'ko A.V. (count)	97	130	23	237	427	6.011	02 Jun 2011	27 Sep 2011
66	Bychkovskij G.A. (GeBy)	99	128	23	237	655	9.364	14 Jan 2012	05 Feb 2012
67	Osadchij V.V. (Mathematician)	97	131	23	236	878	4.623	14 Feb 2011	18 Aug 2011
68	Nikotin V.M. (@Nikotin)	88	253	21	236	108	6.634	13 Dec 2008	04 Dec 2011
69	Donskikh A.V. (Ridan)	97	252	22	236	874	13.501	28 Jul 2010	05 Sep 2011
70	Gromov A.P. (grap)	96	129	23	235	572	4.496	20 Aug 2011	21 Nov 2011
71	Vil'danov M. (mar_vi)	96	251	21	235	1160	6.173	23 Aug 2011	23 Aug 2011
72	Batyrshin R.N. (Ramses)	98	136	22	235	174	9.207	17 Aug 2010	19 Aug 2011
73	Makarov I.A. (_Bkmz_)	94	251	22	234	742	6.485	23 Mar 2010	04 Feb 2012
74	Puzen'kin A.I. (Fencer)	98	137	23	234	2059	14.551	13 Oct 2011	07 Nov 2011
75	Mullakhanov R.Kh. (rem)	89	253	22	233	649	3.310	20 Jun 2009	02 Feb 2010
76	Glazyrin D.S. (glassman)	92	252	22	232	1073	8.420	18 May 2011	01 Aug 2011
77	Savchenko A. (Yasha123)	95	125	23	232	153	10.623	22 Jun 2011	03 Nov 2011
78	Poltavets L.S. (lilyok)	95	142	22	232	663	11.566	21 Jun 2010	27 Aug 2011
79	Kotov A. (Ckpa6)	94	142	22	231	141	7.797	27 Apr 2010	27 Apr 2010
80	Vojnov P.E. (paparome)	95	252	23	230	1925	2.818	01 Dec 2010	21 Apr 2011
81	Anisimov D. (danilko)	91	253	22	230	32	5.687	12 Aug 2009	17 Aug 2009
82	Zaikin A.S. (Allex)	92	145	22	230	685	11.772	22 Mar 2010	11 Sep 2011
83	Martynenko V.Yu. (Fuddy-Duddy)	96	125	23	229	1030	18.483	02 Feb 2012	02 Feb 2012
84	Borisenkov D.V. (xuser)	94	251	23	227	1052	4.204	18 Dec 2010	01 Jan 2012
85	Kornienko D.N. (kDnZP)	96	120	23	226	287	10.255	12 Jan 2012	05 Feb 2012
86	Voevutskij S.A. (SergLK)	92	137	23	225	782	9.446	08 Oct 2011	19 Dec 2011
87	Romanov K.Yu. (kostik)	93	137	22	225	624	12.518	24 Nov 2010	16 Jan 2012
88	Sheringa A.A. (degluker)	91	125	23	223	143	8.747	29 Nov 2010	01 Dec 2010
89	Ismailov A.R. (aklerk)	91	125	23	223	241	13.853	16 Dec 2010	19 Oct 2011
90	Vorob'ev E.V. (Johnnymnemonic)	93	131	22	223	1020	14.261	25 Aug 2010	09 Mar 2011
91	Ostapchuk A.B. (_ORA_)	93	125	23	223	1286	14.624	15 Nov 2011	16 Jan 2012
92	Mats V.V. (Easy-Human)	91	127	23	222	124	6.917	05 Nov 2010	18 Jan 2012
93	Ivakhnenko A. (alex.i)	91	136	22	220	338	10.020	15 Jul 2010	18 Jan 2012
94	Kurbanoff N.I. (Nariman Kurbanoff)	89	145	22	218	809	15.517	19 Jul 2010	20 Jan 2012
95	Krylov S.A. (Serg71)	89	127	22	216	553	21.440	10 Jun 2010	18 Jun 2010
96	Smirnov V. (VSmirnov)	91	115	23	214	205	15.250	03 Feb 2012	04 Feb 2012
97	Yusufov A.F. (AlexFJ)	90	137	23	214	1582	16.721	01 Aug 2011	11 Jan 2012
98	Iljy (iljy)	88	123	23	213	699	2.904	08 May 2011	31 Oct 2011
99	Morozov S. (Sergey79)	89	123	21	213	1541	20.952	31 Jan 2011	09 Feb 2011
100	Kushnerik V.A. (ValentinOS)	89	115	23	211	1757	16.321	14 Oct 2011	03 Feb 2012

| Курсы по AutoCAD 2010 в Москве. Курсы обучения autocad в москве. | Продажа квартир, объявления: двухъярусная кровать с диваном. Детская мебель от 30 фабрик. |

Home
Week news