SQL exercises

Language

March 11, 16:56 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 
  • 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 (rating stages)
  • DML

Forums

  • Learning stage
  • Rating stages

Certification

  • About certification
  • Certified professionals
  • Statistics
  • Confirm certificate

HELP

Transact-SQL tests

Modelling of data

Personal
page

Exercises voting

Query optimization

Developers & Thanks

For employers

References

Feedback

Support SQL-EX.RU

Poll

For what DBMS, besides SQL Server, you would like to have exercises on the site?

Today statistics

nLog - number of logins;
nSelEx - number of select exercises solved today;
lastEx - number of last select exercise solved;
nDmlEx - number of dml exercises solved today;
Scores - sum of points on the exercises solved today (select and dml)

No Surname nLog nSelEx lastEx nDmlEx Scores

1 Tirskaya I.V. (tiv) 2 10 28 23

2 Makulina Yu. (Yulioka) 2 14 22

3 Mikhajlov A.N. (goodron) 1 6 33 17

4 tan (emmaline) 1 9 9

5 Erika K.C. (kErika) 1 4 22 7

6 Luci L.C. (luci.k02) 1 4 22 7

7 Hoszu A. (Ama) 3 3 22 5

8 Gajdalovich A.A. (alex555) 1 2 50 4

9 Rebrov (Dmitry78) 2 2 9 4

10 knyaginichev S. (knyagich) 1 2 50 4

11 Korentabak A. (koren) 2 2 2 4

12 Shinkarenko D. (Denysss) 1 2 4 3

13 Kitaeva (Olga Kitaeva) 1 1 1 3

14 Kurochkin P.A. (qwrqwr) 1 1 122 3

15 Antonov A.V. (X_O_M_A) 1 1 1 3

16 Litvin M.S. (Mike.S.Litvin) 3 1 29 3

17 M S.A. (Chert) 1 1 1 3

18 Gavlitskij V.A. (Slavich) 2 2 3

19 Bugarchev D. (begemot) 1 2 4 2

20 Mel'nik M.Yu. (Muller) 2 2 4 2

21 Zdvizhkov (AlxLucky) 1 1 34 2

22 Baranov V.E. (barrakuda-v) 1 1 14 2

23 Lyubchenko V.A. (IAS56) 3 1 51 2

24 Didenko T. (Tey) 1 1 51 2

25 Poltavets L.S. (lilyok) 2 1 142 2

26 Simpson (denis00) 1 1 8 2

27 Polikarpov I.A. (Polik) 1 1 48 1

28 Fedorov M.N. (mikff) 1 1 12 1

29 Charyshkin P.P. (PeterChar) 1 1 2 1

30 Musikhin A.M. (Musihin_A) 1 1 2 1

31 Bespyatov A. (lelik_b) 1 1 53 1

32 Ol'shanskij A.V. (alx_ol) 1

33 Subramanian R. (Ramesh.ys) 1

34 No_name A. (AndrewT) 1

35 Pitskhelauri B. (pitskhelauri) 1

36 Klimentovskij A. (askelbox) 1

37 Gorbunov A.V. (risp) 1

38 Karpukhov A. (aleksey_k) 1

39 jain R. (rohit2910) 1

40 Vakhromeeva T. (Tenyva) 6

41 Safronova (Miss Hamster) 1

42 Selyanin M.Yu. (ktulhu) 1

43 Kudryakov A.I. (AKudrakov) 1

44 Shashkin (RSA) 1

45 Ajsakov N.B. (Zhivuschij v poslednij raz…) 1

46 Petrosyan D.V. (Davo) 1

47 Karapetyan T.M. (T I K O) 1

48 Sipachev A. (XelixAlex) 1

49 Novik A.V. (Novik) 3

50 belousov Yu.V. (YuranBBB) 1

51 Martynyuk (Wiedzmen) 1

52 Borovoj N. (Nikita Borovoy) 4

53 Pryalukhin G.E. (Axir) 2

54 Grosu G.F. (amigo793793) 1

55 Martynenko V.Yu. (Fuddy-Duddy) 1

56 Kruzhkinna (Toffee) 1

57 Ershova E.A. (Susana) 1

58 kumar V.K. (vimlesh) 1

59 Kirshanskij S.P. (Vishnya) 2

60 Fomchenkov V.N. (hamp) 1

61 WWW A.W. (ArtUrlWWW7) 3

62 Iljy (iljy) 2

63 Diman D.D. (Dimas123) 1

64 Dvoryaninov V.A. (Valdaj) 2

65 Semaka (tolikas) 2

66 Shipilova E.A. (Mope) 1

67 Bichev K. (gdengam) 1

68 dolgopolova (dankas) 1

69 Bojchuk M.V. (Bol'shoj Bizon) 7

70 D (Leirby) 2

71 Prutkin R.Yu. (Gatrich) 2

72 Dolgopolov V.A. (VDShark) 1

73 C P. (prabhavathi) 2

74 Gololobov (Victor) 3

75 Kosotukhin A.A. (Alexandr Kosotukhin) 1

76 Bazhanova M.A. (RedMouse) 1

77 Bojko D.M. (Angellore) 1

78 Dyachuk V.S. (Vlados) 2

79 Sal'nikov S.A. ($erges) 1

80 Obmankin S.I. (Doc@) 1

81 Zotov P.G. (Ozzy) 4

82 Makarov I.A. (_Bkmz_) 9

83 Tkachev A.B. (Alexandre) 2

84 Tolstikhin K.V. (magi) 1

85 Sidorchuk A.P. (netpobu4) 1

86 Orlov M.V. (Eagleoff) 2

87 Kurbanoff N.I. (Nariman Kurbanoff) 2

88 Ostapchuk A. (_ORA_) 2

89 Drozdkov A.N. (anddros) 1

90 Dubinskij A.V. (_yizraor) 2

91 qweqweqwe (daevil) 1

92 satchidanand S. (pandi) 1

93 Kreslavskij O.M. (Arcan) 3

94 Valuev D.I. (Fiolent) 1

95 Datsyuk V.Yu. (.Wizard) 1

96 Abliyev R. (reuvenab) 1

97 Kubin A.L. (The_Saint) 1

98 Tarasov D.B. (Gavrila) 1

99 Schukin A.S. (Faust) 1

100 Kantorov M.E. (Kantic) 1

101 Karasyova N.V. (vlksm) 1

102 Imaev R. (nrg_fly) 1

103 Sukhnev D.A. (mz) 2

104 E.S. A. (hirmo) 1

105 Maharani J.M. (The Man) 1

106 Chebotarev (EvgeneyV) 1

107 Belozyorova N. (Raduzhnaya) 1

108 Batdalova (Dilyara5) 1

109 bazlov (valbaz2) 3

110 Lipilin A.N. (Bronetapok) 1

111 Ivanchenko A.O. (McCormick) 1

112 Mescheryakov M.S. (Zombie) 1

113 Synilnyk N. (Alan Prost) 1

114 jaya J.P. (jayanthy1) 1

115 Popov D.V. (NuckChorris) 1

116 Panteleev A.A. (Alex_P) 1

117 Bu V.S. (Bushka) 1

118 Pagin (laagin) 3

119 Brodyanskaya S.L. (lady_of_quality) 1

120 voron V.V. (voron400) 1

121 Esin D.E. (membrana) 2

122 Ionescu V. (lucian84) 2

123 Kim J. (kimchi) 1

124 Velizanina S. (sveta123) 2

125 Veselov A. (votan) 1

126 Mustiats M. (xxMikexx) 2

127 Lisovets (buffer_busy) 1

128 kuznetsov S.A. (sergcer) 1

129 Amr-nov (amr-now) 1

130 Koksheneva E.V. (ElKo) 2

131 Kotov A. (Ckpa6) 2

132 Korevo (Korevo) 1

133 Khan F. (fahad777) 1

134 Vanin V. (_Virt_) 1

135 Ionov A.V. (NewLife1) 1

136 Vasiliev (Alex11111111111) 1

137 Filimonov P. (pf_tesla) 1

138 Voitovych T. (Tararasiik) 1

139 Abelyashev N.A. (Tigrolew) 2

140 Chernov A.V. (Darkdog) 1

141 Lezvinskii (DICE) 2

142 Kislak S. (kislak7) 1

143 Mironov (antonio_m) 2

144 Malyugin V.N. (mvn2009) 1

145 Mindarov R.R. (Rafael') 1

146 Trofimov E.S. (TROFIMOVES) 2

147 Kyrgyzbay (aldarkoso) 1

148 Gurin D.S. (pwc) 1

149 mayeshindia (Mayesh Pandey) 3

150 Knuykh (Worker) 1

151 Ivanov I.I. (jjjj) 1

152 Woj M.F. (Madi.czadi) 2

153 Dubirova Z.B. (Zhannatd) 1

154 anda (zhuma) 1

155 Morgun (den-art) 1

156 Frolov (qtroni) 1

157 Yumanov I.V. (SINKSRUS21) 1

158 Ermolaev M.V. (fitis) 3

159 Puchkowsky B.I. (reZX) 2

160 bazerashvili T. (tik) 1

161 Pudkov D. (pdv_i740) 1

162 Smirnov D. (dmitry_smirnov) 1

163 Gromov A.P. (grap) 1

164 Andreww (Andrew)) 1

165 Chebykin N.N. (Nickmaovich) 2

166 lokteva E. (elena_l) 1

167 s (zhyl_en) 1

168 mykhaylova (evg_mykh) 1

169 Aleksandr (Intermediate) 1

170 Razuvaeva (katiki) 1

171 Ostapenko E. (Evgen-ukr) 1

172 Pogreban I.I. (pogreban9) 4

173 Trofimov I. (trafaret) 1

174 Graf (pahealth) 1

175 Buchatskaya E.S. (sunnmy) 1

176 Petrov (ksa) 2

177 arzymatov (n00b) 1

178 Charyshkin O.Yu. (O.Charyshkin) 1

179 Zyablikov A.E. (newmartin) 4

180 Budaghyan L. (Lusnyack) 1

181 Doxer (Doxxer) 1

182 Strel'tsov A.V. (art23) 1

183 L (Ryoko) 1

184 Gromov K.A. (Gromov) 1

185 koper (ekimpl1) 1

186 Grishanov A.V. (z_alex$) 2

187 Salajova E. (Salajka) 1

188 Pronin (sv_sanek) 1

189 Bojko D. (DenisB) 1

190 Runov M. (Lestat) 2

191 kad A.A. (ariel) 1

192 sulima (gulu) 2

193 Lutsenko M. (lutm) 3

194 Al (Aluc) 1

195 K K.K. (Kay) 2

196 Barinov A.S. (Barinov) 1

197 Walker J.W. (JimWalker) 1

198 Ivkin A.V. (anton_iv) 1

199 adonin ([Dimon]) 2

200 Chernousov D.V. (AskDeny) 1

201 Akhmedov V.B. (vudik) 1

202 Ivanov I. (admin) 1

203 yorik Y. (yoriksson) 1

204 Tim (timout) 1

205 Dianov A.S. (santeyDi) 1

206 IreneS (htubcnhfwbz) 1

207 Tambovskij A. (Wolf_T) 1

208 Chujkin (ci) 2

209 Alimbetov R.M. (Votebmila) 5

210 Sergey (S.D.) 2

211 Samkov P. (PavelSam) 5

212 Solyankin A. (Solan) 1

213 Startsev A.V. (Balaur) 1

214 V'yalkova E. (Kattty) 2

215 Kozh (Edulww) 1

216 Petrov (Evgeny165) 1

217 reddy S. (suvi) 1

218 Quinones J.R. (JimBLADEX) 1

219 Usmanov M.I. (Mansur) 1

220 Balykov A.V. (ALEKS_B) 1

221 Klyba N.S. (preux) 2

222 mandadi M.R. (tatamahi) 1

223 J N. (anu20) 1

224 Bezrukov V. (Tranquille) 2

225 Neganov D.A. (Welt) 1

226 pitskhelauri B.D. (beqa picxhelauri) 1

227 EDEN (eden24) 1

228 Nikitin D. (Dmitry82) 1

229 yella (kalyay) 1

230 Sharipov (rsharipov) 1

231 Koshelev D.A. (kda1977) 1

232 Sevast'yanov D.A. (dendevelop2010) 1

233 Surin M.A. (Antimony) 1

234 Uday (Uday.K) 1

235 padonkoff P.P. (padonkoff) 2

236 mudiraj S. (moddu) 1

237 Anis'kin A.V. (Prosto papa) 1

238 SSSRSAV (roman123456789) 1

239 Bali M. (balimis1) 2

240 Shuvalova (924) 1

241 pant V. (vandy) 1

242 arora C. (chanchal) 1

243 Pogudin S.I. (Stoc) 1

244 Parkhomenko E.V. (katerina_parha) 1

245 Begmetov R. (-Rust-) 1

246 K M. (4time) 1

247 fateevnm (fateev) 1

248 Muzyka V.A. (Muzon) 1

249 Vezhev A.V. (Aleksandr Vezhev) 1

250 Vasil'ev (Vasilek) 1

251 Saraswat M. (Manish78) 1

252 Ufaeva O.U. (OlgaUfaeva) 1

253 Patil G.A. (GAP) 1

254 Farmer (Mylene) 1

255 Bojko (qweasdzxc) 1

256 Sabirzyanov K.E. (Sabirzyanov) 1

257 Khristolyubov A.S. (supa_sasha) 2

258 yura S.M. (leprechaun) 1

259 Timoshenko D.N. (Flashman) 1

260 Oleksak (roleksak) 1

261 Unregistered 47

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References