Node, SQL, & PostgreSQL - Mastering Backend Web Development

4h 59m 41s
English
Paid

Course description

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

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

Watch Online Node, SQL, & PostgreSQL - Mastering Backend Web Development

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

MERN Stack React, Socket io, Next.js Express,MongoDb, Nodejs

MERN Stack React, Socket io, Next.js Express,MongoDb, Nodejs

Sources: udemy
If you are a person who is not picky about a CSS framework and wants to learn how to create enterprise-grade, practical full stack app using new technologies, then this course i...
13 hours 2 minutes 12 seconds
Effective Database Design

Effective Database Design

Sources: 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
Scaling Web App Configuration with Environment Variables

Scaling Web App Configuration with Environment Variables

Sources: fullstack.io
This course examines in detail the use of the dotenv module for working with environment variables in JavaScript. You will learn to create nine different...
1 hour 53 minutes 25 seconds
Uber Clone - Typescript, NodeJS, GraphQL, React, Apollo

Uber Clone - Typescript, NodeJS, GraphQL, React, Apollo

Sources: Nomad Coders
We will do a Uber clone (backend + frontend + deployment). From head to toe using JavaScript! This time full stack, full JavaScript stack!
22 hours 41 minutes 56 seconds
Redis Caching Concepts with Node.js

Redis Caching Concepts with Node.js

Sources: Codedamn
Redis is an open-source in-memory data store used as a database, cache, and message broker. It is incredibly fast and suitable for a variety of tasks.
1 hour 52 minutes 26 seconds