PostgreSQL Beginner to Expert - eLearning
450,00 EUR
- 20 hours
Master one of the world’s most powerful open-source relational databases with this PostgreSQL Training: Fundamentals to Advanced course. Designed for aspiring developers, data professionals, and database administrators, this hands-on program takes you from core SQL concepts all the way to advanced PostgreSQL capabilities used in real enterprise systems.
Key Features
Language
Course and material in English
Level
Beginner - Advanced level
Access
1 Year access to the learning platform
9 Hours of On-Demand Videos
with 20+ hours recommended study time
21 Hands-On Exercises
1 Project, 9 Assignments, 7 Auto-Graded Assessments
Certificate
Program completion certification included
Learning Outcomes
At the end of this Course, you will be able to understand:
Fundamental
The fundamentals of relational databases and how they operate.
Concepts
Core PostgreSQL concepts, including different types of DBMS.
Execute
How to install PostgreSQL and execute queries effectively.
Build
Building applications that use PostgreSQL as a backend database system.
Configure
Configuring PostgreSQL parameters and managing connection settings.
Overview
A high-level overview of PostgreSQL system architecture.
Course timeline
Introduction to Database Systems
Lesson 01
- Types of Databases
- Object-relational Database
- Introduction to PostgreSQL
- Installing PostgreSQL
Fundamentals of SQL for Postgres
Lesson 02
- 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 03
- 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 04
- Inner Joins
- Left and Right Joins
- Full Joins
- Unions
- Common Table Expressions (CTE)
- Window Functions
Postgres Security
Lesson 05
- Authentication in PostgreSQL
- Access and Security Control
- Encrypting Data
- Routine Database Maintenance
- Evaluating Queries
PERN Stack Implementation
Lesson 06
- Setting up the PERN stack
- Connecting to the database using Prisma
- Understanding and defining Prisma models
- Configuring Express backend
- Creating and testing CRUD APIs (POST, GET, PUT, DELETE)
- Setting up the React frontend
- Building expense input functionality
- Displaying and managing expense data in React
Spring Boot Implementation
Lesson 07
- Setting up a Spring application
- Configuring PostgreSQL connection
- Defining schemas and data structure
- Creating database models
- Building repositories and services
- Developing controllers
- Creating the frontend applicationConfiguring Swagger UI
- Customizing API Info
PostgreSQL Arrays, Keys, and Select Clauses
Lesson 08
- PostgreSQL Arrays
- PostgreSQL 2D Arrays
- PostgreSQL Custom Data Types
- Key Relationships
- Defining Key Relationships
- Fetch and Limit
- Distinct and Duplicates
- Case Statements
Capstone
Lesson 08
Build an Interactive Application With a DBMS
Who Should Enroll in This Program?
Data Analysts and Data Engineers
Software Developers (Backend / Full Stack)
Database Administrators (DBAs)
Web Developers working with APIs and databases
IT Professionals transitioning into data or backend roles
Students or fresh graduates aiming to build database expertise
Prerequisites
- Basic understanding of SQL fundamentals
- Familiarity with database concepts (tables, rows, columns)
- General awareness of how web applications work (helpful but not mandatory)
- (Optional but beneficial) Exposure to programming concepts in JavaScript or Java for application modules
Statements
Licensing and accreditation
This 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 Questions
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!