Node, SQL, & PostgreSQL - Mastering Backend Web Development

Name: Node, SQL, & PostgreSQL - Mastering Backend Web Development
Rating: 3.9 (1385 reviews)

Boost your Node, Express, SQL, PostgreSQL and Backend Development Skills! NodeJS, Databases, Express, JS, ES6, + more!

Created byDavid Joseph Katz

Last updated 10/2022

English

What you'll learn

Build full Node and PostgreSQL applications.
Discuss the backend Web Development with fellow software engineers.
Apply various web requests to their custom backend applications.
Use and build Node middleware, for error handling as well as parsing incoming data.
Use advanced es6 concepts to write more concise code.
Extend Node applications with third-party libraries.
Have an understanding of the Node event loop.

Course content

6 sections • 47 lectures • 5h 12m total length

What to Expect from the Course1:40
Tools You'll Need0:31
Optional: Installing Node2:40
Optional: Installing a Code Editor2:59
Windows: Installing the Windows Subsystem for Linux and Visual Studio Code8:40
Accompanying Repository for the Course0:12

What is Node.js?6:06
NPM, Modules, and a Node Program4:41
Install and verify node and npm, initialize your first node project with npm init to create a package.json, then use mkdir, cd, and ls to organize folders, and explore modules.
First HTTP Server10:22
Build a basic Node http server by creating index.js, using the http module, and handling requests with req and res to serve a welcome message at localhost:3000.
Optional: HTTP and Web Requests3:38
ES6 in Node5:23
JSON, Nodemon, and more Advanced Functionality11:03
Optional: the Event Loop4:03
Section Summary | Node Essentials0:50

Express1:42
Setting Up the Fortunes API2:56
JSON for Fortunes4:58
First Express Endpoint10:15
Create a Node Express server in index.js, expose a /fortunes GET endpoint, log requests, and respond with fortunes.json data via res.json, listening on port 3000 with Nodemon for live updates.
Optional: Startup with an Executable6:35
Create a bin/w-w-w executable to start your node express app, export the app from app.js, and update npm start to run the executable.
Get a Random Fortune or One by ID9:46
Fortunes Post Method17:23
Clean the Fortunes Post Method and Use Postman7:43
Update Fortunes with Put11:37
Delete Fortunes4:37
Create delete support for fortunes in the Express API by filtering out the target id and saving the updated array to fortunes.json, tested via Postman.
Fortunes API | Section Summary1:09

Setting up the Monsters API8:23
Node SQL Configure Script13:20
Optional: Configure with Password3:38
Configure the Postgres Pool10:42
Monsters GET Request with Express10:09
Error Handling in Express with Middleware4:14
Monsters Get by ID and Express Routes11:02
Monsters Post Method10:39
Monsters Put Method15:04
Monsters Delete Method4:54
The Habitats Route10:31
Create a habitats route to interact with the habitats table, implementing get all habitats and post new habitats using express and a database pool, mirroring the monsters route.
Relations and more Advanced Queries11:52
Monsters API | Section Summary0:50

Requirements

Some JavaScript experience would be helpful.

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. 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!

Who this course is for:

Anyone who wants to learn how to create Node and PostgreSQL applications.
Someone with experience in JavaScript.
A developer who wants to refine their backend skills.

Node, SQL, & PostgreSQL - Mastering Backend Web Development

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 17min

Node Essentials8 lectures • 46min

Node and Express | Fortunes API11 lectures • 1hr 19min

SQL, Databases, and PostgreSQL8 lectures • 55min

Node and PostgreSQL App | Monsters API13 lectures • 1hr 55min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: