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.
Node, SQL, & PostgreSQL - Mastering Backend Web Development
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 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
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 |
Get instant access to all 38 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionCourse content
39 lessons · 4h 59m 41sShow all 39 lessons
- 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
Related courses
-

Effective Database Design
By: Ben BrummThe 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
By: UdemyThere 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 won4 hours 24 minutes 35 seconds -

Microservices with NodeJS, React, Typescript and Kubernetes
By: UdemyIn building large scale applications intended for growth, microservices architecture is the go-to solution. One issue for Javascript and NodeJS learners is the97 hours 19 minutes 16 seconds 5 / 5