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 ExpressBonus 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