Course Highlights
  • Learn the fundamentals relational databases and the Structured Query Language (SQL) using MySQL.
Skills you will learn!
Curriculum

4 Topics
SQL & Databases Course Overview
What is a Database?
MySQL vs. SQL
Video: What is a Database?

3 Topics
Installing MySQL
Installing and Connecting to MySQL Workbench
Video: Using MySQL Workbench

7 Topics
What is a Relational Database?
Link: Tutorial on Relational Database Design
Create a DB Schema + Tables
Let's Add Some Data!
Video: Creating a Simple Relational Database
Assignment: Create a Travel Company Database
Journal: Primary & Foreign Keys

3 Topics
Importing the Sakila Database
Video: Importing the Sakila Demo DB
Assignment: Import the Employees DB

35 Topics
SELECT
SELECT DISTINCT
Video: SQL SELECT + SQL SELECT DISTINCT
SELECT WHERE
AND / OR / NOT
Video: Filtering SQL Queries
ORDER BY
LIMIT
Video: SQL ORDER BY + SQL LIMIT
INSERT
CREATE TABLE SELECT
Adding Data to a Database
UPDATE
DELETE
Video: SQL Update + Delete
SQL JOINS
INNER JOIN
LEFT / RIGHT JOIN
Video: JOINS
UNION
Video: UNION
SUM / COUNT / AVG
MAX / MIN
Video: COUNT() SUM() AVG() MAX()
GROUP BY
Video: GROUP BY
LIKE + Wildcards
Video: LIKE + Wildcards
IN
BETWEEN
Video: IN + BETWEEN
ANY / ALL
Working with SQL Stored Procedures
Video: Stored Procedures
Journal: SQL Query Practice

7 Topics
Using MySQL from the CLI
Video: Using MySQL from the CLI
MySQL Database Backup & Restore: CLI
Video: MySQLdump & Restore from the CLI
MySQL Database Backup & Restore: MySQL Workbench
Video: Intro to AWS RDS
Journal: Import + Export from MySQL

2 Topics
Quiz: SQL & Databases
Request Completion Certificate

  Write a Review

SQL & Databases (MySQL)

Go to Paid Course