SQL exercises

January 17, 18:04 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
Потолок армстронг
Продажа отделочных материалов Перечень объектов
ekb-ccp.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	188	9.8	12
18	211	9.8	9
19	255	9.8	9
20	222	9.8	8
21	225	9.8	6
22	230	9.8	4
23	146	9.7	33
24	152	9.7	27
25	164	9.7	22
26	147	9.7	19
27	57	9.7	18
28	172	9.7	15
29	181	9.7	10
30	119	9.6	50
31	166	9.6	30
32	180	9.6	24
33	160	9.6	17
34	157	9.6	15
35	213	9.6	15
36	163	9.6	14
37	218	9.6	7
38	229	9.6	5
39	102	9.5	80
40	168	9.5	24
41	176	9.5	21
42	153	9.5	20
43	259	9.5	13
44	191	9.5	11
45	234	9.5	2
46	100	9.4	118
47	101	9.4	109
48	203	9.4	23
49	198	9.4	16
50	196	9.4	15
51	257	9.4	13
52	224	9.4	7
53	87	9.3	171
54	116	9.3	109
55	93	9.3	64
56	95	9.3	35
57	148	9.3	35
58	162	9.3	34
59	174	9.3	32
60	173	9.3	28
61	171	9.3	15
62	304	9.3	15
63	215	9.3	13
64	200	9.3	12
65	72	9.2	264
66	137	9.2	67
67	192	9.2	25
68	186	9.2	24
69	149	9.2	21
70	161	9.2	17
71	179	9.2	12
72	217	9.2	5
73	226	9.2	5
74	91	9.1	85
75	138	9.1	65
76	115	9.1	29
77	156	9.1	29
78	202	9.1	16
79	183	9.1	15
80	195	9.1	15
81	178	9.1	15
82	206	9.1	12
83	123	9.0	107
84	142	9.0	47
85	141	9.0	35
86	170	9.0	27
87	305	9.0	14
88	112	9.0	14
89	80	8.9	130
90	88	8.9	107
91	69	8.9	49
92	120	8.9	44
93	140	8.9	40
94	135	8.9	33
95	158	8.9	23
96	301	8.9	20
97	253	8.9	20
98	256	8.9	20
99	151	8.9	19
100	205	8.9	10
101	212	8.9	10
102	76	8.8	170
103	96	8.8	157
104	35	8.8	156
105	106	8.8	116
106	110	8.8	109
107	130	8.8	57
108	143	8.8	29
109	254	8.8	27
110	187	8.8	20
111	184	8.8	19
112	197	8.8	19
113	190	8.8	13
114	208	8.8	12
115	221	8.8	9
116	77	8.7	120
117	125	8.7	84
118	201	8.7	23
119	204	8.7	17
120	52	8.6	129
121	86	8.6	110
122	126	8.6	87
123	134	8.6	68
124	145	8.6	33
125	189	8.6	12
126	61	8.5	305
127	43	8.5	149
128	83	8.5	142
129	85	8.5	134
130	92	8.5	117
131	105	8.5	50
132	131	8.5	41
133	177	8.5	26
134	175	8.5	22
135	150	8.5	21
136	307	8.5	11
137	23	8.4	359
138	66	8.4	241
139	71	8.4	181
140	84	8.4	145
141	114	8.4	90
142	104	8.4	56
143	113	8.4	52
144	169	8.4	21
145	199	8.4	14
146	74	8.3	195
147	67	8.3	193
148	59	8.3	189
149	50	8.3	169
150	111	8.3	94
151	124	8.3	80
152	128	8.3	71
153	139	8.3	44
154	252	8.3	23
155	193	8.3	15
156	54	8.2	446
157	81	8.2	162
158	82	8.2	136
159	98	8.2	126
160	94	8.2	88
161	118	8.2	82
162	133	8.2	46
163	159	8.2	14
164	41	8.1	340
165	17	8.1	305
166	47	8.1	273
167	58	8.1	201
168	51	8.1	131
169	107	8.1	95
170	99	8.1	74
171	182	8.1	17
172	7	8.0	460
173	20	8.0	325
174	36	8.0	297
175	21	8.0	262
176	37	8.0	243
177	62	8.0	211
178	10	8.0	185
179	45	8.0	106
180	68	8.0	104
181	251	8.0	29
182	209	8.0	15
183	9	7.9	387
184	30	7.9	374
185	49	7.9	352
186	34	7.9	341
187	6	7.9	304
188	56	7.9	262
189	31	7.9	241
190	44	7.9	216
191	64	7.9	177
192	109	7.9	92
193	185	7.9	25
194	60	7.8	320
195	70	7.8	212
196	89	7.8	148
197	121	7.8	91
198	90	7.8	78
199	26	7.7	345
200	65	7.7	241
201	79	7.7	149
202	55	7.7	92
203	97	7.7	77
204	260	7.7	35
205	127	7.7	24
206	53	7.6	363
207	8	7.6	351
208	18	7.6	343
209	33	7.6	333
210	42	7.6	300
211	63	7.6	229
212	28	7.6	220
213	38	7.6	191
214	117	7.6	78
215	132	7.6	54
216	302	7.6	11
217	258	7.6	10
218	11	7.5	415
219	14	7.5	414
220	19	7.5	395
221	13	7.5	387
222	29	7.5	326
223	15	7.5	308
224	32	7.5	300
225	39	7.5	265
226	129	7.5	57
227	48	7.4	291
228	16	7.4	237
229	73	7.4	143
230	75	7.4	136
231	78	7.4	123
232	136	7.4	48
233	22	7.3	358
234	27	7.3	281
235	108	7.3	90
236	103	7.3	52
237	144	7.3	27
238	12	7.2	76
239	40	7.1	67
240	25	7.0	310
241	261	7.0	19
242	227	7.0	5
243	24	6.9	441
244	46	6.7	305
245	262	6.5	6
246	122	5.9	48
247	303	5.7	6

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References