Node, SQL, & PostgreSQL - Mastering Backend Web Development

Focused View

David Joseph Katz

5:07:42

20 View

1 - Introduction

1 - What to Expect from the Course.mp4

01:40

2 - Tools Youll Need.html

3 - Optional Installing Node.mp4

02:40

4 - Optional Installing a Code Editor.mp4

02:59

5 - Windows Installing the Windows Subsystem for Linux and Visual Studio Code.mp4

08:40

6 - Accompanying Repository for the Course.html

2 - Node Essentials

7 - What is Nodejs.mp4

06:06

8 - NPM Modules and a Node Program.mp4

04:41

9 - First HTTP Server.mp4

10:22

10 - Optional HTTP and Web Requests.mp4

03:38

11 - ES6 in Node.mp4

05:23

12 - JSON Nodemon and more Advanced Functionality.mp4

11:03

13 - Optional the Event Loop.mp4

04:04

14 - Section Summary Node Essentials.html

3 - Node and Express Fortunes API

15 - Express.mp4

01:42

16 - Setting Up the Fortunes API.mp4

02:56

17 - JSON for Fortunes.mp4

04:58

18 - First Express Endpoint.mp4

10:15

19 - Optional Startup with an Executable.mp4

06:35

20 - Get a Random Fortune or One by ID.mp4

09:46

21 - Fortunes Post Method.mp4

17:23

22 - Clean the Fortunes Post Method and Use Postman.mp4

07:43

23 - Update Fortunes with Put.mp4

11:38

24 - Delete Fortunes.mp4

04:37

25 - Fortunes API Section Summary.html

4 - SQL Databases and PostgreSQL

26 - SQL the Relational Model and PostgreSQL.mp4

05:50

27 - PSQL Installation.mp4

08:47

27 - PostgreSQL Installation Tutorial Markdown.txt

28 - Creating Tables and Insertion.mp4

08:53

29 - Creating SQL Scripts.mp4

09:19

30 - Selecting Table Data.mp4

06:44

31 - Relational Tables.mp4

08:18

32 - Joining Tables.mp4

06:33

33 - SQL Databases and PostgreSQL Section Summary.html

5 - Node and PostgreSQL App Monsters API

34 - Setting up the Monsters API.mp4

08:23

35 - Node SQL Configure Script.mp4

13:20

36 - Optional Configure with Password.mp4

03:38

37 - Configure the Postgres Pool.mp4

10:42

38 - Monsters GET Request with Express.mp4

10:09

39 - Error Handling in Express with Middleware.mp4

04:14

40 - Monsters Get by ID and Express Routes.mp4

11:02

41 - Monsters Post Method.mp4

10:39

42 - Monsters Put Method.mp4

15:04

43 - Monsters Delete Method.mp4

04:55

44 - The Habitats Route.mp4

10:31

45 - Relations and more Advanced Queries.mp4

11:52

46 - Monsters API Section Summary.html

6 - Conclusion

47 - Final Remarks and Bonus Content.html

Description

Boost your Node, Express, SQL, PostgreSQL and Backend Development Skills! NodeJS, Databases, Express, JS, ES6, + more!

What You'll Learn?

Build full Node and PostgreSQL applications.
Discuss the backend Web Development with fellow software engineers.
Apply various web requests to their custom backend applications.
Use and build Node middleware, for error handling as well as parsing incoming data.
Use advanced es6 concepts to write more concise code.
Extend Node applications with third-party libraries.
Have an understanding of the Node event loop.

Who is this for?

Anyone who wants to learn how to create Node and PostgreSQL applications.

Someone with experience in JavaScript.

A developer who wants to refine their backend skills.

What You Need to Know?

Some JavaScript experience would be helpful.

More details

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. 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!
Who this course is for:
Anyone who wants to learn how to create Node and PostgreSQL applications.
Someone with experience in JavaScript.
A developer who wants to refine their backend skills.

User Reviews

Rating

average 0

Total votes0

Focused display

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 the best practices he has learned at work, 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.