Analytics Accelerator 301 Advanced techniques and optimization
==============================================================

For experienced users, architects, and engineers ready to deepen their
expertise with advanced optimization and architecture patterns.

What you will learn
-------------------

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

- Performance tuning for vectorized queries and object storage access

- Complex tiered table strategies for optimized cost and performance

- Managing advanced Iceberg catalogs and integrating third-party
  catalogs

- Architecting solutions that combine Analytics Accelerator with other
  data frameworks (Spark, streaming platforms)

- Troubleshooting complex analytical queries and data pipelines

- Security best practices for analytics environments

Before you begin
----------------

- :ref:`Analytics Accelerator 201 Practical application and core solutions <Analytics Accelerator 201 Practical application and core solutions>`  

- :ref:`Analytics Accelerator Concepts <Analytics Accelerator Concepts>`  

- :ref:`Tiered Tables With Analytics Accelerator <Tiered Tables With Analytics Accelerator>`  

Suggested learning path
-----------------------

1. :ref:`Analytics Accelerator Architecture <Analytics Accelerator Architecture>` 

2. :ref:`Apache Iceberg Integration With Analytics Accelerator <Apache Iceberg Integration With Analytics Accelerator>` 

3. :ref:`Delta Lake Integration with Analytics Accelerator <Delta Lake Integration with Analytics Accelerator>` 

4. :ref:`DirectScan and fallback modes <DirectScan and fallback modes>` 

5. :ref:`PGAA functions reference <PGAA functions reference>` 

6. :ref:`PGAA functions reference <PGAA functions reference>` 

7. :ref:`Benchmarking datasets <Benchmarking datasets>` 

8. :ref:`User management <User management>` 

9. :ref:`Analytics Accelerator for your role a persona-based guide <Analytics Accelerator for your role a persona-based guide>` 

Next steps
----------

Consider official training and certification:

- :ref:`EDB training and certification <EDB training and certification>`