SQL Beginner to Guru: MySQL Edition – Master SQL with MySQL

Course Curriculum

Chapter 1: SQL Beginner to Guru MySQL Edition Introduction

Lecture 1: Getting the Most out of Your SQL Course

Lecture 2: Slack Group for SQL Beginner to Guru MySQL Edition

Lecture 3: GitHub Workflow

Lecture 4: SQL – Let's write our first SQL!

Lecture 5: SQL Fiddle Assignment Review

Chapter 2: Introduction to SQL

Lecture 1: Introduction to SQL

Lecture 2: What is a Database?

Lecture 3: Relational Database Principles

Lecture 4: Assignment: Create Tables and Insert Data

Lecture 5: Assignment Review: Create Tables and Insert Data

Lecture 6: History of SQL

Lecture 7: What is a Relational Database Management System?

Lecture 8: History of MySQL

Lecture 9: RDBMS Deployment Architectures

Lecture 10: Flashcards

Lecture 11: Conclusion

Chapter 3: Installation of MySQL

Lecture 1: Introduction

Lecture 2: Review of MySQL Installation Options

Lecture 3: MySQL Windows 10 Installation Quick Start

Lecture 4: MySQL Windows 10 Installation

Lecture 5: MySQL OSX Installation Quick Start

Lecture 6: MySQL OSX Installation

Lecture 7: MySQL Linux Installation Quick Start

Lecture 8: MySQL Linux Installation Ubuntu

Lecture 9: MySQL Linux Installation CentOS

Chapter 4: Connecting to MySQL

Lecture 1: Introduction

Lecture 2: Connecting to MySQL Overview

Lecture 3: MySQL Command Line for OSX and Linux

Lecture 4: MySQL Command Line for Docker

Lecture 5: MySQL Workbench Windows Installation Quick Start

Lecture 6: MySQL Workbench OSX Installation Quick Start

Lecture 7: MySQL Workbench OSX Installation

Lecture 8: MySQL Workbench Linux Installation Quick Start

Lecture 9: MySQL Workbench Linux Installation

Chapter 5: Selecting Data from a Single Table

Lecture 1: Introduction

Lecture 2: Importing the MySQL Employee Database

Lecture 3: Assignment use SQL to get Row Counts

Lecture 4: Assignment Review – Use SQL to get Row Counts

Lecture 5: Review of the SQL Select Statement

Lecture 6: Selecting Specific Columns from Tables

Lecture 7: Using Aliases to Name Columns

Lecture 8: Using the SQL CONCAT Function to Join Columns

Lecture 9: SQL Arithmetic Operators

Lecture 10: Using SQL Arithmetic Operators in Selecting Data

Lecture 11: SQL Data Types

Lecture 12: Formatting Date Values with MySQL

Lecture 13: Using the LEFT and RIGHT MySQL Functions

Lecture 14: Introduction to the SQL WHERE Clause

Lecture 15: SQL WHERE Clause with Equals and Not Equals

Lecture 16: Using AND and OR with SQL WHERE Clause

Lecture 17: Using IN and NOT IN with with SQL WHERE Clause

Lecture 18: Dealing with NULL Values in SQL WHERE Clause

Lecture 19: Using Greater Than and Less Than with SQL WHERE Clause

Lecture 20: Using LIKE and NOT LIKE with SQL WHERE Clause

Lecture 21: Using BETWEEN and NOT BETWEEN with SQL WHERE Clause

Lecture 22: Ordering Results with SQL ORDER BY

Lecture 23: Limit Results with SQL LIMIT Clause

Lecture 24: Using SQL to Select DISTINCT Values

Lecture 25: Using SQL Sub-selects with IN in SQL Where Clause

Lecture 26: Assignment – Fix SQL Statements

Lecture 27: Assignment Review

Lecture 28: Conclusion

Chapter 6: Grouping and Summarizing Data with SQL

Lecture 1: Introduction

Lecture 2: Using the SQL GROUP By clause

Lecture 3: MySQL Aggregate Functions

Lecture 4: Using the SQL HAVING Clause

Lecture 5: Using the SQL SUM Function

Lecture 6: Using the SQL Min and Max Functions

Lecture 7: Using the SQL AVG Function

Lecture 8: Assignment – Write SQL Report for Salary Information by Year Excluding Managers

Lecture 9: Assignment Review

Lecture 10: Conclusion

Chapter 7: Using SQL to Select Data from More Than One Table

Lecture 1: Introduction

Lecture 2: Overview of SQL Table Joins

Lecture 3: Introduction to SQL Inner Joins

Lecture 4: Using Table Aliases with SQL Inner Joins

Lecture 5: Limiting Columns Displayed with SQL Inner Joins

Lecture 6: Using a WHERE Clause with SQL Inner Joins

Lecture 7: Assignment – Create Department Employee Report

Lecture 8: Assignment Review – Create Department Employee Report

Lecture 9: Using SQL Natural Joins

Lecture 10: Using SQL Equi-Joins

Lecture 11: Using SQL Union Joins

Lecture 12: Other MySQL Functions

Lecture 13: Using SQL LEFT OUTER JOINS

Lecture 14: Assignment – Write SQL LEFT OUTER JOIN

Lecture 15: Assignment Review – Write SQL LEFT OUTER JOIN

Lecture 16: Conclusion

Chapter 8: Using SQL to Insert Data

Lecture 1: Introduction