Course content
1Introduction to MySQL Database
2Installing MySQL Server
3Configuring the MySQL environment
4Knowing the MySQL interface
5Creating your first database in MySQL
6Understanding tables in MySQL
7MySQL data types
8Primary and Foreign Keys in MySQL
9Relationships between tables in MySQL
10Data Manipulation in MySQL
11Basic SQL commands: SELECT, INSERT, UPDATE, DELETE
12Aggregate Functions in MySQL
13WHERE clause in MySQL
14Sorting results with ORDER BY
15Limiting results with LIMIT
16Joining tables with JOIN
17Subqueries in MySQL
18Working with Indexes in MySQL
19MySQL Stored Procedures
20Triggers in MySQL
21Views in MySQL
22Transactions in MySQL
23Managing Users and Permissions in MySQL
24Backing Up and Restoring Databases in MySQL
25MySQL query optimization
26Introduction to Data Modeling in MySQL
27Data normalization in MySQL
28Developing a complete project using MySQL
29Integrating MySQL with other technologies
30MySQL database security
31Debugging and Error Handling in MySQL
32Introduction to MySQL Workbench
33Importing and exporting data in MySQL
34Using MySQL with PHP
35Using MySQL with Python
36Using MySQL with Java
37Using MySQL with Node.js
38Using MySQL with C#
39Using MySQL in web applications
40Using MySQL in mobile applications
41Remote connection to MySQL
42MySQL maintenance and monitoring
43MySQL scalability and performance
44Introduction to MySQL Clustering
45Data replication in MySQL
46Binary data storage in MySQL
47Using Regular Expressions in MySQL
48Using Math Functions in MySQL
49Using datetime functions in MySQL
50Using String Functions in MySQL
51Using Conversion Functions in MySQL
52Using flow control functions in MySQL
53Using encryption functions in MySQL
54Using compression functions in MySQL
55Using information functions in MySQL
56Using Group Functions in MySQL
57Using Aggregate Functions in MySQL
58Using window functions in MySQL
59Using System Functions in MySQL
60Introduction to MySQL Shell
61Introduction to MySQL Router
62Introduction to MySQL InnoDB Cluster
63Introduction to MySQL NDB Cluster
64Introduction to MySQL Group Replication
65Introduction to MySQL Fabric
66Introduction to MySQL Partitioning
67Introduction to MySQL Performance Schema
68Introduction to MySQL Information Schema
69Introduction to MySQL Sys Schema
70Introduction to MySQL Connectors
71Introduction to MySQL Workload Analysis
And much more...