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
  • Now using GoormIDE instead of Cloud9
  • GoormIDE 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