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 Videos (2h 49m)
    • SQL, the Relational Model, and PostgreSQL

      5:49
    • PSQL Installation

      8:46
    • Creating Tables and Insertion

      8:53
    • Creating SQL Scripts

      9:19
    • Selecting Table Data

      6:43
    • Relational Tables

      8:18
    • Joining Tables

      6:32
    • Setting Up the Monsters API

      8:24
    • Node SQL Configure Script

      13:20
    • Optional: Configure with Password

      3:38
    • Configure the Postgres Pool

      10:43
    • Monsters Get Request with Express

      10:09
    • Error Handling in Express with Middleware

      4:14
    • Monsters Get by ID and Express Routes

      11:02
    • Monsters Post Method

      10:40
    • Monsters Put Method

      15:04
    • Monsters Delete Method

      4:55
    • The Habitats Route

      10:32
    • Relations and More Advanced Queries

      11:52

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!

22

Students

--

Projects

David Katz

Software Engineer - Coding Instructor

Hello! I'm David - a native San Franciscan and biracial American. I currently study CS at the University of San Francisco.

I'm a self-taught full-stack developer with hopes to become a software engineer. In my spare time, I make apps and coding tutorials.

I've used technologies like ReactJS, React Native, NodeJS, and plenty more to build my applications.

Because the programming community has given me so much, I spend a lot of time teaching.

At MVCodeClub, I help ki...

See full profile