Week 21 and Week 22
Week 21
Monday
5
4
3
Solution Assessment
Efficient and Secure SQL Objectives
Extra
More
Intro to SQL Efficiency Quiz
Intro to N+1 Queries
Extra
More
Avoiding N+1 Queries
Extra
More
N+1 Queries Quiz
Intro to SQL Indexes
Extra
More
CREATE INDEX
Extra
More
SQL Indexes Quiz
Intro to SQL Injection
Extra
More
Avoiding SQL Injection Attacks
Extra
Extra
SQL Injection Quiz
Benchmark SQL Queries
Extra
More
Benchmark SQL Queries Quiz
Tuesday
ORM
Aggregates
N Plus
Sequelize Setup
Models
Constraints
Seeking
Practice: Improve SQL Queries
Solution
Cheat Sheet for SQLite3 CLI Commands
Extra
More
Intro to Sequelize Learning Objectives
Extra
What is an ORM?
Extra
More
Practices
Elements of Sequelize: Migrations, Models, Seeds
Extra
More
Intro to Sequelize Quiz
Initialize Sequelize in Express
Extra
More
Practice: Sequelize In Express
Solution
Why Migrations Are Important
Extra
More
CREATE TABLE Migration
Extra
More
Database Constraints
Extra
Up/Down Migrations
Extra
More
Practice: CREATE TABLE Migrations
Solution
Undoing and Rerunning Migrations
Extra
More
Migrations Quiz
Practice: Undoing Migrations
Solution
Wednesday
Rental Property Project
Javascript Objects Review
What are Sequelize Models?
Extra
More
Model Validations
Extra
More
Sequelize Models & Validations Quiz
Practice: Sequelize Models
Solution
What are Sequelize Seeders?
Extra
More
Up/Down Seeders
Extra
More
queryInterface.bulkInsert vs. Model.bulkCreate
Extra
More
Sequelize Seeders Quiz
Practice: Sequelize Seeders
Solutions
Sequelize Command Sheet (condensed)
Extra
More
When to add Constraints vs. Validations
Extra
More
Practice: Validations and Constraints
Solution
Practice: Research Add/Remove/Modify Columns Migrations
Solution
Quiz Instructions: Which Validation Should I Use?
Thorsday
Quiz: Which Validation Should I Use?
Long Practice: Sequelize Foundations
Solutions
Phase 1
Phase 2
Phase 3
Phase 4
Querying, Association, Migrations For Relationships Learning Objectives
Extra
More
SELECT Queries in Sequelize
Extra
More
Practice: Sequelize SELECT Queries
Solution
WHERE Clauses in Sequelize
Extra
More
INSERT Data in Sequelize
Extra
More
SELECT, INSERT in Sequelize Quiz
Practice: Sequelize INSERT Data
Solution
UPDATE Data in Sequelize
Extra
More
DELETE Data in Sequelize
Extra
More
UPDATE, DELETE in Sequelize (Quiz)
Practice: Sequelize UPDATE and DELETE Singular Records
Solution
Freyasday
Shopping Tutorial
Shopping App
Long Practice: Intermediate Sequelize
Solution
Postman Testing
Foreign Key Column Migrations
Extra
More
JOIN Table Migrations
Extra
More
Foreign Keys in Sequelize Quiz
Practice: Foreign Key Migrations
Solution
Intro to Associations
Extra
More
Defining Associations
Extra
More
Intro to Associations Quiz
Query with Associations
Extra
More
Lazy vs. Eager Loading
Extra
More
Query with Associations Quiz
Practice: Lazy/Eager Queries
Solution
Insert with Associations
Extra
More
Insert with Associations Quiz
Practice: Insert with Associations
Solutions
Dynamic Seeding
Extra
More
Dynamic Seeding Quiz
Practice: Dynamic Seeding
Solution
Week 22
Lundi
Bonus VS Code Tip
Bonus Git Basic Review
Bonus Git Advanced
Bonus Github
Bonus Git and Github
Github Actions
Order Query Results
Extra
More
Order Query Results Quiz
Practice: Order Query Results
Solution
Long Practice: Intermediate Sequelize
Solution
Efficient Sequelize Querying Learning Objectives
Sequelize in the Real World
Extra
More
Sequelize in the Real World Quiz
Aggregate Data
Extra
More
Aggregate Data Quiz
(OPTIONAL) ADVANCED Aggregates
Extra
More
Pagination
Extra
More
Search Filters
Extra
More
Pagination and Search Filters Quiz
Mardi
Bonus Big O
Bonus cURL Tutorial
Bonus Pair Programming
Practice: Aggregate Data
Solution
Bonus Practice: Eager Load Aggregates (ADVANCED)
Solution
Practice: Pagination
Solution
Long Practice: Intermediate Sequelize
Solution
Phase 1: Select Using Sequelize
Solution
Phase 2: Insert Using Sequelize
Solution
Phase 3: Delete Using Sequelize
Solution
Phase 4: Update Using Sequelize
Solution
Phase 5: Join Table Associations
Solution
Phase 6: Updating Foreign Keys References in Seed Data
Solution
Phase 7: Fetching Related Records Eager Lazy Loading
Solution
Bonus Phase 1: Select Where Like
Solution
Bonus Phase 2: Insect Routes
Solution
Bonus Phase 3: Crafting Routes Via API
Solution
Practice: Search Filters
Solution
Efficient Sequelize Querying Learning Objectives
Efficient Express-Sequelize API Endpoints
Extra
More
Efficient Querying in Sequelize Quiz
Mercredi
DOTENV Tutorial
Extra Sqlite and Sequilize
Express
Bonus Express Sequelize Fullstack Guide
Long Practice: Sequelize in the Real World
0
1
2
3
4
5
6
7
8
9
10
11
Preview Practice Assessment
Jeudi
Package Json Tutorial
Long Practice: Sequelize in the Real World
Solution
Intro
Ordering Query Results
Implement Pagination
Pagination with Aggregation
Implemneting Search Filters
Aggregation
Search Filters
Ordering by Association
Advanced Association Ordering
Advanced Aggregation
Aggregation Decisions
Pagination Middleware
Airplane Specs
Solution
Seeding
Solution
Warehouse
Solution
Sports Database
Vendredi
Practice Assessment 1
Practice Assessment 2
Practice Assessment 3
Practice Assessment 4
Interpreting and Debugging Test Results
Express and Sequelize - Practice Assessment (48 weeks)
Express and Sequelize - Assessment
Bonus Docker added
Phase 1
Phase 2
Phase 3
Phase 4