Aspire Journeys

Developing and Deploying a Back-End Application with Node.js, Express.js and PostgreSQL

  • 22 Courses | 13h 27m 33s
  • 17 Labs | 16h 20m
This Aspire Journey will guide you through combining Node.js, Express.js, and PostgreSQL to build and deploy a back-end application! The concepts covered in this course lay the foundation for creating large real-world applications. In this Journey, you will begin by exploring the basics of asynchronous JavaScript programming, HTTP, and APIs. Then, in the second and third tracks, you learn how to leverage Node.js and Express.js to use JavaScript on the server-side. In the fourth and fifth tracks, you will explore everything about databases. The sixth track will dive deeper into PostgreSQL by covering advanced topics such as database constraints, indexes, normalization, and long-term maintenance. Finally, in the last track, you will connect a back-end to a PostgreSQL database and deploy it!

In this track of the Aspire Journey, the focus will be on gaining familiarity with asynchronous JavaScript, HTTP Requests, and APIs. The track will cover JavaScript runtime environments, asynchronous programming, HTTP requests, and API basics.

  • 6 Courses | 3h 20m 13s
  • 1 Lab | 1h

In this track of the Aspire Journey, the focus will be on gaining familiarity with back-end programming with Node.js. The track will cover Node.js basics and modular development.

  • 3 Courses | 1h
  • 2 Labs | 2h

In this track of the Aspire Journey, the focus will be on building a back-end with Express.js. The track will cover Express.js basics, routing, and middleware. The track will also cover API requests with a Postman and how to deal with CORS errors.

  • 4 Courses | 1h 24m 57s
  • 2 Labs | 1h 20m

In this track of the Aspire Journey, the focus will be on learning to work with databases. The track will cover an in-depth overview of database technologies. The track will also cover how to communicate with RDBMS using SQL.

  • 2 Courses | 1h 4m 19s
  • 5 Labs | 5h

In this track of the Aspire Journey, the focus will be on learning to design relational databases. The track will cover how to create conceptual, logical, and physical designs for a database, as well as build relationships between the data.

  • 5 Courses | 4h 54m 7s
  • 1 Lab | 1h

In this track of the Aspire Journey, the focus will be on learning advanced PostgreSQL. This track will cover how to make constraints, improve security, normalize data, use indexes, and maintain the database over time.

  • 6 Labs | 6h

In this track of the Aspire Journey, the focus will be on connecting a database to an application and then deploying it using Heroku.

  • 2 Courses | 1h 43m 57s


API Development: Introduction to APIs
Without APIs, most software would cease to exist. In this course, you'll learn about the importance of APIs and the move towards cloud-based web services. You'll explore use cases, how they are used for modeling behavior, and how to create a use case diagram. You'll then examine the differences between common API use cases and public APIs and web services that can be consumed. Next, you'll learn how to use a weather service web API and examine common API issues when developing and using APIs. You'll then explore API lifecycle management, and cloud-based APIs and their importance to developers. Lastly, you'll learn API development skills, characteristics that make a good API, and modern trends in API design.
14 videos | 2h has Assessment available Badge


Installation, Express-generator, & API
Express is a simple, yet powerful, framework for NodeJS. Learn how to use Express, including directories, components, static configuration options, and the Application, Request, and Response APIs.
12 videos | 54m has Assessment available Badge


Database Fundamentals: Database Concepts
Most businesses are unable to function without a database, even if it's just a filing cabinet. With more and more data coming from multiple sources comes an increased demand for secure and well-performing databases with adequate storage. Take this course to get a firm understanding of what exactly data means and why a database management system (DBMS) is so important for data management. Examine the origins of data and how it's stored and manipulated. Discover the different DBMS types. And learn about the roles and responsibilities involved in using a DBMS. Furthermore, find out how a DBMS can contribute to providing sound and reliable data. Navigate the MySQL Workbench to see the capabilities of an RDBMS (relational database management system) firsthand. After taking this course, you'll be able to recognize the features and capabilities of a reliable DBMS.
9 videos | 44m has Assessment available Badge


Concepts & Conceptual Design
Good database design sets the foundation for database implementation and ensures business requirements can be met. Learn how to design a database, including database modeling, the design life cycle, and requirements.
12 videos | 1h 6m has Assessment available Badge
Creating a Conceptual Design
Proper database design ensures the database will perform as expected for its users. Explore conceptual design, entities, relationships, as well as creating and integrating views into an ERD.
10 videos | 57m has Assessment available Badge
Logical Design
The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.
11 videos | 1h 17m has Assessment available Badge
Normalization Concepts & Forms
Database normalization allows you to organize data in a way that reduces redundancy and increases integrity. Learn about normalization and the normal forms in database design.
6 videos | 35m has Assessment available Badge
Logical & Physical Design
Learn about the physical database design phase, including transforming entities to tables and attributes to views, as well as implementing views and various types of indexes.
8 videos | 56m has Assessment available Badge


Connecting a Node.js and Express.js Backend with a PostgreSQL Database
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.
15 videos | 1h 3m has Assessment available Badge


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.