Analytics Accelerator Learning Paths

Analytics Accelerator Learning Paths#

Use these learning paths to build knowledge progressively — from foundational concepts to advanced implementations and optimization techniques.

How to use these learning paths#

Select the level that matches your current knowledge and goals. Each level links to curated guides with conceptual explanations, how-to articles, and practical tutorials.

For advanced topics and certification, explore official EDB training programs.

---

Learning path levels#

Level 101: Foundations of the Analytics Accelerator#

Target audience: Users new to the Analytics Accelerator, those new to modern data analytics concepts, or users seeking a refresher.

Focus: Core ideas, key terminology, the Analytics Accelerator landscape, and reasons behind analytical approaches.

What you will learn:

  • Fundamental concepts of data warehouses, data lakes, and the lakehouse paradigm

  • Key terms such as columnar storage, vectorized query engines, and open table formats (Apache Iceberg, Delta Lake)

  • Overview of the Analytics Accelerator vision with Postgres and core solutions such as EDB Postgres Lakehouse

  • Benefits of separating storage and compute for analytics

Start here: Analytics Generic Concepts

---

Level 201: Applying the Analytics Accelerator — core technologies and use cases#

Target audience: Users with foundational knowledge ready to apply core technologies practically. Suitable for DBAs, data engineers, and developers.

Focus: Hands-on use of EDB Postgres Lakehouse, PGD analytics (including Tiered Tables), and Iceberg/Delta Lake integration. Basic use cases and configurations.

What you will learn:

  • Set up and query EDB Postgres Lakehouse clusters

  • Work with Apache Iceberg and Delta Lake tables

  • Implement basic Tiered Table configurations using EDB Postgres Distributed (PGD)

  • Connect BI tools to the Analytics Accelerator

  • Apply analytics to BI reporting, historical data analysis, and operational analytics

Continue your journey: Analytics Accelerator Concepts + How-to guides

---

Level 301: Advanced Analytics Accelerator, optimization, and architecture#

Target audience: Experienced users, architects, and senior engineers.

Focus: Advanced features, performance tuning, complex architectures, scalability, security, and troubleshooting.

What you will learn:

  • Advanced configuration of EDB Postgres Lakehouse, PGAA, and PGFS

  • Performance tuning for vectorized queries and object storage access

  • Design and implement complex Tiered Table strategies with PGD for optimal cost and performance

  • Manage advanced Iceberg catalogs and integrate third-party catalogs

  • Architect solutions combining the Analytics Accelerator with other data frameworks (Spark, streaming platforms)

  • Troubleshoot complex analytical query performance and data pipelines

  • Apply security best practices for analytical environments

Advance your expertise: See Analytics Accelerator Architecture and PGAA functions reference

---

EDB training and certification#

For expert-led instruction and official certification, explore EDB’s training programs and certifications.

---

Additional guidance#

---

Next steps#

Use these learning paths to progress your Analytics Accelerator expertise — from foundational knowledge to advanced optimization and architecture.

Contents