Introduction to Sequelize ORM (w/ Express.js + Postgres)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Necessary tools – Advise for Windows users

Lecture 3: Necessary tools – Node Version Manager (NVM)

Lecture 4: Join the Discord community

Lecture 5: About reviews

Lecture 6: Necessary tools – Docker and Docker Compose

Lecture 7: Necessary tools – Postman and DBeaver

Lecture 8: Installing VSCode

Chapter 2: Initial setup

Lecture 1: Repo for this course

Lecture 2: Initial setup

Lecture 3: Adding all the dependencies

Lecture 4: Configuring Babel, Jest and Nodemon

Lecture 5: Creating and connecting to the database

Chapter 3: JWT and Bcrypt

Lecture 1: Understanding JWT

Lecture 2: Understanding Bcrypt

Lecture 3: Adding environment variables

Lecture 4: Creating utils for JWT

Chapter 4: Database and models

Lecture 1: Creating the database class

Lecture 2: Register the models

Lecture 3: Adding the server

Lecture 4: Adding tests helpers

Lecture 5: Models overview

Lecture 6: Creating the User model (Part 1)

Lecture 7: Creating the User model (Part 2)

Lecture 8: Creating the User model (Part 3)

Lecture 9: Defining the Role model

Lecture 10: Adding Refresh Token model

Lecture 11: Inspecting the new tables with DBeaver

Lecture 12: Configuring the Sequelize CLI

Lecture 13: Adding User migration

Lecture 14: Adding Role migration

Lecture 15: Adding Refresh Token migration

Lecture 16: Applying migrations

Lecture 17: Small improvement to the User model

Lecture 18: Adding User model tests (Part 1)

Lecture 19: Adding User model tests (Part 2)

Lecture 20: Adding User model tests (Part 3)

Lecture 21: Adding User model tests (Part 4)

Lecture 22: Adding User model tests (Part 5)

Lecture 23: Adding Role model tests

Chapter 5: The Express app

Lecture 1: Create the Express app

Lecture 2: Creating an Errors middleware

Lecture 3: Creating a wrapper to handle async code

Lecture 4: Creating an authentication middleware

Chapter 6: Controllers

Lecture 1: Adding structure to the controllers

Lecture 2: Adding the register controller

Lecture 3: Adding tests for the register controller

Lecture 4: Adding the login controller

Lecture 5: Adding another test helper

Lecture 6: Adding tests for the login controller

Lecture 7: Adding a token controller

Lecture 8: Adding tests for the token controller (Part 1)

Lecture 9: Adding tests for the token controller (Part 2)

Lecture 10: Adding the logout controller

Lecture 11: Adding tests for the logout controller

Lecture 12: Looking at the coverage of our tests

Lecture 13: Listening for connections

Lecture 14: Testing the app manually with Postman

Lecture 15: Learning how to use the debug script

Chapter 7: Conclusion

Lecture 1: Conclusion