Step by Step APIs Development in Node JS with Sequelize ORM

Install node.js on Windows, macOS, or Linux by downloading from the official site; verify with node -v; update to the latest version using global npm commands; use visual studio code.

Run your first Node program by creating a file, using Node to execute it, and exploring console.log and the global object, including setTimeout and process.

Learn how node.js uses modules, the module object, and module.exports to export values and functions. Explore core, local, and third-party modules, and how to access them using require.

Explore npm, the node package manager, and learn to install, update, and uninstall third-party modules, with local versus global installation for express, mysql, and sequelize in node js projects.

Explore express.js basics as a node.js framework that speeds app development, handles routes and middleware, serves static files, supports templating engines, and connects to databases via npm installation.

Develop and run an Express server in Node.js, install Express, define get routes for about us, contact us, and services, and enable automatic restarts with nodemon.

Install the Sequelize package and the required database driver, and create a database. Configure a connection with host, dialect, and port, then test it using Sequelize authenticate.

Define and use Sequelize models to map tables, specifying id as primary key with auto increment, name, email, and status; enable created_at and updated_at timestamps and sync model to database.

this video presents an alternative method for creating models in Sequelize, defining attributes such as id, name, and status, and demonstrates syncing to create or drop tables.

Discover how to insert data with Sequelize's create() in Node.js, by passing an object of column values, reading body parameters with body-parser, testing with Postman, and returning status 200.

Learn how to perform bulk data insertion with Sequelize's bulkCreate in a Node.js app, including setting up models, routes, and error handling to insert multiple users at once.

Explore sequelize findAll to fetch all users, filter by status for active records, and convert promise-based blocks to arrow functions for cleaner code.

Learn how to use Sequelize's update() method to modify user records by id, passing name and email in the request body and handling promises and responses in a Node.js API.

Learn how to delete data from a database table using Sequelize destroy, passing the id parameter via an HTTP delete request, and handle success and error responses.

Learn how to run raw SQL queries in Sequelize to perform select, update, and delete operations, using promise-based flows and HTTP requests to test and manage data.

Explain what jwt is, its header, payload, and signature structure, and how to use it in a Node.js app with the jsonwebtoken package’s sign and verify methods.

Set up node.js app with express, sequelize and mysql dialect, install jwt support and big crypt hashing, define a user model, connect to mysql, and prepare for jwt protected apis.

Build a register user API in Node.js using Sequelize ORM that accepts name, email, and password, hashes the password with bcrypt, and saves the user while checking for duplicates.

Create a config folder and export a JWT config file storing secret, expires in, not before, audience, issuer, and algorithm to manage token generation.

Learn how to validate a JWT token in Node.js using JWT.verify, including passing the token and secret key, handling decoded payload, and managing expiration and not-before constraints.

Install and configure sequelize cli, installing express, mysql2, and body-parser, and generate config, migrations, models, and seeders. Explore cli commands to create models, migrations, and seeders for a Node.js API.

Explore the folder structure of the Sequelize CLI, including config, migrations, models, and seeders, for handling database connections, schema changes, CRUD operations, dummy data, and customizing folder locations.

Learn to create and drop databases with Sequelize CLI by configuring development connection details and running db:create and db:drop commands.

Create a product model and its migration with the Sequelize CLI, migrate to the database, and review the products table with timestamps and migration tracking.

Learn to rollback migrations in Sequelize CLI by using migrate, migrate undo, and status to revert or reapply migrations, manage up and down methods for categories and products.

Create a simple seed with the sequelize CLI to populate the products table with dummy data, using a seed file, up and down methods, and the seed and run commands.

Learn how to use the Sequelize CLI to delete data from the database by undoing seeds, clearing categories and products tables, and reseeding selectively.

Seed your node apps with Sequelize CLI and Faker to generate hundreds of products and categories, creating realistic names, descriptions, prices, statuses, and images.

Configure an Express app using Sequelize CLI to manage application settings, define routes and models, and build an API to list all products from the database.

Explore how to use Sequelize CLI models and the findAll method to fetch only id and name, apply limit and offset, and order results by id or name.

Explore applying where conditions in Sequelize models using operators such as equal, greater than, between, and like to filter data and fetch precise results.

Learn how to use Sequelize CLI to compose complex where conditions with and, or, between, and like operators, including multi-column comparisons and value ranges.

Learn to build a register student API using Sequelize CLI to create a student model and migration, ensure unique emails, hash passwords with bcrypt, and test with Postman.

Develop a student login API with Sequelize CLI, including seeding a student, validating email and password, and generating a JWT with secret and expiry.

Explore securing a Node.js API with a JWT token validated by middleware, then fetch a student profile from the database using Sequelize.

Explore one-to-one associations in Sequelize by modeling a user and its email address, and a user and its phone, and learn how to implement and query these relations.

Explore one to many associations in Sequelize by linking posts with comments and users with posts, defining hasMany and belongsTo relations, and configuring migrations and foreign keys.

Explore how to implement a many-to-many relationship in Sequelize with a through table linking users and rules via the user_rules join table, including model setup, migrations, and querying joined data.

Apply Sequelize ORM model validation to enforce not empty fields, email format, min/max length, and numeric ranges on student attributes, with custom messages and server-side checks before insertion.

PM2 is a production process manager for node applications with a built-in load balancer that keeps apps alive. Install globally and manage apps using start, list, stop, and describe commands.

This bonus lecture explores Sequelize ORM within the step-by-step APIs development in Node.js course, invites feedback, reviews, and community contact via email, YouTube, and Twitter.

Learn how to install updated sequelize version via npm, generate models and migrations with the sequelize cli, and adapt to the model structure and timestamps in your Node.js app.