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

For which of the following SQL relationships is a join table required?

For which of the following SQL relationships is a join table required?

Duplicating the data of one table into another.

By using a foreign key in one of the tables that maps to the primary key of the other.

By running a `SELECT` query for each table.

Many-to-one can't be actualized with SQL only.

In what way is a many-to-one relationship actualized in SQL?


In what way is a many-to-one relationship actualized in SQL?

What is the relationship that exists between dispatch riders and a delivery company?

What is the relationship that exists between dispatch riders and a delivery company?

```
SELECT * FROM STUDENTS WHERE surname="Ebuka"
```

This query can’t be performed with SQL.

```
SELECT STUDENTS WHERE surname="Ebuka"
```

Assuming you have a database of students’ family histories and you need an SQL query to get a student with a `surname` of `“Ebuka”`, which of the following queries will give the desired result?

Assuming you have a database of students’ family histories and you need an SQL query to get a student with a <code>surname</code> of <code>“Ebuka”</code>, which of the following queries will give the desired result?

If you discover you’ve made a mistake after saving the details of a student and need to correct their first name, which SQL operation will be required?

If you discover you’ve made a mistake after saving the details of a student and need to correct their first name, which SQL operation will be required?

Which command is used to both pull (download) and run a Docker image at once?

Which command is used to both pull (download) and run a Docker image at once?

The `docker ps` command is used to get the list of containers. Which other command can be used to do this?


The <code>docker ps</code> command is used to get the list of containers. Which other command can be used to do this?

Take a quiz to test your understanding of SQL.

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

Quiz: SQL Introduction and Setup