PostgreSQL for the SQL Server Professional on April 2 - 3, 2025
Key Concepts Covered in this Course
- Comparing PostgreSQL to SQL Server
- PostgreSQL Query Tuning
- Multi Version Concurrency Control
- High Availability Options & Backup Strategies
Klaus Aschenbrenner
Microsoft Certified Master for SQL Server
I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.
Since 2012 I’m also a Microsoft Certified Master for SQL Server.
Elevate Your Skills with My Exclusive Online Training Course!
Are you a SQL Server professional looking to expand your expertise and unlock the full potential of PostgreSQL? My live training is specifically designed to bridge the gap, diving deep into the critical differences between PostgreSQL and SQL Server.
Learn how to adapt your SQL Server knowledge to PostgreSQL seamlessly, optimize performance, and leverage PostgreSQL’s unique features to enhance your database management skills. Join me to gain the confidence and insights needed to efficiently work with PostgreSQL in any environment!
Amazing Course
“In this workshop Klaus manages to cover everything you need to know about how to expand your SQL Server knowledge to PostgreSQL. With real-life examples it also becomes easy to follow. I would highly recommend this course to every SQL Server DBA or developer who wants to learn more about PostgreSQL.”
Valerie from Amsterdam, Netherlands
Course Details
Course Duration
2 Days
Course Price
EUR 1790 incl. 20% VAT
Course Level
Intermediate
Agenda & Breakdown
Day 1 – PostgreSQL Fundamentals
- 🌐 PostgreSQL Architecture
- Overview
- Comparison to SQL Server
- Installation & Configuration
- Memory Subsystem
- File System Layout
- Query Processing Basics
- ✨ Working with Query Plans
- Overview
- Estimated vs. Actual Query Plan
- Query Plan Analysis
- Statistics
- 🎓 Data Access Methods & Indexes
- Overview
- B-Tree Indexes
- Hash Indexes
- GiST/SP-GiST Indexes
- GIN, RUM, BRIN Indexes
- Index Tuning Strategies
Day 2 – PostgreSQL Advanced Concepts
- 🌐 Multi Version Concurrency Control
- Overview
- Consistency Problems
- Supported Isolation Levels
- Dealing with Table Bloat
- Vacuum & Autovacuum Operations
- Monitoring
- 🚀 Write Ahead Logging
- Overview
- Transactions
- Write Ahead Log
- Write Ahead Logging Modes
- ✨High Availability & Disaster Recovery
- Overview
- Backup & Restore Operations
- Physical Replication
- Connection Pooling
This 2 day ong webinar is primarily for SQL Server Professionals who want to learn how to run PostgreSQL.
Date & Location
April 2 – 3, 2025
EUR 1790 incl. 20% VAT
Cancellation Fee: 100%
Course Language: English
Location: Online Live Class from 09:00am to 05:00pm (Microsoft Teams)
🔐 Secure Your Spot Today!
Don’t miss this opportunity to elevate your PostgreSQL skills and become a PostgreSQL expert. Secure your spot now and embark on a transformative learning journey!
