SQL for PostgreSQL - 3 days Online Classroom
1.950,00 EUR
- 3 days
Build a strong foundation in SQL and learn how to work effectively with PostgreSQL, one of the world's most powerful and widely used open-source relational databases. This hands-on course teaches the essential SQL skills needed to query, analyze, manipulate, and manage data in PostgreSQL environments.
Key Features
Language
Course material in English
Level
Beginner - Intermediate level
3 days (8 hours/day) online instructor-led
40+ recommended study hours
Access to virtual live labs
All relevant course materials
Ask for date confirmation!
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Data Retrieval and Analysis
Learn to build effective SQL queries using SELECT statements, filters, sorting, calculations, and aggregate functions to retrieve, organize, and summarize data.
Data Transformation with Functions
Use PostgreSQL's numeric, string, and date functions to manipulate data, perform type conversions, and handle NULL values efficiently with CASE, COALESCE, and NULLIF.
Database Design and Optimization
Create and manage tables, constraints, indexes, and views to ensure data integrity, improve query performance, and simplify database management.
Course timeline
Day 1
Session 1: Relational Database Concepts
- PostgreSQL fundamentals and database architecture
- Tables, rows, columns, keys, and indexes
- Data types and the data dictionary
Session 2: Using psql
- PostgreSQL command-line interface
- Executing and managing SQL statements and scripts
Session 3: Retrieving Data with SELECT
- SELECT queries and data retrieval
- Filtering, sorting, aliases, and expressions
- Conditional and logical operators
Session 4: Aggregate Functions
- Aggregate functions and data summarization
- GROUP BY and HAVING clauses
Session 5: Joining Tables
- Inner, outer, and self joins
- Table aliases and ANSI-standard joins
Session 6: Subqueries and Set Operators
- Subqueries and nested queries
- UNION, INTERSECT, and EXCEPT operators
Day 2
Session 7: Numeric, Character, and Date Functions
- Numeric and string functions
- String manipulation and concatenation
- Date functions and date arithmetic
Session 8: Conversion and Utility Functions
- Data type conversion
- CASE expressions
- COALESCE and NULLIF functions
Session 9: Complex Subqueries
- Advanced subquery techniques
- Inline views and correlated subqueries
- Multi-column subqueries and join integration
Day 3
Session 10: Managing Data
- Inserting, updating, and deleting data
- Transactions, commits, rollbacks, and savepoints
- CSV data import and export
- Data management with pgAdmin 4
Session 11: Managing Tables
- Creating and modifying tables
- Managing constraints
- Copying and recovering tables
Session 12: Managing Indexes and Views
- Creating and managing indexes
- Creating, using, and maintaining views
Session 13: Managing Sequences
- Creating sequences
- Viewing and managing sequence properties
Who Should Enroll in this Program?
Database Administrators (DBAs)
Data Analysts
Business Intelligence Professionals
Software Developers
Data Engineers
Report Writers and Business Users working with data
Prerequisites
- Basic computer literacy
- Familiarity with using business applications
- General understanding of data and information management concepts
- Previous database experience is helpful but not required
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!