Skip to main content
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

Related courses

  • Learn and Understand NodeJS thumbnail

    Learn and Understand NodeJS

    Sources: Udemy
    NodeJS is a rapidy growing web server technology, and Node developers are among the highest paid in the industry. Knowing NodeJS well will get you a job or impr
    14 hours 35 minutes 16 seconds
  • Next.js and Apollo - Portfolio App (w/ React, GraphQL, Node) thumbnail

    Next.js and Apollo - Portfolio App (w/ React, GraphQL, Node)

    Sources: Udemy
    GraphQL is a query language for your API, and a server-side runtime for executing queries by using a type system you define for your data. GraphQL isn't tied to
    28 hours 38 minutes 19 seconds
  • Learn MySQL and Solve 42 Practical Problems thumbnail

    Learn MySQL and Solve 42 Practical Problems

    Sources: 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