Gain insights into Node.js, Express, and TypeScript advantages. Learn Docker setup for PostgreSQL, discover Prisma and TypeORM, and explore advanced ORM features via hands-on projects.

ORM-libraries-for-NodeJS-Typescript-and-SQL.png

ORM.tar.gz

node-server

typeorm-setup

docker-prisma

basic-api

basic-express

typeorm-crud

typeorm-SQL

typeorm-associations

Object Relational Mappers (ORM) are becoming popular in building modern backend applications as they help maintain a consistent codebase, improve security, and provide ease in working with different databases. Also, TypeScript has almost become a must-use language for building JavaScript applications.

In this course, you’ll start by getting familiar with Node.js and Express. You’ll then go over the main features of TypeScript and its advantages over JavaScript. Next, you’ll learn how to do a Docker setup of PostgreSQL. Moreover, this will be followed by introductions to two of the most popular TypeScript ORMs for Node.js: Prisma and TypeORM. Along the way, you’ll practice your skills by building two projects. In the end, you’ll explore some advanced features of these ORMs.

This course will equip you with the skills, knowledge, and hands-on experience to work with SQL databases and Node.js using TypeScript ORMs.

Getting Started with TypeScript ORM Libraries for Node.js

NestJS is a Node.js framework or library. It’s unique in that it ships a lot of libraries for difficult tasks such as cron jobs, authentication, sockets, and so on, improving the developer experience. It’s highly modularized and well-structured from the ground up, which makes it one of the best choices for many back-end engineers.

In this lesson, we’ll go through five different steps to set up the codebase.


# Create a starter project
From the official NestJS GitHub repository, we can [clone a starter project](https://github.com/nestjs/typescript-starter).
>**Tip:** We have a Single-page application (SPA) widget with all the configurations and setups that can be used to practice. 



git clone https://github.com/nestjs/typescript-starter.git typeorm-educative
cd project
npm install
npm run start:debug

With our local setup, we can now open the application in the browser on `localhost:3000`.

# Install npm packages for TypeORM

We’ll install the `typeorm` package via npm.







Learn about the NestJS library, TypeORM, and how to install them via the CLI on our local machine.

Course Overview

Node.js Features and Setup

TypeScript Features and Setup

SQL – Introduction and Setup

Understanding ORMs for Node.js

Prisma

Flight Booking System

TypeORM

Advanced Topics

School Grading System

Conclusion

TypeORM Setup

Create a starter project

Install npm packages for TypeORM