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!





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

David Katz

Software Engineer - Coding Instructor

David is a software engineer at Zendesk, with a Bachelor of Computer Science from the University of San Francisco.

David has gained valuable experience from the tech industry. By incorporating these best practices, he hopes to create the highest quality learning experiences possible.

Feel free to connect with David! He is always curious about the cool project you're working on. And he loves to discuss ideas on how to build impactful technology.

See full profile

Report class