Syllabus Walkthrough and Prerequisites | StackSkills

Autoplay
Autocomplete

Previous Lesson Complete and Continue

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Introduction and 5 Minutes of SQL

Course Introduction (1:08)
Instructor Introduction(s) (1:25)
Syllabus Walkthrough and Prerequisites (4:18)
Your First 5 Minutes of SQL - Let's Get Coding! (6:13)
CODE: Your First 5 Minutes of SQL
How The Course Works (3:44)

Getting Started: Overview and Installation

Section Introduction (1:02)
What Is a Database? (7:16)
SQL Vs. MySQL (5:50)
Installation Overview - WATCH BEFORE INSTALLING (5:10)
Setting Up Cloud9 (4:47)
Cloud9 What If I Dont Have a Credit Card
Exploring The Cloud9 Interface (5:51)
Cloud9 Interface Challenge (2:42)
Installing MySQL on Cloud9 (8:35)
CODE: Installing MySQL on Cloud9
Your First MySQL Activity (3:58)
CODE: Your First MySQL Activity
Mac Installation (11:41)
CODE: Mac Installation
Windows Installation (3:32)

Creating Databases and Tables

Section 3 Introduction (1:09)
Creating Databases (5:20)
CODE: Creating Databases
Dropping Databases (1:46)
CODE: Dropping Databases
Using Databases (3:00)
CODE: Using Databases
Introduction to Tables (5:09)
The Basic Datatypes (7:52)
Basic Datatypes Challenge (2:35)
Basic Datatypes Challenge - Solution
Creating Your Own Tables (3:06)
CODE: Creating Your Own Tables
How Do We Know It Worked? (2:33)
CODE: How Do We Know It Worked?
Dropping Tables (1:36)
CODE: Dropping Tables
Creating Your Own Tables Challenge (4:29)
CODE: Creating Your Own Tables Challenge

Inserting Data (and a couple other things)

Section 4 Introduction (1:40)
Inserting Data (5:03)
CODE: Inserting Data
Super Quick Intro To SELECT (2:07)
CODE: Super Quick Intro To SELECT
Multiple INSERT (3:00)
CODE: Multiple Insert
INSERT Challenges (1:35)
INSERT Challenges Solution (4:43)
CODE: INSERT Challenges Solution
MySQL Warnings (5:35)
CODE: MySQL Warnings
NULL and NOT_NULL (6:54)
CODE: NULL and NOT NULL
Setting Default Values (7:17)
CODE: Setting Default Values
A Primer On Primary Keys (12:21)
CODE: A Primer on Primary Keys
Table Constraints Exercise (1:51)
Table Constraints Exercise Solution (3:34)
CODE: Table Constraints Exercise Solution

CRUD commmands

Section 5 Introduction (1:30)
Introduction to CRUD (1:44)
CODE: Introduction to CRUD
Preparing Our Data (2:29)
CODE: Preparing Our Data
Official Introduction to SELECT (4:18)
CODE: Official Introduction to SELECT
Introduction to WHERE (5:04)
CODE: Introduction to WHERE
SELECT Challenges (2:00)
SELECT Challenges Solution (2:45)
CODE: SELECT Challenges Solution
Introduction to Aliases (2:55)
CODE: Introduction to Aliases
The UPDATE Command (3:58)
CODE: The UPDATE Command
UPDATE Challenges (0:37)
UPDATE Challenges Solution (3:58)
CODE: UPDATE Challenges Solution
Introduction to DELETE (4:41)
CODE: Introduction to DELETE
DELETE Challenges (1:10)
DELETE Challenges Solution (2:45)
CODE: DELETE Challenges Solution

CRUD Challenge Section

Section 6 Introduction (1:52)
CRUD Exercise Overview (7:26)
CRUD Exercise Create Solution (5:55)
CODE: CRUD Exercise Create Solution
CRUD Exercise Read Solution (1:48)
CODE: CRUD Exercise Read Solution
CRUD Exercise Update Solution (4:10)
CODE: CRUD Exercise Update Solution
CRUD Exercise Delete Solution (3:21)
CODE: CRUD Exercise Delete Solution

The World Of String Functions

Section 7 Introduction (2:04)
Running SQL Files (10:15)
CODE: Running SQL Files
Loading Our Book Data (5:25)
CODE: Loading Our Book Data
Working with CONCAT (11:07)
CODE: Working With CONCAT
Introducing SUBSTRING (10:04)
CODE: Introducing SUBSTRING
Introducing REPLACE (6:39)
CODE: Introducing REPLACE
Using REVERSE (3:39)
CODE: Using REVERSE
Working with CHAR LENGTH (4:54)
CODE: Working with CHAR LENGTH
Changing Case with UPPER and LOWER (3:20)
CODE: Changing Case with UPPER and LOWER
String Function Challenges (4:42)
String Function Challenges Solution (13:08)
CODE: String Function Challenges Solution

Refining Our Selections

Section 8 Introduction (0:35)
Seed Data: Adding A Couple New Books (2:47)
CODE: Seed Data: Adding A Couple New Books
Using DISTINCT (8:24)
CODE: Using DISTINCT
Sorting Data with ORDER BY (11:19)
CODE: Sorting Data with ORDER BY
Using LIMIT (9:03)
CODE: Using LIMIT
Better Searches with LIKE (7:42)
CODE: Better Searches with LIKE
LIKE Part 2: More Wildcards (6:09)
CODE: LIKE Part 2: More Wildcards
Refining Selections Exercises (4:52)
Refining Selections Exercises Solution (12:29)
CODE: Refining Selections Exercises Solution

The Magic of Aggregate Functions

Section 9 Introduction (3:56)
The Count Function (8:38)
CODE: The Count Function
The Joys of Group By (12:22)
CODE: The Joys of Group By
Min and Max Basics (4:12)
CODE: MIN and MAX Basics
SUBQUERIES - A Problem with Min and Max (7:14)
CODE: A Problem with Min and Max
Using Min and Max with Group By (6:39)
CODE: Using Min and Max with Group By
The Sum Function (4:27)
CODE: The Sum Function
The Avg Function (6:00)
CODE: The Avg Function
Aggregate Functions Challenges (4:27)
Aggregate Functions Challenges Solution (9:10)
CODE: Aggregate Functions Challenges Solution

Revisiting Data Types

Section 10 Introduction (1:56)
CHAR and VARCHAR (14:29)
Note about CHAR and VARCHAR
CODE: CHAR and VARCHAR
DECIMAL (6:07)
CODE: DECIMAL
FLOAT and DOUBLE (7:44)
CODE: FLOAT and DOUBLE
DATE, TIME, and DATETIME (4:31)
Creating Our DATE data (5:49)
CODE: Creating Our DATE data
CURDATE, CURTIME, and NOW (5:15)
Formatting Dates (14:29)
CODE: Formatting Dates
Date Math (9:40)
CODE: Date Math
Working with TIMESTAMPS (10:54)
CODE: Working with TIMESTAMPS
Data Types Exercises (4:50)
Data Types Exercises Solution (13:58)
CODE: Data Types Exercises Solution

The Power of Logical Operators

Section 11 Introduction (2:44)
Not Equal (4:26)
CODE: Not Equal
Not Like (2:34)
CODE: Not Like
Greater Than (10:04)
CODE: Greater Than
Less Than (3:48)
CODE: Less Than
Logical AND (9:47)
CODE: Logical AND
Logical OR (6:41)
CODE: Logical OR
Between (10:57)
CODE: Between
In And Not In (11:47)
CODE: In And Not In
Case Statements (11:20)
CODE: Case Statements
Logical Operators Exercises (6:45)
Logical Operators Exercises Solution (17:46)
CODE: Logical Operators Exercises Solution

Section 12 One To Many

Section 12 Introduction (1:57)
Real World Data Is Messy (10:28)
Types of Data Relationships (4:36)
One To Many: The Basics (12:33)
Working With Foreign Keys (12:04)
CODE: Working With Foreign Keys
Cross Join (7:36)
CODE: Cross Joins
Inner Join (12:44)
CODE: Inner Joins
Left Join (15:17)
CODE: Left Joins
Right Joins Pt 1 (10:36)
CODE: Right Joins Part 1
Right Joins Pt 2 (9:51)
CODE: Right Joins Part 2
Right and Left Joins: A Common Question (3:09)
CODE: Right and Left Joins FAQ
Our First Joins Exercise (6:58)
Our First Joins Exercise SOLUTION (9:10)
CODE: Our First Joins Exercise
Our First Joins Exercise SOLUTION PT. 2 (9:21)
CODE: Our First Joins Exercise SOLUTION PT. 2

Section 13 Many To Many

Section 13 Introduction (1:54)
Many To Many Basics (10:48)
Creating Our Tables (10:57)
CODE: Creating Our Tables
TV Joins Challenge 1 (4:49)
CODE: TV Joins Challenge 1 Solution
TV Joins Challenge 2 (6:22)
CODE: TV Joins Challenge 2 SOLUTION
TV Joins Challenge 3 (4:59)
CODE: TV Joins Challenge 3 SOLUTION
TV Joins Challenge 4 (5:59)
CODE: TV Joins Challenge 4 SOLUTION
TV Joins Challenge 5 (4:56)
CODE: TV Joins Challenge 5 SOLUTION
TV Joins Challenge 6 (11:57)
CODE: TV Joins Challenge 6 SOLUTION
TV Joins Challenge 7 (7:08)
CODE: TV Joins Challenge 7 SOLUTION

Instagram Database Clone

Section 14 Introduction (1:19)
Introduction To Instagram Clone Schema (8:31)
Cloning Instagram's DB: Users Schema (6:08)
CODE: IG Clone Users Schema
Cloning Instagram's DB: Photos Schema (6:37)
CODE: IG Clone Photos Schema
Cloning Instagram's DB: Comments Schema (6:39)
CODE: IG Clone Comments Schema
Cloning Instagram's DB: Likes Schema (7:41)
CODE: IG Clone Likes Schema
Cloning Instagram's DB: Followers Schema (7:20)
CODE: IG Clone Followers Schema
Cloning Instagram's DB: Hashtags Part 1 (10:34)
Cloning Instagram's DB: Hashtags Part 2 (5:25)
CODE: IG Clone Hashtags Schema
CODE: Complete IG Clone Schema

Working With Lots Of Instagram Data

Section 15 Introduction (1:41)
Loading The JUMBO dataset (8:30)
The Instagram Clone DATASET
Instagram Clone Challenge 1 (4:52)
Instagram Challenge 1 Solution CODE
Instagram Clone Challenge 2 (6:41)
Instagram Challenge 2 Solution CODE
Instagram Clone Challenge 3 (7:22)
Instagram Challenge 3 Solution CODE
Instagram Clone Challenge 4 (7:05)
Instagram Challenge 4 Solution CODE
Instagram Clone Challenge 5 (3:13)
Instagram Challenge 5 Solution CODE
Instagram Clone Challenge 6 (5:29)
Instagram Challenge 6 Solution CODE
Instagram Clone Challenge 7 (5:14)
Instagram Challenge 7 Solution CODE

Section 16 - Introducing Node

Section 16 Introduction (1:36)
MySQL and Other Languages (8:59)
BUT WHAT ABOUT PHP (7:34)
Introduction to JOIN US app (8:00)
Setting Up Cloud9 for Node (6:30)
5 Minute NodeJS Crash Course (6:12)
CODE: 5 Minute Node Crash Course
Introduction to NPM and Faker (9:11)
CODE: Introduction to NPM and Faker
Introducing the MySQL Package (4:53)
Connecting Node to MySQL (12:46)
CODE: Connecting Node to MySQL
Creating Our Users Table (6:54)
CODE: Creating Our Users Table
Selecting Using Node (6:15)
CODE: Selecting Using Node
Inserting Using Node (11:31)
CODE: Inserting Using Node
Some MySQL/Node Magic (7:41)
Bulk Inserting 500 Users - Finally! (8:40)
CODE: Bulk Inserting 500 Users
500 Users Exercises (2:30)
500 Users Exercises Solutions (11:55)
CODE: 500 Users Exercises Solutions

Section 17 - Building Our Web App

Section 17 Introduction (1:52)
Join Us Completed CODE
Introducing Express (5:40)
NPM Init and package.json files (6:38)
Our First Simple Web App (16:33)
CODE: Our First Simple Web App
Adding Multiple Routes (9:56)
CODE: Adding Multiple Routes
Connecting Express and MySQL (11:08)
CODE: Connecting Express and MySQL
Adding EJS Templates (16:02)
CODE: Adding EJS Templates
Connecting The Form (18:32)
CODE: Connecting the Form
Styling Part 1 (8:24)
CODE: HTML AND CSS FILES
Styling Part 2 (8:16)

Section 18 - Database Triggers

Introduction to Database Triggers (6:10)
Writing Our First Trigger Part 1 (7:27)
Writing Our First Trigger Part 2 (11:36)
Preventing Instagram Self-Follows With Triggers (8:16)
Creating Logger Triggers (10:17)
Managing Triggers And A Warning (6:12)

Syllabus Walkthrough and Prerequisites

Complete and Continue