Official Certification Course

Become a mysql Developer

Master mysql 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

mysql

Course Syllabus

1MySQL Tutorial

2MySQL Data Types

3MySQL Exercises

5MySQL Introduction

6MySQL RDBMS - Relational Database Management System

8MySQL SELECT Statement

9MySQL WHERE Clause

10MySQL AND, OR, NOT Operators

11MySQL ORDER BY Keyword

12MySQL INSERT INTO Statement

13MySQL NULL Values - IS NULL and IS NOT NULL

14MySQL UPDATE Statement

15MySQL DELETE Statement

17MySQL MIN() and MAX() Functions

18MySQL COUNT(), AVG() and SUM() Functions

19MySQL LIKE Operator

20MySQL Wildcard Characters

21MySQL IN Operator

22MySQL BETWEEN Operator

23MySQL Aliases

25MySQL INNER JOIN Keyword

26MySQL LEFT JOIN Keyword

27MySQL RIGHT JOIN Keyword

28MySQL CROSS JOIN Keyword

29MySQL Self Join

30MySQL UNION Operator

31MySQL UNION ALL Operator

32MySQL GROUP BY Statement

33MySQL HAVING Clause

34MySQL EXISTS Operator

35MySQL ANY and ALL Operators

36MySQL INSERT INTO SELECT Statement

37MySQL CASE Statement

38MySQL IFNULL() and COALESCE() Functions

39MySQL Comments

40MySQL Operators

41MySQL CREATE DATABASE Statement

42MySQL DROP DATABASE Statement

43MySQL CREATE TABLE Statement

44MySQL DROP TABLE Statement

45MySQL ALTER TABLE Statement

46MySQL Constraints

47MySQL NOT NULL Constraint

48MySQL UNIQUE Constraint

49MySQL PRIMARY KEY Constraint

50MySQL FOREIGN KEY Constraint

51MySQL CHECK Constraint

52MySQL DEFAULT Constraint

53MySQL CREATE INDEX Statement

54MySQL AUTO INCREMENT a Field

55MySQL Date Functions

56MySQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statements

57MySQL Functions

58MySQL ASCII() Function

59MySQL CHAR_LENGTH() Function

60MySQL CHARACTER_LENGTH() Function

61MySQL CONCAT() Function

62MySQL CONCAT_WS() Function

63MySQL FIELD() Function

64MySQL FIND_IN_SET() Function

65MySQL FORMAT() Function

66MySQL INSERT() Function

67MySQL INSTR() Function

68MySQL LCASE() Function

69MySQL LEFT() Function

70MySQL LENGTH() Function

71MySQL LOCATE() Function

72MySQL LOWER() Function

73MySQL LPAD() Function

74MySQL LTRIM() Function

75MySQL MID() Function

76MySQL POSITION() Function

77MySQL REPEAT() Function

78MySQL REPLACE() Function

79MySQL REVERSE() Function

80MySQL RIGHT() Function

81MySQL RPAD() Function

82MySQL RTRIM() Function

83MySQL SPACE() Function

84MySQL STRCMP() Function

85MySQL SUBSTR() Function

86MySQL SUBSTRING() Function

87MySQL SUBSTRING_INDEX() Function

88MySQL TRIM() Function

89MySQL UCASE() Function

90MySQL UPPER() Function

91MySQL ABS() Function

92MySQL ACOS() Function

93MySQL ASIN() Function

94MySQL ATAN() Function

95MySQL ATAN2() Function

96MySQL AVG() Function

97MySQL CEIL() Function

98MySQL CEILING() Function

99MySQL COS() Function

100MySQL COT() Function

101MySQL COUNT() Function

102MySQL DEGREES() Function

103MySQL DIV Function

104MySQL EXP() Function

105MySQL FLOOR() Function

106MySQL GREATEST() Function

107MySQL LEAST() Function

108MySQL LN() Function

109MySQL LOG() Function

110MySQL LOG10() Function

111MySQL LOG2() Function

112MySQL MAX() Function

113MySQL MIN() Function

114MySQL MOD() Function

115MySQL PI() Function

116MySQL POW() Function

117MySQL POWER() Function

118MySQL RADIANS() Function

119MySQL RAND() Function

120MySQL ROUND() Function

121MySQL SIGN() Function

122MySQL SIN() Function

123MySQL SQRT() Function

124MySQL SUM() Function

125MySQL TAN() Function

126MySQL TRUNCATE() Function

127MySQL ADDDATE() Function

128MySQL ADDTIME() Function

129MySQL CURDATE() Function

130MySQL CURRENT_DATE() Function

131MySQL CURRENT_TIME() Function

132MySQL CURRENT_TIMESTAMP() Function

133MySQL CURTIME() Function

134MySQL DATE() Function

135MySQL DATEDIFF() Function

136MySQL DATE_ADD() Function

137MySQL DATE_FORMAT() Function

138MySQL DATE_SUB() Function

139MySQL DAY() Function

140MySQL DAYNAME() Function

141MySQL DAYOFMONTH() Function

142MySQL DAYOFWEEK() Function

143MySQL DAYOFYEAR() Function

144MySQL EXTRACT() Function

145MySQL FROM_DAYS() Function

146MySQL HOUR() Function

147MySQL LAST_DAY() Function

148MySQL LOCALTIME() Function

149MySQL LOCALTIMESTAMP() Function

150MySQL MAKEDATE() Function

151MySQL MAKETIME() Function

152MySQL MICROSECOND() Function

153MySQL MINUTE() Function

154MySQL MONTH() Function

155MySQL MONTHNAME() Function

156MySQL NOW() Function

157MySQL PERIOD_ADD() Function

158MySQL PERIOD_DIFF() Function

159MySQL QUARTER() Function

160MySQL SECOND() Function

161MySQL SEC_TO_TIME() Function

162MySQL STR_TO_DATE() Function

163MySQL SUBDATE() Function

164MySQL SUBTIME() Function

165MySQL SYSDATE() Function

166MySQL TIME() Function

167MySQL TIME_FORMAT() Function

168MySQL TIME_TO_SEC() Function

169MySQL TIMEDIFF() Function

170MySQL TIMESTAMP() Function

171MySQL TO_DAYS() Function

172MySQL WEEK() Function

173MySQL WEEKDAY() Function

174MySQL WEEKOFYEAR() Function

175MySQL YEAR() Function

176MySQL YEARWEEK() Function

177MySQL BIN() Function

178MySQL BINARY Function

179MySQL CASE Function

180MySQL CAST() Function

181MySQL COALESCE() Function

182MySQL CONNECTION_ID() Function

183MySQL CONV() Function

184MySQL CONVERT() Function

185MySQL CURRENT_USER() Function

186MySQL DATABASE() Function

187MySQL IF() Function

188MySQL IFNULL() Function

189MySQL ISNULL() Function

190MySQL LAST_INSERT_ID() Function

191MySQL NULLIF() Function

192MySQL SESSION_USER() Function

193MySQL SYSTEM_USER() Function

194MySQL USER() Function

195MySQL VERSION() Function

196MySQL Examples

197MySQL Online Editor (Compiler)

198MySQL Syllabus (Curriculum)

199MySQL Study Plan (Lesson Plan)

200W3Schools MySQL Certificate

201MySQL Exercises

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 mysql?

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