MySQL Database Development Mastery

This lesson provides an overview of MySQL Server and its database management capabilities.

This lesson guides users through the download and installation process for MySQL Server and MySQL Workbench.

This lesson demonstrates how to connect to MySQL and create a new database.

This lesson explains the steps to drop or remove an existing database in MySQL.

This lesson outlines the process of creating a SQL database table in MySQL.

This lesson shows how to insert data into a table using SQL scripts in MySQL.

This lesson demonstrates how to insert data into a table using MySQL Workbench.

This lesson explains how to select data from a table using SQL scripts in MySQL.

This lesson covers how to apply filters when selecting data from a table in MySQL.

This lesson demonstrates the process of updating existing data in a MySQL table.

This lesson explains how to delete data from a table in MySQL.

This lesson covers the reverse engineering of a database into a model for analysis.

This lesson demonstrates the forward engineering process of converting a data model into a database.

This lesson explains the concepts of relationships, foreign keys, and normalization in database design.

This lesson shows how to create relationships between tables using data modeling techniques.

This lesson demonstrates how to create relationships using the Workbench table design tool.

This lesson explains how to insert records into related tables in MySQL.

This lesson covers how to run inner join queries on related tables in MySQL.

This lesson explains the concepts and usage of left joins, right joins, and cross joins in SQL.

This lesson demonstrates how to group data using the SQL GROUP BY clause.

This lesson focuses on using the SQL AVG aggregate function to calculate average values.

This lesson teaches how to use the SQL COUNT aggregate function to count records.

This lesson covers the SQL MIN and MAX aggregate functions to find minimum and maximum values.

This lesson explains how to use the SQL SUM aggregate function to total numeric values.

This lesson discusses how to use the HAVING clause to split groups in SQL queries.