SQL Beginner to Guru MySQL Edition Introduction
- Getting the Most out of Your SQL Course
- Slack Group for SQL Beginner to Guru MySQL Edition
- SQL - Let's write our first SQL!
- SQL Fiddle Assignment Review
Introduction to SQL
- Introduction to SQL
- What is a Database?
- Relational Database Principles
- Assignment: Create Tables and Insert Data
- Assignment Review: Create Tables and Insert Data
- History of SQL
- What is a Relational Database Management System?
- History of MySQL
- RDBMS Deployment Architectures
- Flashcards
- Conclusion
Installation of MySQL
- Introduction
- Review of MySQL Installation Options
- MySQL Windows 10 Installation Quick Start
- MySQL Windows 10 Installation
- MySQL OSX Installation Quick Start
- MySQL OSX Installation
- MySQL Linux Installation Quick Start
- MySQL Linux Installation Ubuntu
- MySQL Linux Installation CentOS
Connecting to MySQL
- Introduction
- Connecting to MySQL Overview
- MySQL Command Line for OSX and Linux
- MySQL Command Line for Docker
- MySQL Workbench Windows Installation Quick Start
- MySQL Workbench OSX Installation Quick Start
- MySQL Workbench OSX Installation
- MySQL Workbench Linux Installation Quick Start
- MySQL Workbench Linux Installation
Selecting Data from a Single Table
- Introduction
- Importing the MySQL Employee Database
- Assignment use SQL to get Row Counts
- Quiz - SQL Row Counts
- Assignment Review - Use SQL to get Row Counts
- Review of the SQL Select Statement
- Selecting Specific Columns from Tables
- Using Aliases to Name Columns
- Using the SQL CONCAT Function to Join Columns
- SQL Arithmetic Operators
- Using SQL Arithmetic Operators in Selecting Data
- SQL Data Types
- Formatting Date Values with MySQL
- Using the LEFT and RIGHT MySQL Functions
- SQL Select Clause Quiz
- Introduction to the SQL WHERE Clause
- SQL WHERE Clause with Equals and Not Equals
- Using AND and OR with SQL WHERE Clause
- Using IN and NOT IN with with SQL WHERE Clause
- Dealing with NULL Values in SQL WHERE Clause
- Using Greater Than and Less Than with SQL WHERE Clause
- Using LIKE and NOT LIKE with SQL WHERE Clause
- Using BETWEEN and NOT BETWEEN with SQL WHERE Clause
- Ordering Results with SQL ORDER BY
- Limit Results with SQL LIMIT Clause
- Using SQL to Select DISTINCT Values
- Using SQL Sub-selects with IN in SQL Where Clause
- Assignment - Fix SQL Statements
- Assignment Review
- Conclusion
Grouping and Summarizing Data with SQL
- Introduction
- Using the SQL GROUP By clause
- MySQL Aggregate Functions
- Using the SQL HAVING Clause
- Using the SQL SUM Function
- Using the SQL Min and Max Functions
- Using the SQL AVG Function
- Assignment - Write SQL Report for Salary Information by Year Excluding Managers
- Salary Report Quiz
- Assignment Review
- Conclusion
Using SQL to Select Data from More Than One Table
- Introduction
- Overview of SQL Table Joins
- Introduction to SQL Inner Joins
- Using Table Aliases with SQL Inner Joins
- Limiting Columns Displayed with SQL Inner Joins
- Using a WHERE Clause with SQL Inner Joins
- Assignment - Create Department Employee Report
- Assignment Review - Create Department Employee Report
- Using SQL Natural Joins
- Using SQL Equi-Joins
- Using SQL Union Joins
- Other MySQL Functions
- Using SQL LEFT OUTER JOINS
- Assignment - Write SQL LEFT OUTER JOIN
- Assignment Review - Write SQL LEFT OUTER JOIN
- Conclusion
Using SQL to Insert Data
- Introduction
- Overview of the SQL Insert Statement
