Skip to content

Latest commit

 

History

History
51 lines (39 loc) · 7.9 KB

README.md

File metadata and controls

51 lines (39 loc) · 7.9 KB

Module 4: NodeJS, Express, and SQL

Learning Outcomes

  • M4.1 Understand how servers work
  • M4.2 Use Node.js to create and run command line applications
  • M4.3 Understand what APIs are and how they should be designed
  • M4.4 Use Express to build an API
  • M4.5 Understand the problem databases solve and build schemas
  • M4.6 Use SQL to run CRUD operations and JOINs
  • M4.7 Use Postgres to build a database and interact with it through its CLI
  • M4.8 Use knex.js to build a web application backed by SQL
  • M4.9 Use Firebase to authenticate users

Lessons, Quizzes, and Labs

Lesson Lab
1. NodeJS Intro + Event Loop Not applicable.
2. npm and Modules Use Chalk / Build Math and String Modules
3. The Internet and Introduction to Servers Random User / Open Trivia Database
4. Intro to Express and routing Calculator API
5. Express Passing Data Pixabay / Giphy Web App
6. Express Middleware Animals / Random Numbers / Queue
7. Express Nested Routing & App Structure Recipe API
8. Intro to Databases SQL Bolt
9. Postgres & Seeding Databases Social Media Database
10. Postgres & pg-promise Social Media Database Part Two

Individual Project

Project Standards
Simple School Management System
  • EF.4.e: Use frequent, descriptive, small commits
  • FSW.1.d: Manipulate and access objects and objects in arrays
  • FSW.3.c: Use HTML input and forms
  • FSW.3.e: Create a responsive UI
  • FSW.10.a: Create an Express app
  • FSW.10.b: Use routes to send responses and errors
  • FSW.11.b: Use middleware to inject code
  • LF.5: Use functions to keep code DRY
  • LF.6: Proper use and understanding of Higher order functions & closures or callbacks

Assessment

Assessment Standards
6.2 Marine Database / 6.4 Marine Database
  • EF.4.e: Use frequent, descriptive, small commits
  • FSW.1: Write clean, readable JavaScript code
  • FSW.1.b: Understanding of Callbacks
  • FSW.10.a: Create an Express app
  • FSW.10.b: Use routes to send responses and errors
  • FSW.13: Design, structure, and seed a database for a full stack CRUD application
  • FSW.14.c: Build an Express application that utilizes Postgres and pg-promise
  • FSW.15: Build a full-stack application

Group Project

Additional Resources