• Module 01:  Introduction to MySQL Server and Databases

My SQL Server is a relational database management system or RDBMS. A DBMS is a program that enables its users to access databases, manipulate data, reports, or representation of data. This module looks at what is data, a database, a table, relationships, and foreign keys.

• Module 02: Download and Install MySQL Server and MySQL Workbench

A video walkthrough to download and install MySQL Server and Workbench.

• Module 01: Connect and Create a Database

This video looks at connecting to a database using SQL commands for the MySQL Server and creating your first database.

• Module 02: Drop or Remove Database

This video guides you with dropping or removing a database by using an SQL command script.

• Module 03: Create an SQL Database Table

This video covers quite a few concepts, namely creating tables using SQL scripts, and the fact that we can have multiple commands in one file, and how we can execute them all vs executing them in parts.

• Module 04: Insert Data into the Table with SQL Script

In this lesson, we will look at inserting records into our tables. To begin this exercise, we will use a script and we will look at the syntax to insert records into our student table.

• Module 05: Insert Data into the Table with Workbench

In this video, we will look at using the MySQL Workbench interface to insert records into our data tables. The MySQL Workbench allows you to insert records directly without having to write any SQL code.

• Module 06: Select Data from the Table with SQL Script

In this lesson, we will discuss how we go about selecting or viewing records (using SQL statements) in our database tables.

• Module 07: Select Data with Filters

In this video, we will learn how the Workbench generates records and about more advanced queries in terms of custom columns and filters.

• Module 08: Update Data in the Table

In this lesson, we will look at how we can go about updating data that is already in our database with SQL statements.

• Module 09: Delete Data from the Table

In this tutorial, we will learn how to remove records from our database.

• Module 10: Reverse Engineer Database into Model

This video covers how we can go about reverse engineering our newly created database into a database model. This is a graphical representation of our database.

• Module 11: Forward Engineer Data Model into Database

Learn how to forward engineer a data model into a database. This time, instead of writing scripts or going into the user interface and creating the database upfront, we want to take it from the modelling perspective. This is for people who are visual first.

• Module 01: What are Relationships, Foreign Keys and Normalization?

Study relational database design as it relates to relationships, foreign keys and normalization.

• Module 02: Create Relationships with Data Modelling

In this video, we will learn how to start modifying our databases so we can prepare them to have relationships and foreign keys.

• Module 03: Create Relationships with Workbench Table Design Tool

Working with our school database, we will modify the table to support foreign keys. We will be adding more tables to this database using Workbench.

• Module 04: Insert Records in Related Tables

We will be adding data to the new class and enrolment tables. The challenge with the relational database is once we start introducing relationships to the table, as you will learn.

• Module 05: Run Queries on Related Tables (Inner Joins)

This video covers running queries from multiple tables that are related or Inner Joins.

• Module 06: Left, Right and Cross-Joins

Understand how Left, Right and Cross-Joins work with this video tutorial.

• Module 01: Grouping Data using SQL GROUP BY Clause

Learn about the group-by statements available to us in MySQL. Group-bys allow us to eliminate repeating data and select distinct records from a table, as well as to conduct mathematical operations.

• Module 02: SQL AVG Aggregate Function

In this video, we will look at aggregate functions starting with the average function.

• Module 03: SQL COUNT Aggregate Function

We will look at two scenarios where the number of students per class or course will help us to accomplish the “count” function.

• Module 04: SQL MIN & MAX Aggregate Functions

In this scenario, we want to see the highest and lowest grades by course using the “Min” & “Max” functions.

• Module 05: SQL SUM Aggregate Function

For this scenario, we want to look at the total number of credits that each student is studying using the “Sum” function.

• Module 06: Splitting Groups using HAVING Clause

You are faced with a scenario where you want to see only students with a certain number of credits. This tutorial shows you how to sum up conditionally with the “having” clause.