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

# Overview of SQL

**SQL (Structured Query Language)** is a language used to manage data in relational database systems. To be good at working with SQL, we should have a proper understanding of the kind of relationships that exist between the entities. This helps us write more efficient, maintainable, and scalable code.

These relationships can be: 
 
* one-to-many 
* many-to-many 
* one-to-one 
* many-to-one 

SQL is one of the most widely used relational databases and provides a well-defined structure for handling and querying data.

# Overview of SQL relationships

## One-to-one

In SQL, a **one-to-one relationship** is the relationship that exists between records of two tables where one record maps to another one uniquely. A one-to-one is a lot like a relationship that exists between an employee and the employee’s office—one in which a company assigns only a single office per employee.

## Many-to-one

A **many-to-one** or a **one-to-many relationship** is a relationship in which one record in an SQL table maps to many other records in a different table. A good illustration of this is the relationship that exists between the company and its employees. Many people (the employees) can belong to one company, and one company can have many employees.

To achieve this in the SQL, a foreign key column is added to either of the tables that map to the primary key of the other table.

Below we have two separate tables for the company and employees:

Learn about SQL and how it’s used to manipulate and access databases.

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

Introduction to SQL

Overview of SQL