MySQL Training - Classroom

Course timeline

1. Getting Started with MySQL

   Lesson 1

   • Setup MySQL database
   • Discuss data types that can be used
   • Leverage CREATE TABLE DDL for setting up a schema of tables
   • Using Primary Key and Foreign Key constraints
   • Insert, Update and Delete for DML operations
   • Alter and Drop existing tables
   • Adding and examining Constraints on tables

2. Deep Dive into SQL Statements

   Lesson 2

   • Select and Select Distinct for removing duplicates
   • Leverage Where statement to narrow resulting data set
   • Count and Limit for diagnosing and controlling resulting data set
   • Specify ordering of retrieved data by using ORDER BY
   • Leverage sub-queries with IN and BETWEEN

3. Analytical SQL queries

   Lesson 3

   • Getting statistics about data by using MIN MAX and AVG
   • leverage GROUP BY to aggregate data in a custom way
   • Conditional GROUP BY statements with HAVING clause

4. Joining Data from multiple data sets

   Lesson 4

   • Creating tables using primary key references
   • INNER JOIN for full joins
   • LEFT and RIGHT joins for joining data
   • Full Outer Join and Union

5. Advanced SQL language features

   Lesson 5

   • Perform advanced calculations with mathematical functions
   • Operations on String and Text columns
   • Leverage Self-Join when needed to join the table with itself

6. Using MySQL with web applications

   Lesson 6

   • MySQL Application with Node.js (Express)
   • MySQL Application with Python (Django)
   • MySQL Application with PHP (Laravel)

7. Using MySQL with web applications

   Lesson 7

   • Securing MySQL
   • Track Performance Problems with EXPLAIN
   • Use Indexing to improve the performance of search queries
   • Prepared Statements as a best MySQL query pattern
   • Performing Backups and using Logs
   • Decomposition of complex queries into simpler ones