Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Greenplum Architecture
- Parallel processing and symmetric multi-processing.
- Segment roles and cluster configuration.
- Scalability mechanisms and data movement.
- Greenplum Data Warehouse architecture.
Greenplum Table Structures
- Distributed vs. randomly assigned tables.
- Heap vs. append-only tables.
- Row vs. columnar storage formats.
- Partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and distribution keys.
- Managing skew and its impact on performance.
- Hash maps and row placement strategies.
Indexes and Performance Optimisation
- Clustered and non-clustered indexes.
- B-tree and bitmap index use cases.
- Index scans and storage behaviour.
Physical Database Design
- Normalisation and logical model design.
- User access strategies and distribution analysis.
- Data demographics and indexing decisions.
Denormalisation Techniques
- Derived data, summary tables, and pre-joins.
- Columnar tables as vertical partitioning.
- Data marts and materialised views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- OLAP and window functions.
- Temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output.
- Cost analysis and plan optimisation.
- Join movement and segment-local operations.
Greenplum Utilities and Best Practices
- ANALYZE and VACUUM operations.
- Data loading and movement with Nexus.
- Security, permissions, and performance tips.
Summary and Next Steps
Requirements
- A solid grasp of relational databases and SQL.
- Practical experience with data warehousing or analytical systems.
- Familiarity with Linux command-line operations.
Audience
- Data architects and engineers.
- Database administrators and technical leads.
- BI developers and analytics specialists working with Greenplum.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £4800 + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
the practices