1

MySQL – Introducing databases

2

MySQL – Exploring MySQL

3

MySQL – Organizing data in a relational format

4

MySQL – Exploring MySQL architecture

5

MySQL – Storage engines (InnoDB and MyRocks)

6

MySQL – Data modeling

7

MySQL – Normalization

8

MySQL – Creating an optimized table for an employee project

1

MySQL – The MySQL Workbench GUI

2

MySQL – Accessing MySQL through the command-line interface

3

MySQL – Creating a database

4

MySQL – Using Workbench to add a table

5

MySQL – MySQL table indexes and foreign keys

6

MySQL – Reverse engineering a database

7

MySQL – Modifying the EER diagram, the model, and the database

1

MySQL – Working with data

2

MySQL – Backing up databases

3

MySQL – Restoring databases

4

MySQL – Working with SQL code to maintain a database

5

MySQL – Creating a new database

6

MySQL – Creating and modifying tables

7

MySQL – SQL queries to create indexes and foreign keys

8

MySQL – Creating a table with indexes and foreign keys

9

MySQL – Altering table queries

10

MySQL – Adding data to a table

11

MySQL – Updating data in a record

12

MySQL – Deleting data from tables

13

MySQL – Blobs, files, and file paths

14

MySQL – Adding image file paths to the database

1

MySQL – Querying tables in MySQL

2

MySQL – Filtering results

3

MySQL – Using functions on data

4

MySQL – Aggregating data

5

MySQL – Case statements

1

MySQL – Joining two tables

2

MySQL – Analyzing subqueries

3

MySQL – Common table expressions

4

MySQL – Analyzing query performance with EXPLAIN

5

MySQL – The Sakila video store (Activity)

6

MySQL – Generating a list of years (Activity)

1

MySQL – Exploring various database objects

2

MySQL – Working with views

3

MySQL – Updating the data in a view (Activity)

4

MySQL – Working with user-defined functions

5

MySQL – Working with stored procedures

6

MySQL – Working with IN, OUT, and INOUT

7

MySQL – Exploring triggers

8

MySQL – Using transactions

1

MySQL – Best practices for SQL client development

2

MySQL – JavaScript using Node.js

3

MySQL – Connecting to MySQL

4

MySQL – Building a database application with Node.js (Activity)

1

MySQL – Inserting records in Node.js

2

MySQL – Updating the records of a table

3

MySQL – Multiple updates (Activity)

4

MySQL – Displaying data in browsers

5

MySQL – ODBC connections

6

MySQL – Designing a customer database (Activity)

1

MySQL – MS Access database application configurations

2

MySQL – Upsizing an MS Access database to MySQL

3

MySQL – Manually exporting MS Access tables

4

MySQL – Adjusting field properties

5

MySQL – Migrating with wizards

6

MySQL – Linking to your tables and views

7

MySQL – Refreshing linked MySQL tables

8

MySQL – Linking the remaining MySQL tables to your MS Access database (Activity)

1

MySQL – Migrating an MS Access application to MySQL

2

MySQL – Converting gender and job statistics (Activity)

3

MySQL – Calling MySQL functions

4

MySQL – Creating a function and calling it (Activity)

5

MySQL – Calling MySQL stored procedures

6

MySQL – Creating MySQL stored procedures and using them in VBA (Activity)

7

MySQL – Using parameters

8

MySQL – Parameterized stored procedure (series list) – Activity

9

MySQL – Multiple parameters stored procedure (date list) – Activity

10

MySQL – The Bad Bits form

1

MySQL – Introduction to Excel

2

MySQL – Exploring the ODBC connection

3

MySQL – Exploring the Excel VBA structure

4

MySQL – Learning about VBA libraries

5

MySQL – Connecting to the MySQL database using VBA

6

MySQL – Reading data from MySQL using VBA

7

MySQL – Populating charts

8

MySQL – Creating a chart (artist track sales) (Actiity)

1

MySQL – Connecting to the MySQL database using ODBC

2

MySQL – Exploring generic data read functions

3

MySQL – Creating connections to MySQL in Excel

4

MySQL – Inserting data using MySQL for Excel

5

MySQL – Updating data using MySQL for Excel

6

MySQL – Pushing data from Excel

7

MySQL – Pivot tables

8

MySQL – Building a MySQL-based Excel document (Activity)

1

MySQL – Working with the X DevAPI

2

MySQL – Inserting documents

3

MySQL – Loading data from a SQL file

4

MySQL – Loading data from a CSV file

5

MySQL – Loading data from a JSON file

6

MySQL – Using the CSV storage engine to export data

7

MySQL – Using the CSV storage engine to import data

8

MySQL – Searching and filtering JSON documents

9

MySQL – Using JSON functions and operators to query JSON columns

10

MySQL – Using generated columns to query and index JSON data

11

MySQL – Exporting report data to CSV for Excel (Activity)

1

MySQL – Exploring users and accounts

2

MySQL – Creating users and granting permissions (Exercise)

3

MySQL – Changing users

4

MySQL – Flush privileges

5

MySQL – Changing permissions

6

MySQL – Using roles

7

MySQL – Troubleshooting access problems

8

MySQL – Creating users for managing the world schema (Activity)

1

MySQL – Understanding the basics of backups

2

MySQL – Logical and physical backup

3

MySQL – Types of restore

4

MySQL – Scheduling backups

5

MySQL – Using point-in-time recovery with binlog files

6

MySQL – Backing up and restoring a single schema (Acivity)

7

MySQL – Performing a point-in-time restore (Activity)