Mastering MySQL: From Basics to Advanced
This comprehensive course is designed to take you from a beginner to an advanced level in MySQL. You’ll learn the fundamentals of database management, the intricacies of SQL queries, and advanced database optimization techniques. Whether you’re a developer, data analyst, or aspiring database administrator, this course equips you with the skills to effectively manage and query data using MySQL
Welcome to MySQL
-
1
Lesson 1: Introduction to MySQL -
2
Lesson 2: SQL CREATE DATABASE
-
3
Lesson 3: SQL CREATE TABLE Statement
-
4
Lesson 4: SQL INSERT INTO Statement
-
5
Lesson 5: SQL SELECT Statement
-
6
Lesson 6: SQL SELECT DISTINCT Statement
-
7
Lesson 7: SQL WHERE Clause
-
8
Lesson 8: SQL AND & OR Operators
-
9
Lesson 9: SQL ORDER BY Keyword
-
10
Lesson 10: SQL UPDATE Statement
-
11
Lesson 11: SQL DELETE Statement
-
12
Lesson 12: SQL SELECT TOP Clause
-
13
Lesson 13: SQL LIKE Operator
-
14
Lesson 14: SQL IN Operator
-
15
Lesson 15: SQL BETWEEN Operator
-
16
Lesson 16: SQL Aliases
-
17
Lesson 17: SQL Joins
-
18
Lesson 18: SQL INNER JOIN Keyword SQL
-
19
Lesson 19: SQL LEFT JOIN Keyword
-
20
Lesson 20: SQL RIGHT JOIN Keyword
-
21
Lesson 21: SQL FULL OUTER JOIN Keyword
-
22
Lesson 22: SQL UNION Operator
-
23
Lesson 23: SQL Creating Backup table
-
24
Lesson 24: SQL Constraints SQL
-
25
Lesson 25: SQL NOT NULL Constraint
-
26
Lesson 26: SQL UNIQUE Constraint
-
27
Lesson 27: SQL PRIMARY KEY Constraint
-
28
Lesson 28: SQL FOREIGN KEY Constraint
-
29
Lesson 29: SQL CHECK Constraint
-
30
Lesson 30: SQL DEFAULT Constraint
-
31
Lesson 31: SQL CREATE INDEX Statement
-
32
Lesson 32: SQL DROP INDEX, DROP TABLE, and DROP DATABASE
-
33
Lesson 33: SQL ALTER TABLE Statement
-
34
Lesson 34: SQL AUTO INCREMENT
-
35
Lesson 35: SQL View Statement
-
36
Lesson 36: MySQL Data Types
-
37
Lesson 37: SQL Functions
-
38
Lesson 38: SQL AVG() Function
-
39
Lesson 39: SQL COUNT() Function
-
40
Lesson 40 : SQL FIRST() & LAST() Function
-
41
Lesson 41: SQL MAX() & MIN() Function
-
42
Lesson 42: SUM() Function
-
43
Lesson 43: SQL UCASE() & LCASE() Function
-
44
Lesson 44: SQL GROUP BY Statement
-
45
Lesson 45: HAVING
Be the first to add a review.
Please, login to leave a review
