Connecting a Node.js and Express.js Backend with a PostgreSQL Database
PostgreSQL 15.3
| Beginner
- 15 videos | 1h 3m 57s
- Includes Assessment
- Earns a Badge
Node.js has become a popular platform for creating web applications. It is now possible to connect a node application to databases using special software. This course is designed to equip learners with the knowledge and skills required to connect a Node.js backend with a PostgreSQL database using Express.js. Through a combination of theory and practical demonstrations, learners will discover how to establish a seamless connection, perform create, read, update, and delete (CRUD) operations, create RESTful API endpoints, implement error handling and validation, optimize performance, ensure security, and conduct testing. By the end of this course, learners will have a solid understanding of the integration between Node.js and PostgreSQL using Express.js and will be able to confidently build robust and scalable applications that interact with a PostgreSQL database.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Install the node.js platform on the linux operating system
Create a simple node-based application
Add the express package to an existing node.js application
Add flexibility to an existing node.js application
In this video, you will learn how to install the postgres database on the linux operating system.
Install a graphical user interface (gui) for the postgresql database on linux
Use a gui to create a postgresql database on linux -
Add a table to an existing postgresql database and define the table's columns using a gui
Add a new record and row to an existing table in a postgresql table using a gui
Add a configuration file to connect node.js to a postgresql database
Use express to create a path and endpoint to retrieve records from a postgresql database
Use a postgresql object to access and execute sql select statements from within node.js
Use a postgresql object to access and execute sql insert statements from within node.js
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 21sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
3m 35sLearn how to install the Node.js platform on the Linux operating system. FREE ACCESS
-
3. Creating a Basic Node Application5m 44sFind out how to create a simple Node-based application. FREE ACCESS
-
4. Node.js and Express.js5m 51sDuring this video, discover how to add the Express package to an existing Node.js application. FREE ACCESS
-
5. Structuring a Node.js Application5m 9sDiscover how to add flexibility to an existing Node.js application. FREE ACCESS
-
6. Installing Postgres on Linux4m 11sinstall the Postgres database on the Linux operating system FREE ACCESS
-
7. Installing pgAdmin44m 45sIn this video, discover how to install a graphical user interface (GUI) for the PostgreSQL database on Linux. FREE ACCESS
-
8. Creating a PostgreSQL Database4m 42sFind out how to use a GUI to create a PostgreSQL database on Linux. FREE ACCESS
-
9. Creating a Table to a PostgreSQL Database5m 2sDiscover how to add a table to an existing PostgreSQL database and define the table's columns using a GUI. FREE ACCESS
-
10. Adding a Record to an Existing PostgreSQL Database and Table3m 44sLearn how to add a new record and row to an existing table in a PostgreSQL table using a GUI. FREE ACCESS
-
11. Building a Configuration File for PostgreSQL and Node.js4m 49sIn this video, learn how to add a configuration file to connect Node.js to a PostgreSQL database. FREE ACCESS
-
12. Creating an Endpoint to Retrieve Records from a Database4m 18sFind out how to use Express to create a path and endpoint to retrieve records from a PostgreSQL database. FREE ACCESS
-
13. Using Exposed PostgreSQL Functions Inside a Node.js Application5m 54sDiscover how to use a PostgreSQL object to access and execute SQL Select statements from within Node.js. FREE ACCESS
-
14. Inserting Records into PostgreSQL Using Node.js4m 13sLearn how to use a PostgreSQL object to access and execute SQL Insert statements from within Node.js. FREE ACCESS
-
15. Course Summary40sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
