WEEK2.md

Week 2: Express, Async/Await, Databases (PostgreSQL), ORMs (Sequelize)

⬅ Go Back

Day 1: Express, Intro to DB and SQL

• Pre-Work:
  • 📺 Web Dev Simplified: What is an API?
  • 📺 Codecademy: Back-End Web Architecture
  • 📤 Download an API development tool (your choice) 📥
    • Postman
    • Insomnia
  • 📖 Schema Design Overview

Topic	Lecture	Slides	Demo	Solution	Review
Express 201 (Wizard News Pt 1)	📺	🖼️	🧑‍💻
Intro to Databases & PostgreSQL	📺	🖼️	-	-	-
Intro to SQL	📺	🖼️		-	-
Morning Review		🎟			-

• You should be able to:
  • Describe the role of a client, a server, and HTTP
  • Describe Express middleware, requests, and responses
  • Handle URL params in an Express route
  • Know when and why you would use app.use and next in your Express app
  • Use module.exports and require to create modular applications
  • Handle asynchronous code and Promises with async/await

📎 Extra Resources EXPRESS :

• 📖 A Simple Explanation of Express Middleware
• 📖 Nodejs in Flames

• You should be able to:
  • Explain what a database is, and why you would use one
  • Write SQL queries using some common keywords (SELECT, FROM, WHERE, ORDER BY, JOIN, etc)
  • Articulate what a primary key is
  • Articulate what a foreign key is, and why you would use one
  • Explain the differences between a 1-to-1, 1-to-many, and many-to-many relationship

📎 Extra Resources SQL:

• Normalization
• SQL-Relationships
• SQLzoo
• SQL vs NoSQL
• 📖 SQL W3schools
• 📖 What is a RDBMS anyway?

Day 2: Node-Postgres (pg), Express Router()

• Pre-Work:
  • node-postgres (Sections: "Welcome" and "Queries")

Topic	Lecture	Slides	Demo	Solution	Review
Node-Postgres (pg) (Wizard News Pt 2)	📺	🖼️	🧑‍💻
RESTful Routing (Wizard News Pt 3)	📺	🖼️		👾
Morning Review		🎟	-	-	-

• You should be able to:
  • Describe the role of pg in our stack
  • Define REST and its advantages
  • Create and mount Express Routers
  • Explain the role of body parsing middleware

📎 Extra Resources:

• PostgreSQL
  • Documentation
  • Tutorial
• node-postgres (pg)
  • Features: Connecting
  • Features: Queries
  • API: pg.Client
• Express & RESTful Routing
  • Gist: REST Anti-Patterns and Mistakes
  • RESTful API Resource Naming Convention
  • Express has reincorporated body parsing starting with v4.16:
    • Stackoverflow: express.json vs bodyParser.json
  • How bodyParser() works

Day 3: ORM (Sequelize), WikiStack 1

• Pre-Work:
  • Sequelize An Introduction

Topic	Lecture	Slides	Demo	Solution	Review
Morning Review	📺	-	-	-	-
Intro to ORMs (Sequelize)	📺	🖼️	🧑‍💻		-
Wikistack 1	-	-	-	👾
Morning Review		🎟	-	-	-

• You should be able to:
  • Define an ORM, and explain its pros/cons
  • Define models in Sequelize
  • Associate models with each other
  • Hook into Sequelize lifecycle events
  • Query on models (findAll, findOne, create, "magic methods", etc)

📎 Extra Resources:

• Official Sequelize Documentation
• How to Locate Magic Methods
• Magic Methods Script
• Lifecycle Methods

Day 4: WikiStack 2

• Pre-Work:
  • Sequelize: Eager Loading
  • Sequelize: Instance & Class Methods
  • Express: Error Handling

Topic	Lecture	Slides	Demo	Solution	Review
Rounding Out Express & Sequelize	📺	🖼️	🧑‍💻	-	-
Wikistack 2	-	-	-		👾
Morning Review		🎟	-	-	-

• You should be able to:
  • Write custom error handlers in Express
  • Utilize eager loading in Sequelize queries
  • Write class and instance methods on Sequelize models

Day 5

Topic	Lecture	Slides	Demo	Solution	Review
Morning Review	-	-	-	-	-
Review		-	-	-	👾
Cody's Cafe	📤		-		-

Continue to 📆 Week 3