Week 19 and Week 20 - Intro to SQL, Sequelize, and Express
Week 19
Monday
Variable Declaration Guide
Variable Performance Guide
WSL 2 and Ubuntu - Windows
Extra
More
Extra Ubuntu CLI Guide
Server Review
Extra
More
Server Review Quiz
RESTful API Routes (Review) Tips & Tricks: Video
Extra REST API Guide
Postman (Review) Demo: Video
Practice: Postman (Review)
Solution
Express Basics Learning Objectives
Extra
More
What is Express?
Extra
More
What is Express? Quiz
Intro to Express
Extra
More
Intro to Express Quiz
Intro to Express Code Demo: Video
nodemon (Review) Tips & Tricks: Video
Extra Nodemon Guide
Practice: Initialize an Express Application
Solution
Express Route Handlers
Extra
More
Express Route Handlers Quiz
Express Route Handlers Code Demo: Video
Practice: Express Route Handlers
Solution
HTTP Server vs. Express Server
Extra
More
HTTP Server vs. Express Server Code Demo: Video
HTTP Server vs. Express Server Quiz
Practice: HTTP Server to Express Server
Solution
Route Order Matters!
Extra
More
Route Order Matters! Quiz
Practice: Route Order Matters
Solution
Express Request/Response Objects
Enhanced
More
Express Request/Response Objects Code Demo: Video
Express Request/Response Objects Quiz
Practice: Express Request/Response Objects
Solution
NPM Scripts Guide
Tuesday
Express Middleware and Router Learning Objectives
Extra
More
Express Middleware
Extra
More
Express Middleware Quiz
Curl Guide
Curl Short Tutorial
Practice: Predict Order of Express Middleware
Solution
Error-Handling Middleware
Extra
More
Error-Handling Middleware Quiz
Express Middleware Flow Diagram
Extra
More
Bonus
Express Middleware Flow Diagram Quiz
Wednesday
Practice: Error-Handling Middleware
Solution
Long Practice: Express Route Handlers
Solution
Defining an Express Router
Extra
More
Defining an Express Router Quiz
Connecting an Express Router
Extra
More
Connecting an Express Router Quiz
Express Environment Variables Learning Objectives
What are Environment Variables?
Extra
More
What are Environment Variables? Quiz
Load Env Variables for Node.js Apps
Extra
More
Load Env Variables for Node.js Apps Quiz
Thursday
Practice: Environment Variables
Solution
Practice: Express Route
Solution
Long Practice: Express Route Handlers
Solution
Advanced Error Handling in Asynchronous Middleware
Extra
More
li>
Advanced Asynchronous Error Handling With Promise API
Extra
More
Advanced Error Handling in Asynchronous Middleware Quiz
Error Handling in Asynchronous Middleware Code Demo: Video
Advanced Practice: Express Asynchronous Error Handling
Solution
Friday
Extra Markdown Tutorial
Advanced Git
Long Practice: Express Project Prep: Video
Long Practice: Express Middlewares
Solution
Intro to Databases and SQL Learning Objectives
Extra
More
Intro to Databases
Extra
More
Intro to Databases Quiz
Database Table Schemas
Extra
More
Database Table Schemas Quiz
Designing and Visualizing Database Tables
Extra
More
Designing and Visualizing Database Tables Quiz
Exercise: SQL Database Tables Visualizer
Solution
Database Connections
Extra
More
Database Connections Quiz
SQLite3 CLI
Extra
More
SQLite3 CLI Quiz
Exercise: SQLite3 CLI
Solution
CREATE/DROP Tables
Extra
More
CREATE/DROP Tables Quiz
Practice: CREATE/DROP Tables
Solution
INSERT Data
Extra
More
INSERT Data Quiz
Practice: INSERT Data
Solution
SELECT Data
Extra
More
SELECT Data Quiz
Practice: SELECT Data
Solution
DELETE Data
Extra
More
DELETE Data Quiz
Extra
More
Practice: DELETE Data
Solution
UPDATE Data
Extra
More
UPDATE Data Quiz
Practice: UPDATE Data
Solution
Week 20
Monday
Run SQL In A File
Extra
More
Run SQL In A File Quiz
Practice: Reading .sql Files
Solution
Long Practice: Basic SQL
Solution
SQL and Express
Extra
More
SQL and Express Quiz
Practice: Combining SQL and Express
Solution
Tuesday
Long Practice: Basic SQL
Solution
Long Practice: America's Largest Trees
Solution
Intermediate SQL Learning Objectives
Extra
More
Intro to Relationships in Databases
Extra
More
Intro to Relationships in Databases Quiz
One-to-Many Relationships
Extra
More
One-to-Many Relationships Quiz
Many-to-Many Relationships
Extra
More
Many-to-Many Relationships Quiz
Many-to-Many Database Design
Extra
More
Many-to-Many Database Design Quiz
Relational Database Design Stages
Extra
More
Normalization
Advanced Normalization
Relational Database Design Stages Quiz
Visualizing Relational Database Schemas
Extra
More
Visualizing Relational Database Schemas Quiz
Wednesday
Practice: Visualizing Relational Database Schemas
Solution
dbdiagram Tutorial
CREATE Related Tables
Extra
More
CREATE Related Tables Quiz
Practice: CREATE Related Tables
Solution
Delete dependent data with DELETE CASCADE
Extra
More
Delete dependent data with DELETE CASCADE Quiz
Practice: DELETE CASCADE
Solution
WHERE, LIMIT, ORDER BY, OFFSET
Extra
More
WHERE, LIMIT, ORDER BY, OFFSET Quiz
SQL Operators
Extra
More
SQL Operators Quiz
Practice: Intermediate Querying
Solution
Combine Tables Using JOIN
Extra
More
Combine Tables Using JOIN Quiz
Practice: Query Using JOIN One-to-Many
Solution
Practice: Query Using JOIN Many-to-Many
solution
Thursday
Long Practice: Intermediate SQL
Solution
Advanced SQL Learning Objectives
Extra
More
SQL Aggregates
Extra
More
SQL Aggregates Quiz
SQL Subqueries
Extra
More
SQL Subqueries Quiz
Friday
Practice Assessment Solution
Practice: SQL Aggregates
Solution
Practice: SQL Subqueries
Solution
Basic SQL Zoo Practice Problems
Solution
Intermediate SQL Zoo Practice Problems
Solution
Long Practice: SQL Island
Solution
Long Practice: SQL Murder Mystery
Solution
External Practice: SQL
Solution
Long Practice: Advanced SQL
Solution
Advanced SQL Zoo Practice Problems
Solution
Express and SQL - Practice Assessment (48 weeks)