Database systems are a key component to most modern applications. You can use a variety of such systems to store data efficiently and effectively. PostgreSQL is a diverse and powerful database system, designed to give you the tools required to manage and analyze your data. In this course, you will explore various methods of building databases in PostgreSQL.
You will get an understanding of PostgreSQL infrastructure, how SQL interacts with PostgreSQL objects, as well as how to secure and maintain your database systems. Once you have a grasp on the fundamentals of PostgreSQL, you will see how to create full stack applications using PERN stack and Java Spring, which interact with a PostgreSQL database. By the end of this course, you will feel comfortable working with PostgreSQL through psql, pgAdmin, and various tech stacks.

Who Should Attend This Course

• Software Developers
• Full-Stack Developers
• Data Analysts
• Database Administrators

What You Will Learn

• Fundamentals of PostgreSQL
  Learn how relational databases work, their fundamentals and how they are relevant in today’s times
• Understanding PostgreSQL
  Learn everything about PostgreSQL, including the type of database management system it is.
• Installation
  Build the necessary skills to understand how to install and setup PostgreSQL and run queries on it
• Create Applications
  Understand how to create applications with PostgreSQL as a back-end database management system
• Configuration
  Build skills to understand the Setting PostgreSQL Parameters, Connection Settings, and Security and Authentication
• PostgreSQL System Architecture
  Understand the architectural summary of PostgreSQL system, including shared memory and statement processing
• PERN Stack
  Build a full-stack web application using the PERN (PostgreSQL, Express, React and Node.js) Stack

Skills You Will Gain

• Running queries to create tables
• Updating and deleting data
• Performing calculations on data
• Constructing database objects
• Applying common table expressions
• Maintaining a database
• Analyzing query efficiency
• Building PERN stack applications
• Building Spring apps with PostgreSQL

During this 24-hour course, a variety of topics will be covered with the aim of making you a PostgreSQL expert.
The following are the practical skills you’ll gain on course completion:

• Understand how PostgreSQL functions as a database system
• Understand the fundamentals of object relational databases
• Create databases and tables
• Learn to manage data in tables
• Learn to analyze data in tables
• Create and manage database objects such as views, functions, indexes, user-defined types and rules
• Create advanced queries with joins, unions, common table expressions, and window functions
• Manage the security, access control, and maintenance of a PostgreSQL database
• Develop a basic PERN stack application
• Learn to use PostgreSQL with Java Spring applications

We provide the course in English.