Skip to content
LEARN
Learn
Explore
Roadmaps
Paths
Organizations
Contact
Start Learning
Learn
MySQL
Learn MySQL
Databases
Complete MYSQL tutorial and reference dataset.
beginner
205 lessons
~4.7 hours
Start learning
Lessons
MySQL Tutorial
· 3 lessons
01
MySQL Tutorial
1 min
02
Introduction to MySQL
1 min
03
MySQL RDBMS
3 min
MySQL SQL
· 43 lessons
04
MySQL SQL
2 min
05
MySQL SELECT Statement
2 min
06
MySQL SELECT DISTINCT Statement
2 min
07
MySQL WHERE Clause
2 min
08
MySQL ORDER BY Keyword
3 min
09
MySQL AND Operator
2 min
10
MySQL OR Operator
2 min
11
MySQL NOT Operator
3 min
12
MySQL INSERT INTO Statement
3 min
13
MySQL NULL Values
2 min
14
MySQL UPDATE Statement
3 min
15
MySQL DELETE Statement
2 min
16
MySQL LIMIT Clause
2 min
17
MySQL Aggregate Functions
1 min
18
MySQL MIN() Function
1 min
19
MySQL MAX() Function
1 min
20
MySQL COUNT() Function
2 min
21
MySQL SUM() Function
1 min
22
MySQL AVG() Function
2 min
23
MySQL LIKE Operator
3 min
24
MySQL Wildcards
3 min
25
MySQL IN Operator
2 min
26
MySQL BETWEEN Operator
3 min
27
MySQL Aliases
2 min
28
MySQL Joins
2 min
29
MySQL INNER JOIN
2 min
30
MySQL LEFT JOIN
2 min
31
MySQL RIGHT JOIN
2 min
32
MySQL CROSS JOIN
2 min
33
MySQL Self Join
1 min
34
MySQL UNION Operator
2 min
35
MySQL UNION ALL Operator
2 min
36
MySQL GROUP BY Statement
2 min
37
MySQL HAVING Clause
2 min
38
MySQL EXISTS Operator
2 min
39
MySQL ANY Operator
2 min
40
MySQL ALL Operator
1 min
41
MySQL INSERT INTO SELECT Statement
2 min
42
MySQL CASE Statement
1 min
43
MySQL NULL Functions
1 min
44
MySQL Stored Procedures
3 min
45
MySQL Comments
1 min
46
MySQL Operators
2 min
MySQL Database
· 18 lessons
47
MySQL CREATE DATABASE Statement
1 min
48
MySQL DROP DATABASE Statement
1 min
49
MySQL CREATE TABLE Statement
2 min
50
MySQL DROP TABLE Statement
1 min
51
MySQL ALTER TABLE Statement
3 min
52
MySQL Constraints
1 min
53
MySQL NOT NULL Constraint
1 min
54
MySQL UNIQUE Constraint
1 min
55
MySQL PRIMARY KEY Constraint
2 min
56
MySQL FOREIGN KEY Constraint
2 min
57
MySQL CHECK Constraint
1 min
58
MySQL DEFAULT Constraint
1 min
59
MySQL CREATE INDEX Statement
1 min
60
MySQL AUTO INCREMENT Field
1 min
61
MySQL Working With Dates
2 min
62
MySQL Views
2 min
63
MySQL - SQL Injection
2 min
64
MySQL - Prepared Statements
2 min
MySQL References
· 140 lessons
65
MySQL Data Types
Reference
5 min
66
MySQL Functions
Reference
9 min
67
MySQL ASCII() Function
Reference
1 min
68
MySQL CHAR_LENGTH() Function
Reference
1 min
69
MySQL CHARACTER_LENGTH() Function
Reference
1 min
70
MySQL CONCAT() Function
Reference
1 min
71
MySQL CONCAT_WS() Function
Reference
1 min
72
MySQL FIELD() Function
Reference
1 min
73
MySQL FIND_IN_SET() Function
Reference
1 min
74
MySQL FORMAT() Function
Reference
1 min
75
MySQL INSERT() Function
Reference
1 min
76
MySQL INSTR() Function
Reference
1 min
77
MySQL LCASE() Function
Reference
1 min
78
MySQL LEFT() Function
Reference
1 min
79
MySQL LENGTH() Function
Reference
1 min
80
MySQL LOCATE() Function
Reference
1 min
81
MySQL LOWER() Function
Reference
1 min
82
MySQL LPAD() Function
Reference
1 min
83
MySQL LTRIM() Function
Reference
1 min
84
MySQL MID() Function
Reference
1 min
85
MySQL POSITION() Function
Reference
1 min
86
MySQL REPEAT() Function
Reference
1 min
87
MySQL REPLACE() Function
Reference
1 min
88
MySQL REVERSE() Function
Reference
1 min
89
MySQL RIGHT() Function
Reference
1 min
90
MySQL RPAD() Function
Reference
1 min
91
MySQL RTRIM() Function
Reference
1 min
92
MySQL SPACE() Function
Reference
1 min
93
MySQL STRCMP() Function
Reference
1 min
94
MySQL SUBSTR() Function
Reference
1 min
95
MySQL SUBSTRING() Function
Reference
1 min
96
MySQL SUBSTRING_INDEX() Function
Reference
1 min
97
MySQL TRIM() Function
Reference
1 min
98
MySQL UCASE() Function
Reference
1 min
99
MySQL UPPER() Function
Reference
1 min
100
MySQL ABS() Function
Reference
1 min
101
MySQL ACOS() Function
Reference
1 min
102
MySQL ASIN() Function
Reference
1 min
103
MySQL ATAN() Function
Reference
1 min
104
MySQL ATAN2() Function
Reference
1 min
105
MySQL AVG() Function
Reference
1 min
106
MySQL CEIL() Function
Reference
1 min
107
MySQL CEILING() Function
Reference
1 min
108
MySQL COS() Function
Reference
1 min
109
MySQL COT() Function
Reference
1 min
110
MySQL COUNT() Function
Reference
1 min
111
MySQL DEGREES() Function
Reference
1 min
112
MySQL DIV Function
Reference
1 min
113
MySQL EXP() Function
Reference
1 min
114
MySQL FLOOR() Function
Reference
1 min
115
MySQL GREATEST() Function
Reference
1 min
116
MySQL LEAST() Function
Reference
1 min
117
MySQL LN() Function
Reference
1 min
118
MySQL LOG() Function
Reference
1 min
119
MySQL LOG10() Function
Reference
1 min
120
MySQL LOG2() Function
Reference
1 min
121
MySQL MAX() Function
Reference
1 min
122
MySQL MIN() Function
Reference
1 min
123
MySQL MOD() Function
Reference
1 min
124
MySQL PI() Function
Reference
1 min
125
MySQL POW() Function
Reference
1 min
126
MySQL POWER() Function
Reference
1 min
127
MySQL RADIANS() Function
Reference
1 min
128
MySQL RAND() Function
Reference
1 min
129
MySQL ROUND() Function
Reference
1 min
130
MySQL SIGN() Function
Reference
1 min
131
MySQL SIN() Function
Reference
1 min
132
MySQL SQRT() Function
Reference
1 min
133
MySQL SUM() Function
Reference
1 min
134
MySQL TAN() Function
Reference
1 min
135
MySQL TRUNCATE() Function
Reference
1 min
136
MySQL ADDDATE() Function
Reference
1 min
137
MySQL ADDTIME() Function
Reference
1 min
138
MySQL CURDATE() Function
Reference
1 min
139
MySQL CURRENT_DATE() Function
Reference
1 min
140
MySQL CURRENT_TIME() Function
Reference
1 min
141
MySQL CURRENT_TIMESTAMP() Function
Reference
1 min
142
MySQL CURTIME() Function
Reference
1 min
143
MySQL DATE() Function
Reference
1 min
144
MySQL DATEDIFF() Function
Reference
1 min
145
MySQL DATE_ADD() Function
Reference
1 min
146
MySQL DATE_FORMAT() Function
Reference
4 min
147
MySQL DATE_SUB() Function
Reference
1 min
148
MySQL DAY() Function
Reference
1 min
149
MySQL DAYNAME() Function
Reference
1 min
150
MySQL DAYOFMONTH() Function
Reference
1 min
151
MySQL DAYOFWEEK() Function
Reference
1 min
152
MySQL DAYOFYEAR() Function
Reference
1 min
153
MySQL EXTRACT() Function
Reference
1 min
154
MySQL FROM_DAYS() Function
Reference
1 min
155
MySQL HOUR() Function
Reference
1 min
156
MySQL LAST_DAY() Function
Reference
1 min
157
MySQL LOCALTIME() Function
Reference
1 min
158
MySQL LOCALTIMESTAMP() Function
Reference
1 min
159
MySQL MAKEDATE() Function
Reference
1 min
160
MySQL MAKETIME() Function
Reference
1 min
161
MySQL MICROSECOND() Function
Reference
1 min
162
MySQL MINUTE() Function
Reference
1 min
163
MySQL MONTH() Function
Reference
1 min
164
MySQL MONTHNAME() Function
Reference
1 min
165
MySQL NOW() Function
Reference
1 min
166
MySQL PERIOD_ADD() Function
Reference
1 min
167
MySQL PERIOD_DIFF() Function
Reference
1 min
168
MySQL QUARTER() Function
Reference
1 min
169
MySQL SECOND() Function
Reference
1 min
170
MySQL SEC_TO_TIME() Function
Reference
1 min
171
MySQL STR_TO_DATE() Function
Reference
4 min
172
MySQL SUBDATE() Function
Reference
1 min
173
MySQL SUBTIME() Function
Reference
1 min
174
MySQL SYSDATE() Function
Reference
1 min
175
MySQL TIME() Function
Reference
1 min
176
MySQL TIME_FORMAT() Function
Reference
2 min
177
MySQL TIME_TO_SEC() Function
Reference
1 min
178
MySQL TIMEDIFF() Function
Reference
1 min
179
MySQL TIMESTAMP() Function
Reference
1 min
180
MySQL TO_DAYS() Function
Reference
1 min
181
MySQL WEEK() Function
Reference
2 min
182
MySQL WEEKDAY() Function
Reference
1 min
183
MySQL WEEKOFYEAR() Function
Reference
1 min
184
MySQL YEAR() Function
Reference
1 min
185
MySQL YEARWEEK() Function
Reference
1 min
186
MySQL BIN() Function
Reference
1 min
187
MySQL BINARY Function
Reference
1 min
188
MySQL CASE Function
Reference
1 min
189
MySQL CAST() Function
Reference
2 min
190
MySQL COALESCE() Function
Reference
1 min
191
MySQL CONNECTION_ID() Function
Reference
1 min
192
MySQL CONV() Function
Reference
1 min
193
MySQL CONVERT() Function
Reference
2 min
194
MySQL CURRENT_USER() Function
Reference
1 min
195
MySQL DATABASE() Function
Reference
1 min
196
MySQL IF() Function
Reference
1 min
197
MySQL IFNULL() Function
Reference
1 min
198
MySQL ISNULL() Function
Reference
1 min
199
MySQL LAST_INSERT_ID() Function
Reference
1 min
200
MySQL NULLIF() Function
Reference
1 min
201
MySQL SESSION_USER() Function
Reference
1 min
202
MySQL SYSTEM_USER() Function
Reference
1 min
203
MySQL USER() Function
Reference
1 min
204
MySQL VERSION() Function
Reference
1 min
MySQL Examples
· 1 lessons
205
MySQL Examples
3 min