PostgreSQL for Data Analytics and Business Intelligence
Get 20% discount when you register as a team of 3 or more!

DATES

Start :2025-08-11End  :2025-08-15

DURATION

5 days, Mon - Fri8:30 am - 4:30 pm

CHARGES

$850 + 16% VATFlexible payment

Registration

APPLY

Course description

This course provides a thorough introduction to PostgreSQL, one of the most powerful open-source relational database management systems. Participants will learn to install and configure PostgreSQL and pgAdmin, create and manage databases and tables, and perform data manipulation tasks including insertion, updating, and deletion. The course covers essential SQL operations such as querying, filtering, and joining data, as well as advanced topics like user-defined functions, constraints, sequences, and aggregate functions.
Additionally, learners will explore views, transactions, and data import / export techniques to manage and interact with their data effectively. Through practical exercises and real-world examples, this course equips participants with the skills needed to leverage PostgreSQL for robust data management and analysis.

Learning outcomes

This course equips you with core Python programming skills and data-driven problem-solving techniques essential for analytics and software development. By the end, you will be able to:
  • Learn to install PostgreSQL and configure the pgAdmin 4 client for effective database management.
  • Understand how to create, modify, and drop databases and tables, including setting up user permissions and handling foreign keys.
  • Gain proficiency in inserting, updating, deleting, and querying data using various SQL commands and functions.
  • Explore PostgreSQL data types, conversion techniques, and how to use them effectively in table design and queries.
  • Learn to apply and manage constraints (e.g., primary keys, foreign keys) and sequences for data integrity and auto-incrementing values.
  • Develop skills in complex SQL operations such as joins, subqueries, and aggregate functions to analyze and manipulate data.
  • Understand how to create, update, and use views, including materialized views, to simplify data access and enhance query performance.
  • Master transaction management, including commit and rollback, and learn to export and import data for effective data transfer and backup.

Course Outline

5 days | Monday - Friday
MODULE 1: Introduction to PostgreSQL
MODULE 2: Creating and Modifying Tables
MODULE 3: Inserting, Updating, and Deleting Data
MODULE 4: Querying Data with SELECT
MODULE 5: Filtering Data with WHERE and Logical Conditions
MODULE 6: Understanding Data Types and Type Conversion
MODULE 7: Working with Constraints in PostgreSQL
MODULE 8: Using Sequences for Auto-Incrementing Values
MODULE 9: Working with String Functions
MODULE 10: Using Aggregate Functions
MODULE 11: Joining Tables
MODULE 12: Using Subqueries
MODULE 13: Creating and Managing Views
MODULE 14: Exporting and Importing Data

FAQs

Frequently Asked Questions
Program fees and what's included
Do you offer online training options?
Is a self-paced learning model available?
What does the learning experience include?
What certification will I receive?
What are the technical requirements?
What is your refund policy?
Early registrations are encouraged.
Flexible payment options are available.
Start : 2025-08-11
End  : 2025-08-15
APPLY NOW