Understanding the basics of asynchronous programming in Node.js.

Using Callbacks, Promises and async/await for asynchronous control flow.

Handling errors and managing exceptions.

Implementing event-driven programming.

Introduction to Express.js, a popular framework for Node.js

Setting up an Express application.

Routing and Handling HTTPS application.

Middleware Usage and Creation.

Templating engines and server side rendering.

Working with databases in Node.js (eg MongoDB, MySQL etc)

Performing CRUD Operations and Data Modelling.

Implementing Database Migrations and Handling Transactions.

Designing and developing Restful API using Express.js

Implementing CRUD Operations with Restful Principles.

Authentication and Authorization using JWT (JSON Web Token)

Handling Input Validation and error handling.

API Documentation with tools like Swagger.

API testing using Postman.

Introduction, Installation and set-up

Create, Drop, Alter, Truncate, Rename operations

How to create a table

Normalization and likewise

Select, Insert, Update, Delete operations

Querying Db with ‘where clause’

Different querying operators: Distinct, limit, top, and, or, not, order
by, in, between

Like and wildcards

Alias

SQL Joins

Views creation, alteration, calling, deletion

DB connection

Querying

Making basic CRUD application