Official Certification Course

Become a sql Developer

Master sql with our comprehensive, free interactive course. Pass the exam to earn your industry-recognized certificate. Includes interactive examples, quizzes, and a verifiable digital certificate upon completion.

Start Learning Take Certification Exam

sql

Course Syllabus

2SQL Keywords Reference

6SQL Introduction

8SQL SELECT Statement

9SQL SELECT DISTINCT Statement

10SQL WHERE Clause

11SQL ORDER BY Keyword

12SQL AND Operator

13SQL OR Operator

14SQL NOT Operator

15SQL INSERT INTO Statement

16SQL NULL Values - IS NULL and IS NOT NULL

17SQL UPDATE Statement

18SQL DELETE Statement

19SQL SELECT TOP, LIMIT, FETCH FIRST ROWS ONLY, ROWNUM

20SQL Aggregate Functions

21SQL MIN() and MAX() Functions

22SQL COUNT() Function

23SQL SUM() Function

24SQL AVG() Function

25SQL LIKE Operator

26SQL Wildcard Characters

27SQL IN Operator

28SQL BETWEEN Operator

31SQL INNER JOIN

32SQL LEFT JOIN Keyword

33SQL RIGHT JOIN Keyword

34SQL FULL OUTER JOIN Keyword

35SQL Self Join

36SQL UNION Operator

37SQL UNION ALL Operator

38SQL GROUP BY Statement

39SQL HAVING Clause

40SQL EXISTS Operator

41SQL ANY and ALL Operators

42SQL SELECT INTO Statement

43SQL INSERT INTO SELECT Statement

44SQL CASE Expression

45SQL ISNULL(), NVL(), IFNULL() and COALESCE() Functions

46SQL Stored Procedures

48SQL Operators

49SQL CREATE DATABASE Statement

50SQL DROP DATABASE Statement

51SQL BACKUP DATABASE Statement

52SQL CREATE TABLE Statement

53SQL DROP TABLE Statement

54SQL ALTER TABLE Statement

55SQL Constraints

56SQL NOT NULL Constraint

57SQL UNIQUE Constraint

58SQL PRIMARY KEY Constraint

59SQL FOREIGN KEY Constraint

60SQL CHECK Constraint

61SQL DEFAULT Constraint

62SQL CREATE INDEX Statement

63SQL AUTO INCREMENT a Field

64Date Functions in SQL Server and MySQL

65SQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statements

66SQL Injection

68SQL Data Types for MySQL, SQL Server, and MS Access

70SQL ADD CONSTRAINT

73SQL ALTER COLUMN

74SQL ALTER TABLE

84SQL CONSTRAINT

86SQL CREATE DATABASE

87SQL CREATE INDEX

88SQL CREATE OR REPLACE VIEW

89SQL CREATE TABLE

90SQL CREATE PROCEDURE

91SQL CREATE UNIQUE INDEX

92SQL CREATE VIEW

97SQL SELECT DISTINCT

99SQL DROP COLUMN

100SQL DROP CONSTRAINT

101SQL DROP DATABASE

102SQL DROP DEFAULT

103SQL DROP INDEX

104SQL DROP TABLE, TRUNCATE TABLE

105SQL DROP VIEW

108SQL FOREIGN KEY

110SQL FULL OUTER JOIN

111SQL GROUP BY

115SQL INNER JOIN

116SQL INSERT INTO

117SQL INSERT INTO SELECT

119SQL IS NOT NULL

121SQL LEFT JOIN

123SQL SELECT TOP, LIMIT, ROWNUM

125SQL NOT NULL

127SQL ORDER BY

128SQL FULL OUTER JOIN

129SQL PRIMARY KEY

130SQL CREATE PROCEDURE

131SQL RIGHT JOIN

132SQL SELECT TOP, LIMIT, ROWNUM

134SQL SELECT DISTINCT

135SQL SELECT INTO

136SQL SELECT TOP, LIMIT, ROWNUM

138SQL CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE

139SQL SELECT TOP, LIMIT, ROWNUM

140SQL DROP TABLE, TRUNCATE TABLE

142SQL UNION ALL

146SQL CREATE VIEW, CREATE OR REPLACE VIEW, DROP VIEW

148MySQL Functions

149MySQL ASCII() Function

150MySQL CHAR_LENGTH() Function

151MySQL CHARACTER_LENGTH() Function

152MySQL CONCAT() Function

153MySQL CONCAT_WS() Function

154MySQL FIELD() Function

155MySQL FIND_IN_SET() Function

156MySQL FORMAT() Function

157MySQL INSERT() Function

158MySQL INSTR() Function

159MySQL LCASE() Function

160MySQL LEFT() Function

161MySQL LENGTH() Function

162MySQL LOCATE() Function

163MySQL LOWER() Function

164MySQL LPAD() Function

165MySQL LTRIM() Function

166MySQL MID() Function

167MySQL POSITION() Function

168MySQL REPEAT() Function

169MySQL REPLACE() Function

170MySQL REVERSE() Function

171MySQL RIGHT() Function

172MySQL RPAD() Function

173MySQL RTRIM() Function

174MySQL SPACE() Function

175MySQL STRCMP() Function

176MySQL SUBSTR() Function

177MySQL SUBSTRING() Function

178MySQL SUBSTRING_INDEX() Function

179MySQL TRIM() Function

180MySQL UCASE() Function

181MySQL UPPER() Function

182MySQL ABS() Function

183MySQL ACOS() Function

184MySQL ASIN() Function

185MySQL ATAN() Function

186MySQL ATAN2() Function

187MySQL AVG() Function

188MySQL CEIL() Function

189MySQL CEILING() Function

190MySQL COS() Function

191MySQL COT() Function

192MySQL COUNT() Function

193MySQL DEGREES() Function

194MySQL DIV Function

195MySQL EXP() Function

196MySQL FLOOR() Function

197MySQL GREATEST() Function

198MySQL LEAST() Function

199MySQL LN() Function

200MySQL LOG() Function

201MySQL LOG10() Function

202MySQL LOG2() Function

203MySQL MAX() Function

204MySQL MIN() Function

205MySQL MOD() Function

206MySQL PI() Function

207MySQL POW() Function

208MySQL POWER() Function

209MySQL RADIANS() Function

210MySQL ROUND() Function

211MySQL SIGN() Function

212MySQL SIN() Function

213MySQL SQRT() Function

214MySQL SUM() Function

215MySQL TAN() Function

216MySQL TRUNCATE() Function

217MySQL ADDDATE() Function

218MySQL ADDTIME() Function

219MySQL CURDATE() Function

220MySQL CURRENT_DATE() Function

221MySQL CURRENT_TIME() Function

222MySQL CURRENT_TIMESTAMP() Function

223MySQL CURTIME() Function

224MySQL DATE() Function

225MySQL DATEDIFF() Function

226MySQL DATE_ADD() Function

227MySQL DATE_FORMAT() Function

228MySQL DATE_SUB() Function

229MySQL DAY() Function

230MySQL DAYNAME() Function

231MySQL DAYOFMONTH() Function

232MySQL DAYOFWEEK() Function

233MySQL DAYOFYEAR() Function

234MySQL EXTRACT() Function

235MySQL FROM_DAYS() Function

236MySQL HOUR() Function

237MySQL LAST_DAY() Function

238MySQL LOCALTIME() Function

239MySQL LOCALTIMESTAMP() Function

240MySQL MAKEDATE() Function

241MySQL MAKETIME() Function

242MySQL MICROSECOND() Function

243MySQL MINUTE() Function

244MySQL MONTH() Function

245MySQL MONTHNAME() Function

246MySQL NOW() Function

247MySQL PERIOD_ADD() Function

248MySQL PERIOD_DIFF() Function

249MySQL QUARTER() Function

250MySQL SECOND() Function

251MySQL SEC_TO_TIME() Function

252MySQL STR_TO_DATE() Function

253MySQL SUBDATE() Function

254MySQL SUBTIME() Function

255MySQL SYSDATE() Function

256MySQL TIME() Function

257MySQL TIME_FORMAT() Function

258MySQL TIME_TO_SEC() Function

259MySQL TIMEDIFF() Function

260MySQL TIMESTAMP() Function

261MySQL TO_DAYS() Function

262MySQL WEEK() Function

263MySQL WEEKDAY() Function

264MySQL WEEKOFYEAR() Function

265MySQL YEAR() Function

266MySQL YEARWEEK() Function

267MySQL BIN() Function

268MySQL BINARY Function

269MySQL CASE Function

270MySQL CAST() Function

271MySQL COALESCE() Function

272MySQL CONNECTION_ID() Function

273MySQL CONV() Function

274MySQL CONVERT() Function

275MySQL CURRENT_USER() Function

276MySQL DATABASE() Function

277MySQL IF() Function

278MySQL IFNULL() Function

279MySQL ISNULL() Function

280MySQL LAST_INSERT_ID() Function

281MySQL NULLIF() Function

282MySQL SESSION_USER() Function

283MySQL SYSTEM_USER() Function

284MySQL USER() Function

285MySQL VERSION() Function

286SQL Server Functions

287SQL Server ASCII() Function

288SQL Server CHAR() Function

289SQL Server CHARINDEX() Function

290SQL Server CONCAT() Function

291SQL Server Concat with +

292SQL Server CONCAT_WS() Function

293SQL Server DATALENGTH() Function

294SQL Server DIFFERENCE() Function

295SQL Server FORMAT() Function

296SQL Server LEFT() Function

297SQL Server LEN() Function

298SQL Server LOWER() Function

299SQL Server LTRIM() Function

300SQL Server NCHAR() Function

301SQL Server PATINDEX() Function

302SQL Server QUOTENAME() Function

303SQL Server REPLACE() Function

304SQL Server REPLICATE() Function

305SQL Server REVERSE() Function

306SQL Server RIGHT() Function

307SQL Server RTRIM() Function

308SQL Server SOUNDEX() Function

309SQL Server SPACE() Function

310SQL Server STR() Function

311SQL Server STUFF() Function

312SQL Server SUBSTRING() Function

313SQL Server TRANSLATE() Function

314SQL Server TRIM() Function

315SQL Server UNICODE() Function

316SQL Server UPPER() Function

317SQL Server ABS() Function

318SQL Server ACOS() Function

319SQL Server ASIN() Function

320SQL Server ATAN() Function

321SQL Server ATN2() Function

322SQL Server AVG() Function

323SQL Server CEILING() Function

324SQL Server COT() Function

325SQL Server DEGREES() Function

326SQL Server EXP() Function

327SQL Server FLOOR() Function

328SQL Server LOG() Function

329SQL Server LOG10() Function

330SQL Server MAX() Function

331SQL Server MIN() Function

332SQL Server PI() Function

333SQL Server POWER() Function

334SQL Server RADIANS() Function

335SQL Server RAND() Function

336SQL Server ROUND() Function

337SQL Server SIGN() Function

338SQL Server SIN() Function

339SQL Server SQRT() Function

340SQL Server SQUARE() Function

341SQL Server SUM() Function

342SQL Server TAN() Function

343SQL Server CURRENT_TIMESTAMP Function

344SQL Server DATEADD() Function

345SQL Server DATEDIFF() Function

346SQL Server DATEFROMPARTS() Function

347SQL Server DATENAME() Function

348SQL Server DATEPART() Function

349SQL Server DAY() Function

350SQL Server GETDATE() Function

351SQL Server GETUTCDATE() Function

352SQL Server ISDATE() Function

353SQL Server MONTH() Function

354SQL Server SYSDATETIME() Function

355SQL Server YEAR() Function

356SQL Server CAST() Function

357SQL Server COALESCE() Function

358SQL Server CONVERT() Function

359SQL Server CURRENT_USER Function

360SQL Server IIF() Function

361SQL Server ISNULL() Function

362SQL Server ISNUMERIC() Function

363SQL Server NULLIF() Function

364SQL Server SESSION_USER Function

365SQL Server SESSIONPROPERTY() Function

366SQL Server SYSTEM_USER Function

367SQL Server USER_NAME() Function

368MS Access Functions

369MS Access Asc() Function

370MS Access Chr() Function

371MS Access Concat with &

372MS Access CurDir() Function

373MS Access Format() Function

374MS Access InStr() Function

375MS Access InstrRev() Function

376MS Access LCase() Function

377MS Access Left() Function

378MS Access Len() Function

379MS Access LTrim() Function

380MS Access Mid() Function

381MS Access Replace() Function

382MS Access Right() Function

383MS Access RTrim() Function

384MS Access Space() Function

385MS Access Split() Function

386MS Access Str() Function

387MS Access StrComp() Function

388MS Access StrConv() Function

389MS Access StrReverse() Function

390MS Access Trim() Function

391MS Access UCase() Function

392MS Access Abs() Function

393MS Access Atn() Function

394MS Access Avg() Function

395MS Access Cos() Function

396MS Access Count() Function

397MS Access Exp() Function

398MS Access Fix() Function

399MS Access Format() Function

400MS Access Int() Function

401MS Access Max() Function

402MS Access Min() Function

403MS Access Randomize() Function

404MS Access Rnd Function

405MS Access Round() Function

406MS Access Sgn() Function

407MS Access Sqr() Function

408MS Access Sum() Function

409MS Access Val() Function

410MS Access Date() Function

411MS Access DateAdd() Function

412MS Access DateDiff() Function

413MS Access DatePart() Function

414MS Access DateSerial() Function

415MS Access DateValue() Function

416MS Access Day() Function

417MS Access Format() Function

418MS Access Hour() Function

419MS Access Minute() Function

420MS Access Month() Function

421MS Access MonthName() Function

422MS Access Now() Function

423MS Access Second() Function

424MS Access Time() Function

425MS Access TimeSerial() Function

426MS Access TimeValue() Function

427MS Access Weekday() Function

428MS Access WeekdayName() Function

429MS Access Year() Function

430MS Access CurrentUser() Function

431MS Access Environ() Function

432MS Access IsDate() Function

433MS Access IsNull() Function

434MS Access IsNumeric() Function

435SQL Quick Reference

436SQL Online Editor (Compiler)

437Create SQL Server | W3Schools.com | W3Schools Spaces

438SQL Syllabus (Curriculum)

439SQL Study Plan (Lesson Plan)

440W3Schools SQL Bootcamp

441W3Schools SQL Certificate

442SQL Training

443SQL Exercises

444SQL AND Operator

445SQL COUNT(), AVG() and SUM() Functions

446SQL Syllabus (Curriculum)

Certificate of Completion

Pass the exam with 70% or higher to earn your official, verifiable certificate.

Exam Duration30 Mins

Questions20-30

Passing Score70%

Why learn sql?

High demand in the job market
Core technology for web development
Foundation for advanced frameworks