The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Introduction and 5 Minutes of SQL

Course Introduction

Instructor Introduction(s)

Syllabus Walkthrough and Prerequisites

Note about SQL Editor

Your First 5 Minutes of SQL - Let's Get Coding!

CODE: Your First 5 Minutes of SQL

How The Course Works

Getting Started: Overview and Installation

Section Introduction

What Is a Database?

SQL Vs. MySQL

Installation Overview - WATCH BEFORE INSTALLING

Cloud9 Registration IMPORTANT - PLEASE READ!!!

Mac Installation

CODE: Mac Installation

Windows Installation

Creating Databases and Tables

Section 3 Introduction

Creating Databases

CODE: Creating Databases

Dropping Databases

CODE: Dropping Databases

Using Databases

CODE: Using Databases

Introduction to Tables

The Basic Datatypes

Note about INT max size

Basic Datatypes Challenge

Basic Datatypes Challenge - Solution

Creating Your Own Tables

CODE: Creating Your Own Tables

How Do We Know It Worked?

CODE: How Do We Know It Worked?

Dropping Tables

CODE: Dropping Tables

Creating Your Own Tables Challenge

CODE: Creating Your Own Tables Challenge

Inserting Data (and a couple other things)

Section 4 Introduction

Inserting Data

CODE: Inserting Data

Super Quick Intro To SELECT

CODE: Super Quick Intro To SELECT

Multiple INSERT

CODE: Multiple Insert

INSERT Challenges

Note about using quotes inside of inserted values

INSERT Challenges Solution

CODE: INSERT Challenges Solution

NOTE: MySQL Warnings

MySQL Warnings

CODE: MySQL Warnings

NULL and NOT_NULL

CODE: NULL and NOT NULL

Setting Default Values

CODE: Setting Default Values

A Primer On Primary Keys

CODE: A Primer on Primary Keys

Table Constraints Exercise

Table Constraints Exercise Solution

CODE: Table Constraints Exercise Solution

CRUD commmands

Section 5 Introduction

Introduction to CRUD

CODE: Introduction to CRUD

Preparing Our Data

CODE: Preparing Our Data

Official Introduction to SELECT

CODE: Official Introduction to SELECT

Introduction to WHERE

CODE: Introduction to WHERE

SELECT Challenges

SELECT Challenges Solution

CODE: SELECT Challenges Solution

Introduction to Aliases

CODE: Introduction to Aliases

The UPDATE Command

CODE: The UPDATE Command

UPDATE Challenges

UPDATE Challenges Solution

CODE: UPDATE Challenges Solution

Introduction to DELETE

CODE: Introduction to DELETE

DELETE Challenges

DELETE Challenges Solution

CODE: DELETE Challenges Solution

CRUD Challenge Section

Section 6 Introduction

CRUD Exercise Overview

CRUD Exercise Create Solution

CODE: CRUD Exercise Create Solution

CRUD Exercise Read Solution

CODE: CRUD Exercise Read Solution

CRUD Exercise Update Solution

CODE: CRUD Exercise Update Solution

CRUD Exercise Delete Solution

CODE: CRUD Exercise Delete Solution

The World Of String Functions

Section 7 Introduction

Note about Running SQL Files

Running SQL Files

CODE: Running SQL Files

Loading Our Book Data

CODE: Loading Our Book Data

Working with CONCAT

CODE: Working With CONCAT

Introducing SUBSTRING

CODE: Introducing SUBSTRING

Introducing REPLACE

CODE: Introducing REPLACE

Using REVERSE

CODE: Using REVERSE

Working with CHAR LENGTH

CODE: Working with CHAR LENGTH

Changing Case with UPPER and LOWER

CODE: Changing Case with UPPER and LOWER

Note about string functions

String Function Challenges

String Function Challenges Solution

CODE: String Function Challenges Solution

Refining Our Selections

Section 8 Introduction

Seed Data: Adding A Couple New Books

CODE: Seed Data: Adding A Couple New Books

Using DISTINCT

CODE: Using DISTINCT

Sorting Data with ORDER BY

CODE: Sorting Data with ORDER BY

Using LIMIT

CODE: Using LIMIT

Better Searches with LIKE

CODE: Better Searches with LIKE

LIKE Part 2: More Wildcards

CODE: LIKE Part 2: More Wildcards

Refining Selections Exercises

Refining Selections Exercises Solution

CODE: Refining Selections Exercises Solution

The Magic of Aggregate Functions

Section 9 Introduction

The Count Function

CODE: The Count Function

The Joys of Group By

CODE: The Joys of Group By

Min and Max Basics

CODE: MIN and MAX Basics

SUBQUERIES - A Problem with Min and Max

CODE: A Problem with Min and Max

Using Min and Max with Group By

CODE: Using Min and Max with Group By

The Sum Function

CODE: The Sum Function

The Avg Function

CODE: The Avg Function

Aggregate Functions Challenges

Aggregate Functions Challenges Solution

CODE: Aggregate Functions Challenges Solution

Revisiting Data Types

Section 10 Introduction

CHAR and VARCHAR

Note about CHAR and VARCHAR

CODE: CHAR and VARCHAR

DECIMAL

CODE: DECIMAL

FLOAT and DOUBLE

CODE: FLOAT and DOUBLE

Note about setting the timezone in Cloud9

DATE, TIME, and DATETIME

Creating Our DATE data

CODE: Creating Our DATE data

CURDATE, CURTIME, and NOW

Note about formatting dates

Formatting Dates

CODE: Formatting Dates

Date Math

CODE: Date Math

Working with TIMESTAMPS

CODE: Working with TIMESTAMPS

Data Types Exercises

Data Types Exercises Solution

CODE: Data Types Exercises Solution

The Power of Logical Operators

Section 11 Introduction

Not Equal

CODE: Not Equal

Not Like

CODE: Not Like

Greater Than

CODE: Greater Than

Less Than

CODE: Less Than

Logical AND

CODE: Logical AND

Logical OR

CODE: Logical OR

Between

CODE: Between

In And Not In

CODE: In And Not In

Case Statements

CODE: Case Statements

Logical Operators Exercises

Logical Operators Exercises Solution

CODE: Logical Operators Exercises Solution

Section 12: One To Many

Section 12 Introduction

Real World Data Is Messy

Types of Data Relationships

One To Many: The Basics

Working With Foreign Keys

CODE: Working With Foreign Keys

Cross Join

CODE: Cross Joins

Inner Join

CODE: Inner Joins

Left Join

CODE: Left Joins

Right Joins Pt 1

CODE: Right Joins Part 1

Right Joins Pt 2

CODE: Right Joins Part 2

Right and Left Joins: A Common Question

CODE: Right and Left Joins FAQ

Our First Joins Exercise

Our First Joins Exercise SOLUTION

CODE: Our First Joins Exercise

Our First Joins Exercise SOLUTION PT. 2

CODE: Our First Joins Exercise SOLUTION PT. 2

Section 13: Many To Many

Section 13 Introduction

Many To Many Basics

Creating Our Tables

CODE: Creating Our Tables

TV Joins Challenge 1

CODE: TV Joins Challenge 1 Solution

TV Joins Challenge 2

CODE: TV Joins Challenge 2 SOLUTION

TV Joins Challenge 3

CODE: TV Joins Challenge 3 SOLUTION

TV Joins Challenge 4

CODE: TV Joins Challenge 4 SOLUTION

TV Joins Challenge 5

CODE: TV Joins Challenge 5 SOLUTION

TV Joins Challenge 6

CODE: TV Joins Challenge 6 SOLUTION

TV Joins Challenge 7

CODE: TV Joins Challenge 7 SOLUTION

Instagram Database Clone

Section 14 Introduction

Introduction To Instagram Clone Schema

Cloning Instagram's DB: Users Schema

CODE: IG Clone Users Schema

Cloning Instagram's DB: Photos Schema

CODE: IG Clone Photos Schema

Cloning Instagram's DB: Comments Schema

CODE: IG Clone Comments Schema

Cloning Instagram's DB: Likes Schema

CODE: IG Clone Likes Schema

Cloning Instagram's DB: Followers Schema

CODE: IG Clone Followers Schema

Note about: Cloning Instagram's DB: Hashtags Part 1

Cloning Instagram's DB: Hashtags Part 1

Cloning Instagram's DB: Hashtags Part 2

CODE: IG Clone Hashtags Schema

CODE: Complete IG Clone Schema

Working With Lots Of Instagram Data

Section 15 Introduction

Loading The JUMBO dataset

The Instagram Clone DATASET

Instagram Clone Challenge 1

Instagram Challenge 1 Solution CODE

Instagram Clone Challenge 2

Instagram Challenge 2 Solution CODE

Instagram Clone Challenge 3

Instagram Challenge 3 Solution CODE

Instagram Clone Challenge 4

Instagram Challenge 4 Solution CODE

Instagram Clone Challenge 5

Instagram Challenge 5 Solution CODE

Instagram Clone Challenge 6

Instagram Challenge 6 Solution CODE

Note about Instagram Clone Challenge 7

Instagram Clone Challenge 7

Instagram Challenge 7 Solution CODE

Section 16 - Introducing Node

Note about Introducing Node

Section 16 Introduction

MySQL and Other Languages

BUT WHAT ABOUT PHP

Introduction to JOIN US app

Note about Setting Up Cloud9 for Node

5 Minute NodeJS Crash Course

CODE: 5 Minute Node Crash Course

Note about Faker install

Introduction to NPM and Faker

CODE: Introduction to NPM and Faker

Introducing the MySQL Package

Note about connecting Node to MySQL

Connecting Node to MySQL

CODE: Connecting Node to MySQL

Creating Our Users Table

CODE: Creating Our Users Table

Selecting Using Node

CODE: Selecting Using Node

Inserting Using Node

CODE: Inserting Using Node

Some MySQL/Node Magic

Bulk Inserting 500 Users - Finally!

CODE: Bulk Inserting 500 Users

500 Users Exercises

500 Users Exercises Solutions

CODE: 500 Users Exercises Solutions

Section 17 - Building Our Web App

Section 17 Introduction

Join Us Completed CODE

Introducing Express

NPM Init and package.json files

Note about Our First Simple Web App

Our First Simple Web App

CODE: Our First Simple Web App

Adding Multiple Routes

CODE: Adding Multiple Routes

Connecting Express and MySQL

CODE: Connecting Express and MySQL

Adding EJS Templates

CODE: Adding EJS Templates

Connecting The Form

CODE: Connecting the Form

Styling Part 1

CODE: HTML AND CSS FILES

Styling Part 2

Section 18 - Database Triggers

Introduction to Database Triggers

Writing Our First Trigger Part 1

Writing Our First Trigger Part 2

Preventing Instagram Self-Follows With Triggers

Creating Logger Triggers

Managing Triggers And A Warning