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 Fundamentals
- Parallel processing mechanisms and symmetric multi-processing
- The role of segments and cluster configuration strategies
- Scalability principles and data movement dynamics
- Understanding the Greenplum Data Warehouse structure
Greenplum Table Structures
- Comparing distributed tables versus randomly assigned tables
- Differences between heap tables and append-optimized tables
- Selecting between row-oriented and columnar storage formats
- Managing partitioned and clustered table designs
Data Distribution and Hashing Mechanics
- Hashing logic and the definition of distribution keys
- Managing data skew and its impact on performance
- Utilizing hash maps and row placement strategies
Indexing and Performance Enhancement
- Distinctions between clustered and non-clustered indexes
- Application scenarios for B-tree and bitmap indexes
- Behavior of index scans and storage interactions
Physical Database Design Principles
- Applying normalization and logical model design
- Developing user access strategies and distribution analyses
- Making informed indexing decisions based on data demographics
Denormalization Strategies
- Using derived data, summary tables, and pre-joined data
- Leveraging columnar tables as a form of vertical partitioning
- Implementing data marts and materialized views
Advanced SQL and Query Execution
- Optimizing join strategies and data redistribution
- Utilizing OLAP capabilities and window functions
- Working with temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and analyzing EXPLAIN output effectively
- Conducting cost analysis and plan refinement
- Managing join movement and segment-local operations
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM maintenance tasks
- Facilitating data loading and movement using Nexus
- Addressing security, permissions, and performance optimization tips
Course Summary and Future Directions
Requirements
- A solid grasp of relational database concepts and SQL fundamentals
- Prior exposure to data warehousing solutions or analytical systems
- Proficiency with Linux command-line interfaces
Intended Audience
- Data architects and engineering professionals
- Database administrators and technical leadership
- BI developers and analytics specialists working within Greenplum ecosystems
Testimonials (1)
the practices