CourseFlix

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.

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!

About the Author: Udemy

Udemy thumbnail

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

Watch Online 39 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 39 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: What to Expect from the Course
All Course Lessons (39)
#Lesson TitleDurationAccess
1
What to Expect from the Course Demo
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
Unlock unlimited learning

Get instant access to all 38 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Course content

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

Related courses

  • Effective Database Design thumbnail

    Effective Database Design

    By: Ben Brumm
    The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
    1 hour 3 minutes 56 seconds 5 / 5
  • Learn MySQL and Solve 42 Practical Problems thumbnail

    Learn MySQL and Solve 42 Practical Problems

    By: Udemy
    There are a lot of tutorials out there talking about basics of SQL language and statements, which is good. However, a lot of times, just learning the syntax won
    4 hours 24 minutes 35 seconds
  • Microservices with NodeJS, React, Typescript and Kubernetes thumbnail

    Microservices with NodeJS, React, Typescript and Kubernetes

    By: Udemy
    In building large scale applications intended for growth, microservices architecture is the go-to solution. One issue for Javascript and NodeJS learners is the
    97 hours 19 minutes 16 seconds 5 / 5

Frequently asked questions

What is Node, SQL, & PostgreSQL - Mastering Backend Web Development about?
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…
Who teaches Node, SQL, & PostgreSQL - Mastering Backend Web Development?
Node, SQL, & PostgreSQL - Mastering Backend Web Development is taught by Udemy. You can find more courses by this instructor on the corresponding source page.
How long is Node, SQL, & PostgreSQL - Mastering Backend Web Development?
Node, SQL, & PostgreSQL - Mastering Backend Web Development contains 39 lessons with a total runtime of 4 hours 59 minutes. All lessons are available to watch online at your own pace.
Is Node, SQL, & PostgreSQL - Mastering Backend Web Development free to watch?
Node, SQL, & PostgreSQL - Mastering Backend Web Development is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch Node, SQL, & PostgreSQL - Mastering Backend Web Development online?
Node, SQL, & PostgreSQL - Mastering Backend Web Development is available to watch online on CourseFlix at https://courseflix.net/course/node-sql-postgresql-mastering-backend-web-development. The page hosts every lesson with the integrated video player; no download is required.