Node, SQL, & PostgreSQL - Backend Web Development [1/2] | David Katz | Skillshare

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

David Katz, Software Engineer - Coding Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
20 Lessons (2h 10m)
    • 1. What to Expect from the Course

    • 2. Optional: installing Node

    • 3. Optional: Installing a Code Editor

    • 4. What is Node.js?

    • 5. NPM, Modules, and a Node Program

    • 6. First HTTP Server

    • 7. Optional: HTTP and Web Requests

    • 8. ES6 in Node

    • 9. JSON, Nodemon, and more Advanced Functionality

    • 10. Optional: the Event Loop

    • 11. Express

    • 12. Setting Up the Fortunes API

    • 13. JSON for Fortunes

    • 14. First Express Endpoint

    • 15. Optional: Startup with an Executable

    • 16. Get a Random Fortune or One by ID

    • 17. Fortunes Post Method

    • 18. Clean the Fortunes Post Method and Use Postman

    • 19. Update Fortunes Put Method

    • 20. Delete Fortunes Method


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!