Complete Backend Development | Node js | MSSQL | Docker 2024

Learn database fundamentals, SQL basics, and best practices for efficient, secure databases, including relational and non-relational differences, with Microsoft SQL Server, and document stores like MongoDB and Firebase.

Install and run Microsoft SQL Server in a Docker container, and configure a local workspace with Azure Data Studio to run queries and manage schemas.

Learn to set up a docker-based sql server database, create a backend database, and design tables with identities and primary keys, including users, appointments, patients, and diagnoses.

Master basic SQL commands on a users table, including select, insert, update, and delete, and learn store procedures to boost performance and security, with documentation in SQL files.

Learn to create and call stored procedures in SQL, reuse and secure code, and automate backend operations with parameterized procedures for user management (get all, add, update, delete).

Learn to create, modify, and drop stored procedures in MSSQL for a node js backend, covering add, update, get, and delete users, patients, appointments, and diagnosis checks, including email sending.

Document store procedures to help future developers understand database structure, then push code via git workflows, switch branches, commit, and create a pull request to merge changes.

Connect your backend to a local database by creating a SQL config using dotenv variables for username, password, and the backend database, referencing the docker setup.

Develop a reusable database helper in Node.js using a pooled MySQL connection to execute store procedures with inputs, leveraging a TypeScript database.ts file.

Learn to validate user input before database entry by implementing frontend-api checks with the joy package, creating register and login schemas that enforce required fields, minimum lengths, and email validation.

Learn authentication workflows with sign up and sign in, secure password handling and token-based protection using json web tokens, input validation, and a signup store procedure in MSSQL.

Master sign-in in a Node.js backend with MSSQL, validate login data, compare passwords with bcrypt, issue a JWT from dotenv, and return user data and token.

Implement get all users and delete user functionality in a backend using store procedures, handle id from request params, and return structured json responses ready for postman testing.

Create appointment logic in node.js by calling the add appointment store procedure with patient name, doctor email, date, and patient email; use try/catch and respond with 201 on success.

Create, update, and fetch diagnosis data in a node.js backend using mssql, wiring requests to a diagnosis store procedure, handling input data, errors, and responses.

Develop patient management logic in node js with mssql, enabling add, delete, update, and get patients via store procedures, using request body and params with error handling.

Explore how background services automate welcome emails using templates by scanning the user table, updating the is_sent flag, and using cron-based scheduling to run periodic checks.

Explore background services folder structure in a Node.js MSSQL docker project, including source, dist, and templates for email using EJS; learn how these services share a database with API.

Configure TypeScript for a background service by initializing tsconfig and output, set up config, email services, and helpers with dotenv secrets, while api runs on 5000 and background on 5001.

Learn to set up node background services that connect to a database, configure dotenv, and implement scheduling with node-cron using cron expressions.

Learn how to use ejs templating in a node backend to create email templates—appointment, report, welcome, and diagnosis—and integrate them with html emails and scheduling.

Enable two-factor authentication on your Google account, generate an app password, and store it securely in a .env file to enable sending emails from your backend.

learn to send emails using node mailer by creating a transporter, configuring gmail smtp with env credentials, and exporting a reusable send email helper to deliver messages via verified transporter.

Set up a node mailer transport and implement multiple email service files (welcome email, diagnosis email, appointment email, admission report) in TypeScript, exporting the functions for sending emails after user registration.

Automates welcome emails by regularly querying the database for new users, rendering a welcome template with ejs, sending the email, and marking it as sent.

Build diagnosis email functionality by rendering templates with ejs, sending to patient emails, attaching diagnosis pdfs, and updating the diagnosis status via database procedures after delivery.

Implement the appointment email workflow by retrieving unsent appointments, rendering an ejs template with patient name and date, sending to the doctor, and updating the status.

Automate generation and delivery of daily hospital reports by converting json to csv, compiling admitted patients, and sending the report by email via a cron-based scheduler and a template attachment.

Explore end-to-end backend testing with Postman, validating user signup, diagnosis, patient management, and appointment emails from a dockerized SQL Server with template-driven emails and background services.

Explore middleware in express: a set of functions that run during http requests, access the request and response objects, validate tokens or jwt, and gate access before reaching controllers.

Create a verify token middleware for the backend using node.js, express, json web token, and dotenv, then apply it to routes to enforce authentication with next().

Debug backend flows by implementing a verify token guard for routes like create appointment, while practicing git workflows—branching, committing, pushing, and merging pull requests that manage changes.

Learn to develop backends with APIs and background services that ensure reliable communication and client notifications, while challenging you to build your own front end with React or Angular.

Review the admission report email function, fix quote usage, and correct the store procedure name. Thank you for completing the course; please review, rate, and ask questions in the Q&A.