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
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
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 21s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 3m 35s
    Learn how to install the Node.js platform on the Linux operating system. FREE ACCESS
  • Locked
    3.  Creating a Basic Node Application
    5m 44s
    Find out how to create a simple Node-based application. FREE ACCESS
  • Locked
    4.  Node.js and Express.js
    5m 51s
    During this video, discover how to add the Express package to an existing Node.js application. FREE ACCESS
  • Locked
    5.  Structuring a Node.js Application
    5m 9s
    Discover how to add flexibility to an existing Node.js application. FREE ACCESS
  • Locked
    6.  Installing Postgres on Linux
    4m 11s
    install the Postgres database on the Linux operating system FREE ACCESS
  • Locked
    7.  Installing pgAdmin4
    4m 45s
    In this video, discover how to install a graphical user interface (GUI) for the PostgreSQL database on Linux. FREE ACCESS
  • Locked
    8.  Creating a PostgreSQL Database
    4m 42s
    Find out how to use a GUI to create a PostgreSQL database on Linux. FREE ACCESS
  • Locked
    9.  Creating a Table to a PostgreSQL Database
    5m 2s
    Discover how to add a table to an existing PostgreSQL database and define the table's columns using a GUI. FREE ACCESS
  • Locked
    10.  Adding a Record to an Existing PostgreSQL Database and Table
    3m 44s
    Learn how to add a new record and row to an existing table in a PostgreSQL table using a GUI. FREE ACCESS
  • Locked
    11.  Building a Configuration File for PostgreSQL and Node.js
    4m 49s
    In this video, learn how to add a configuration file to connect Node.js to a PostgreSQL database. FREE ACCESS
  • Locked
    12.  Creating an Endpoint to Retrieve Records from a Database
    4m 18s
    Find out how to use Express to create a path and endpoint to retrieve records from a PostgreSQL database. FREE ACCESS
  • Locked
    13.  Using Exposed PostgreSQL Functions Inside a Node.js Application
    5m 54s
    Discover how to use a PostgreSQL object to access and execute SQL Select statements from within Node.js. FREE ACCESS
  • Locked
    14.  Inserting Records into PostgreSQL Using Node.js
    4m 13s
    Learn how to use a PostgreSQL object to access and execute SQL Insert statements from within Node.js. FREE ACCESS
  • Locked
    15.  Course Summary
    40s
    In 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.

YOU MIGHT ALSO LIKE

Book JavaScript All-in-One For Dummies
Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Book Mastering Amazon Relational Database Service for MySQL: Building and Configuring MySQL Instances

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CEH v11: Network Scanning, TCP, Host Discovery & Port/Service Scanning
Rating 4.7 of 60 users Rating 4.7 of 60 users (60)
Course JavaScript: Introduction
Rating 4.4 of 657 users Rating 4.4 of 657 users (657)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)