PostgreSQL Training - Classroom
1.995,00 EUR
- 24 hours
Master one of the most powerful open‑source relational database systems used in modern applications with our Advanced PostgreSQL Training. This comprehensive 24‑hour instructor‑led course takes you from core PostgreSQL fundamentals to advanced skills that employers value in developers, data analysts, and database professionals. Learn how relational databases work, build and manage robust databases, write complex SQL queries, and secure your data with best‑practice techniques.
Key Features
Language
Course material in English
Level
Beginner - intermediate level
24 Hours of Instructor-Led Training
50+ hours recommended study time
Hands-On Exercises through Cloud Labs
Learn To Create Applications with PostgreSQL
Ask for date confirmation!
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
PostgreSQL Fundamentals
Understand how relational databases work and their relevance in modern applications.
Comprehensive PostgreSQL Knowledge
Learn about PostgreSQL and its features as a database management system.
Installation & Setup
Gain skills to install, configure, and run queries in PostgreSQL.
Application Development
Build applications using PostgreSQL as the back-end database.
Configuration & Security
Master PostgreSQL parameters, connection settings, and security practices.
System Architecture
Explore PostgreSQL architecture, including shared memory and query processing.
Full-Stack Development with PERN
Create a full-stack web application using PostgreSQL, Express, React, and Node.js.
Course timeline
Introduction to Database Systems
Lesson 1
- Types of Databases
- Object-Relational Databases
- Introduction to PostgreSQL
- Installing PostgreSQL
Fundamentals of SQL for Postgres
Lesson 2
- Creating Databases
- Creating Tables with psql
- Creating Tables with pgAdmin
- Inserting Data into the Table
- Updating and Removing Data
- Selecting and Retrieving Data
- Altering Tables
- Aggregations and Groups
- Types of Aggregates
- Boolean Operations and WHERE Clause
- In-line Operators
- Nested Queries
Postgres Foundations
Lesson 3
- Database Objects
- Roles and Tablespace
- Database Components
- Database Views
- Database Indexes
- Database Functions
- User-defined Data Types
- Triggers and Rule System
Advanced Query Writing
Lesson 4
- Inner Joins
- Left and Right Joins
- Full Joins
- Unions
- Common Table Expressions (CTE)
- Window Functions
Postgres Security
Lesson 5
- Authentication in PostgreSQL
- Access and Security Control
- Encrypting Data
- Routine Database Maintenance
- Evaluating Queries
PERN Stack Implementation
Lesson 6
- Setting Up the PERN Stack
- Creating Connections with Prisma
- Understanding Prisma Models
- Defining Prisma Models
- Setting Up Express
- Creating POST Requests
- Testing POST Requests
- Creating GET Requests
- Creating PUT Requests
- Creating DELETE Requests
- Setting Up React
- Inputting Expense Data
- Listing Expense Data
Spring Boot Implementation
Lesson 7
- Setting Up a Spring Application
- Setting Up the PostgreSQL Connection
- Defining Schemas and Data
- Creating a Database Model (Part 1)
- Creating a Database Model (Part 2)
- Creating Repositories and Services
- Creating a Controller
- Creating a Frontend
PostgreSQL Arrays, Keys, and Select Clauses
Lesson 8
- PostgreSQL Arrays
- PostgreSQL 2D Arrays
- PostgreSQL Custom Data Types
- Key Relationships
- Defining Key Relationships
- Fetch and Limit
- Distinct and Duplicates
- Case Statements
Who Should Enroll in this Program?
Prerequisites
Participants should have a basic understanding of Node.js, React, Express and Java Spring
Aspiring Database Administrators & Developers
Software Developers & Backend Engineers
Full-Stack Developers
Data Analysts & BI Professionals
IT Professionals & System Administrators
Students & Tech Enthusiasts
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!