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
• 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)