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

The Modern GraphQL Bootcamp (with Node.js and Apollo)

The Modern GraphQL Bootcamp (with Node.js and Apollo)udemy

Category: Node.js, GraphQL
Duration 23 hours 26 minutes 42 seconds
Discord Clone - Learn MERN Stack with WebRTC and SocketIO

Discord Clone - Learn MERN Stack with WebRTC and SocketIOudemy

Category: JavaScript, React.js, Node.js, MongoDB, Socket.IO, WebRTC
Duration 19 hours 29 minutes 29 seconds
Mastering Node.js Streams with Erick Wendel

Mastering Node.js Streams with Erick WendelErick Wendel

Category: Node.js
Duration 11 hours 39 minutes 5 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQLudemy

Category: Sql, Data processing and analysis
Duration 12 hours 32 minutes 7 seconds
Full-Stack Web Developer Bootcamp with Real Projects

Full-Stack Web Developer Bootcamp with Real Projectsudemy

Category: JavaScript, HTML, CSS, Node.js, MongoDB, JQuery
Duration 22 hours 11 minutes 13 seconds
Clean Code: Writing Code for Humans

Clean Code: Writing Code for Humans pluralsight

Category: Other (Backend), Other (Frontend)
Duration 3 hours 10 minutes 36 seconds
MERN React Node Next.js Multi User SEO Blogging Platform

MERN React Node Next.js Multi User SEO Blogging Platformudemy

Category: React.js, Next.js, Node.js
Duration 20 hours 25 minutes 13 seconds