Introduction
  • What to Expect from the Course
  • Tools You'll Need
  • Optional: Installing Node
  • Optional: Installing a Code Editor
  • Accompanying Repository for the Course
Node Essentials
  • What is Node.js?
  • NPM, Modules, and a Node Program
  • First HTTP Server
  • Optional: HTTP and Web Requests
  • ES6 in Node
  • JSON, Nodemon, and more Advanced Functionality
  • Optional: the Event Loop
  • Section Summary | Node Essentials
Node and Express | Fortunes API
  • Express
  • Setting Up the Fortunes API
  • JSON for Fortunes
  • First Express Endpoint
  • Optional: Startup with an Executable
  • Get a Random Fortune or One by ID
  • Fortunes Post Method
  • Clean the Fortunes Post Method and Use Postman
  • Update Fortunes with Put
  • Delete Fortunes
  • Fortunes API | Section Summary
SQL, Databases, and PostgreSQL
  • SQL, the Relational Model, and PostgreSQL
  • PSQL Installation
  • Creating Tables and Insertion
  • Creating SQL Scripts
  • Selecting Table Data
  • Relational Tables
  • Joining Tables
  • SQL, Databases, and PostgreSQL | Section Summary
Node and PostgreSQL App | Monsters API
  • Setting up the Monsters API
  • Node SQL Configure Script
  • Optional: Configure with Password
  • Configure the Postgres Pool
  • Monsters GET Request with Express
  • Error Handling in Express with Middleware
  • Monsters Get by ID and Express Routes
  • Monsters Post Method
  • Monsters Put Method
  • Monsters Delete Method
  • The Habitats Route
  • Relations and more Advanced Queries
  • Monsters API | Section Summary
Conclusion
  • Final Remarks and Bonus Content