CF

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

Frequently asked questions

What prerequisites are needed before taking this course?
This course is designed for individuals who have a basic understanding of programming concepts. While prior knowledge of JavaScript will be helpful, it is not mandatory as the course covers Node.js from the basics. The installation of Node and a code editor is optional and is covered in the course material.
What projects will I build during the course?
The course includes building three full projects, emphasizing the practical application of Node, SQL, and PostgreSQL. You will set up and work on the Fortunes API and the Monsters API, learning to create endpoints, handle HTTP requests with Express, and manage data using SQL and relational tables.
Who is the target audience for this course?
This course is intended for aspiring backend web developers and software engineers who want to gain practical skills in Node, SQL, and PostgreSQL. It is suitable for those looking to build web applications and APIs and those interested in expanding their knowledge of popular backend development technologies.
How does this course compare to others in terms of depth and scope?
This course offers a project-based approach to mastering backend web development using Node.js, SQL, and PostgreSQL. It covers the essential concepts and techniques widely used in the industry today, such as creating HTTP servers, using Express for routing, and managing databases with SQL. The course also explores advanced topics like error handling with middleware and complex queries.
What specific tools or platforms are covered in the course?
The course provides comprehensive coverage of Node.js and Express for building backend applications. It also includes the use of PostgreSQL for database management, along with tools like Postman for testing API endpoints. Installation of Node and a code editor is optional but addressed in the lessons.
What is not covered in this course?
The course focuses specifically on backend development with Node.js, SQL, and PostgreSQL. It does not cover frontend development, client-side JavaScript frameworks, or other database systems beyond PostgreSQL. Additionally, the course does not delve into deployment or cloud services.
What is the expected time commitment for this course?
The course consists of 39 lessons, all aimed at providing a thorough understanding of backend development with Node, SQL, and PostgreSQL. Although the total runtime is not specified, students should expect to engage with the material actively, including coding exercises and project work, to fully benefit from the course.