SQL exercises

April 15, 10:07 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

Wilo цена
Насосное оборудование Wilo. Доступная цена. Гарантия качества
wl-russia.ru
Производство пептидов россия
Производство измерительных приборов. Производство персональных компьютеров
russianpeptide.com

Results of exercises voting

In this Section you can see the results of voting for the tasks of the second and the third stages (SELECT exercises) on 10-score scale.
In order to estimate the tasks (if you have solved these yet), click here.

No	Exercise #	Rank	Number of votes
1	210	10.0	11
2	194	10.0	11
3	228	10.0	10
4	207	10.0	8
5	233	10.0	7
6	214	10.0	7
7	232	10.0	4
8	220	10.0	3
9	231	10.0	3
10	155	9.9	18
11	165	9.9	18
12	154	9.9	17
13	167	9.9	15
14	219	9.9	8
15	216	9.9	8
16	223	9.9	7
17	172	9.8	16
18	188	9.8	12
19	211	9.8	9
20	255	9.8	9
21	222	9.8	8
22	225	9.8	6
23	230	9.8	4
24	146	9.7	33
25	152	9.7	27
26	164	9.7	22
27	147	9.7	19
28	181	9.7	10
29	119	9.6	53
30	166	9.6	30
31	180	9.6	24
32	160	9.6	17
33	157	9.6	15
34	213	9.6	15
35	163	9.6	14
36	218	9.6	7
37	229	9.6	5
38	168	9.5	24
39	176	9.5	21
40	153	9.5	20
41	259	9.5	13
42	191	9.5	11
43	234	9.5	2
44	100	9.4	119
45	101	9.4	110
46	102	9.4	81
47	203	9.4	23
48	198	9.4	16
49	196	9.4	15
50	257	9.4	13
51	224	9.4	7
52	87	9.3	171
53	116	9.3	111
54	93	9.3	65
55	95	9.3	36
56	148	9.3	35
57	162	9.3	34
58	174	9.3	32
59	173	9.3	28
60	57	9.3	26
61	171	9.3	15
62	304	9.3	15
63	215	9.3	13
64	200	9.3	12
65	306	9.3	4
66	72	9.2	266
67	137	9.2	67
68	192	9.2	25
69	186	9.2	24
70	149	9.2	21
71	161	9.2	17
72	179	9.2	12
73	226	9.2	5
74	217	9.2	5
75	235	9.2	5
76	91	9.1	86
77	138	9.1	65
78	115	9.1	31
79	156	9.1	29
80	202	9.1	16
81	183	9.1	15
82	195	9.1	15
83	178	9.1	15
84	206	9.1	12
85	123	9.0	110
86	69	9.0	51
87	142	9.0	48
88	141	9.0	36
89	170	9.0	27
90	112	9.0	16
91	305	9.0	14
92	80	8.9	130
93	88	8.9	107
94	120	8.9	48
95	140	8.9	41
96	135	8.9	33
97	158	8.9	23
98	301	8.9	20
99	253	8.9	20
100	256	8.9	20
101	151	8.9	19
102	205	8.9	10
103	221	8.9	10
104	212	8.9	10
105	76	8.8	172
106	96	8.8	158
107	35	8.8	156
108	106	8.8	118
109	110	8.8	111
110	130	8.8	57
111	143	8.8	29
112	254	8.8	27
113	187	8.8	20
114	184	8.8	19
115	197	8.8	19
116	190	8.8	13
117	208	8.8	12
118	77	8.7	121
119	125	8.7	86
120	201	8.7	23
121	204	8.7	17
122	52	8.6	133
123	86	8.6	110
124	126	8.6	87
125	134	8.6	68
126	145	8.6	33
127	189	8.6	12
128	61	8.5	308
129	43	8.5	152
130	83	8.5	142
131	85	8.5	134
132	92	8.5	118
133	113	8.5	54
134	105	8.5	51
135	131	8.5	41
136	177	8.5	26
137	175	8.5	22
138	150	8.5	21
139	307	8.5	11
140	23	8.4	360
141	66	8.4	245
142	71	8.4	183
143	84	8.4	145
144	114	8.4	91
145	104	8.4	57
146	169	8.4	21
147	199	8.4	14
148	74	8.3	197
149	67	8.3	195
150	59	8.3	192
151	50	8.3	173
152	111	8.3	96
153	124	8.3	83
154	128	8.3	71
155	139	8.3	44
156	252	8.3	23
157	193	8.3	15
158	54	8.2	450
159	58	8.2	206
160	81	8.2	162
161	82	8.2	136
162	98	8.2	127
163	107	8.2	97
164	94	8.2	89
165	118	8.2	85
166	99	8.2	75
167	133	8.2	46
168	159	8.2	14
169	41	8.1	343
170	17	8.1	306
171	47	8.1	275
172	51	8.1	134
173	68	8.1	105
174	182	8.1	17
175	7	8.0	463
176	20	8.0	327
177	36	8.0	299
178	21	8.0	263
179	37	8.0	246
180	62	8.0	214
181	10	8.0	187
182	64	8.0	179
183	45	8.0	109
184	109	8.0	94
185	251	8.0	29
186	209	8.0	15
187	9	7.9	390
188	30	7.9	375
189	49	7.9	356
190	34	7.9	342
191	6	7.9	311
192	56	7.9	265
193	44	7.9	218
194	70	7.9	214
195	185	7.9	25
196	60	7.8	322
197	31	7.8	242
198	89	7.8	148
199	121	7.8	94
200	90	7.8	79
201	26	7.7	346
202	65	7.7	244
203	79	7.7	149
204	97	7.7	77
205	260	7.7	35
206	127	7.7	24
207	53	7.6	367
208	8	7.6	352
209	18	7.6	344
210	33	7.6	334
211	42	7.6	303
212	63	7.6	233
213	28	7.6	220
214	38	7.6	194
215	55	7.6	96
216	117	7.6	81
217	132	7.6	54
218	302	7.6	11
219	258	7.6	10
220	11	7.5	418
221	14	7.5	414
222	19	7.5	396
223	13	7.5	388
224	29	7.5	327
225	15	7.5	309
226	32	7.5	301
227	39	7.5	267
228	75	7.5	138
229	129	7.5	57
230	48	7.4	294
231	16	7.4	240
232	73	7.4	145
233	78	7.4	123
234	103	7.4	53
235	136	7.4	48
236	22	7.3	359
237	27	7.3	282
238	108	7.3	91
239	144	7.3	27
240	12	7.2	80
241	25	7.0	310
242	40	7.0	70
243	261	7.0	19
244	227	7.0	5
245	24	6.9	442
246	46	6.7	308
247	262	6.5	6
248	303	6.3	7
249	122	5.9	51

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References