Node, SQL, & PostgreSQL - Backend Web Development [2/2]

David Katz, Software Engineer - Coding Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
19 Lessons (2h 49m)
    • 1. SQL, the Relational Model, and PostgreSQL

    • 2. PSQL Installation

    • 3. Creating Tables and Insertion

    • 4. Creating SQL Scripts

    • 5. Selecting Table Data

    • 6. Relational Tables

    • 7. Joining Tables

    • 8. Setting Up the Monsters API

    • 9. Node SQL Configure Script

    • 10. Optional: Configure with Password

    • 11. Configure the Postgres Pool

    • 12. Monsters Get Request with Express

    • 13. Error Handling in Express with Middleware

    • 14. Monsters Get by ID and Express Routes

    • 15. Monsters Post Method

    • 16. Monsters Put Method

    • 17. Monsters Delete Method

    • 18. The Habitats Route

    • 19. Relations and More Advanced Queries


About This Class

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!