Node, SQL, & PostgreSQL - Mastering Backend Web Development

4h 59m 41s
English
Paid

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.

Read more about the course

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

Stripe Payments JavaScript Course

Stripe Payments JavaScript Coursefireship.io

Category: React.js, Node.js
Duration 1 hour 29 minutes 26 seconds
NodeJS Microservices: Breaking a Monolith to Microservices

NodeJS Microservices: Breaking a Monolith to Microservicesudemy

Category: Node.js
Duration 6 hours 57 minutes 13 seconds
Learn and Understand NodeJS

Learn and Understand NodeJSudemy

Category: Node.js
Duration 13 hours 9 minutes 49 seconds
Building Full-Stack Apps with AI

Building Full-Stack Apps with AIMckay Wrigley (takeoff)

Category: Other (Backend), Other (Frontend)
Duration 8 hours 3 minutes 16 seconds
Fundamentals of Backend Engineering

Fundamentals of Backend Engineeringudemy

Category: Other (Backend)
Duration 16 hours 53 minutes 4 seconds
MERN Stack React, Socket io, Next.js Express,MongoDb, Nodejs

MERN Stack React, Socket io, Next.js Express,MongoDb, Nodejsudemy

Category: React.js, Next.js, Node.js, MongoDB, Socket.IO
Duration 13 hours 2 minutes 12 seconds
Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Category: Sql
Duration 4 hours 24 minutes 35 seconds
Node.js: The Complete Guide to Build RESTful APIs

Node.js: The Complete Guide to Build RESTful APIscodewithmosh (Mosh Hamedani)

Category: Node.js, MongoDB
Duration 15 hours 5 minutes 56 seconds
Learn Database Design with MySQL

Learn Database Design with MySQLoreillymedia

Category: Sql
Duration 6 hours 14 minutes 51 seconds