Node, SQL, & PostgreSQL - Mastering Backend Web Development

4h 59m 41s
English
Paid
November 4, 2024

Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development stacks today, learning Node, SQL, and PostgreSQL is a must. Knowing these languages and frameworks will open doors and jobs for you. In this project-based course, you’ll learn how to build Node, SQL, and PostgreSQL applications by building three full projects. You’ll discover some techniques widely used in the industry today.

More

And you’ll find out how to use notable libraries like Express and Pg.

You will skyrocket to the top of the talent pool because you can build backend web applications. The backend is the heart of services and products. So knowing how to write the backend is the other highly crucial skill looked for by top software companies like Google, Facebook, Microsoft, and more.

In this course, you’ll get familiar with Node by building an application from the start. First, you’ll learn how to use the native Node modules to build a server.

Second, you’ll build a more in-depth application with Node and Express to learn how to a build an api with a complete set of http request methods.

Next, you’ll dive into SQL and PostgreSQL to build a solid foundation around these tools. After, you’ll build an api that combines all the previous concepts with Node and PostgreSQL so that you understand how to create Node apps that work with advanced databases.

If you’ve already gone through the the quick JavaScript and web development tutorials online, then this course will take you to the next level.

Ready to step up your coding game? Excited to boost your skills? Then what you are waiting for? Let’s get started coding!

Watch Online Node, SQL, & PostgreSQL - Mastering Backend Web Development

Join premium to watch
Go to premium
# Title Duration
1 What to Expect from the Course 01:41
2 Optional: Installing Node 02:41
3 Optional: Installing a Code Editor 03:00
4 What is Node.js? 06:07
5 NPM, Modules, and a Node Program 04:42
6 First HTTP Server 10:23
7 Optional: HTTP and Web Requests 03:39
8 ES6 in Node 05:24
9 JSON, Nodemon, and more Advanced Functionality 11:04
10 Optional: the Event Loop 04:05
11 Express 01:43
12 Setting Up the Fortunes API 02:57
13 JSON for Fortunes 04:59
14 First Express Endpoint 10:16
15 Optional: Startup with an Executable 06:36
16 Get a Random Fortune or One by ID 09:47
17 Fortunes Post Method 17:24
18 Clean the Fortunes Post Method and Use Postman 07:44
19 Update Fortunes with Put 11:39
20 Delete Fortunes 04:38
21 SQL, the Relational Model, and PostgreSQL 05:51
22 PSQL Installation 08:48
23 Creating Tables and Insertion 08:54
24 Creating SQL Scripts 09:20
25 Selecting Table Data 06:45
26 Relational Tables 08:19
27 Joining Tables 06:34
28 Setting up the Monsters API 08:24
29 Node SQL Configure Script 13:21
30 Optional: Configure with Password 03:39
31 Configure the Postgres Pool 10:43
32 Monsters GET Request with Express 10:10
33 Error Handling in Express with Middleware 04:15
34 Monsters Get by ID and Express Routes 11:03
35 Monsters Post Method 10:40
36 Monsters Put Method 15:05
37 Monsters Delete Method 04:56
38 The Habitats Route 10:32
39 Relations and more Advanced Queries 11:53

Similar courses to Node, SQL, & PostgreSQL - Mastering Backend Web Development

Redis Caching Concepts with Node.js

Redis Caching Concepts with Node.jsCodedamn

Duration 1 hour 52 minutes 26 seconds
Docker for Node.js Projects From a Docker Captain

Docker for Node.js Projects From a Docker Captainudemy

Duration 8 hours 14 minutes 12 seconds
Instagram Clone Coding 3.0

Instagram Clone Coding 3.0Nomad Coders

Duration 20 hours 48 minutes 39 seconds
The Complete 2023 Web Development Bootcamp

The Complete 2023 Web Development Bootcampudemy

Duration 62 hours 32 minutes 23 seconds
Complete ASP.NET MVC 5

Complete ASP.NET MVC 5udemy

Duration 7 hours 33 minutes 52 seconds