Node, SQL, & PostgreSQL - Mastering Backend Web Development
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
All Course Lessons (39)
| # | 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 |
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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Database Design Book
Node.js API - making it shine!
DuckDB - The Ultimate Guide
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
