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.
Course Outline
Greenplum Architecture for Government
- Parallel processing and symmetric multi-processing capabilities
- Segment roles and cluster configuration options
- Scalability features and data movement strategies
- Greenplum Data Warehouse architecture design
Greenplum Table Structures for Government
- Distributed versus randomly assigned tables
- Heap versus append-only table types
- Row versus columnar storage formats
- Partitioned and clustered table configurations
Data Distribution and Hashing for Government
- Hashing logic and distribution key selection
- Skew management and its impact on performance
- Hash maps and row placement strategies
Indexes and Performance Optimization for Government
- Clustered and non-clustered index types
- B-tree and bitmap index use cases
- Index scan operations and storage behavior
Physical Database Design for Government
- Normalization techniques and logical model design
- User access strategies and distribution analysis
- Data demographics and indexing decision-making processes
Denormalization Techniques for Government
- Derived data, summary tables, and pre-join operations
- Columnar tables as a method of vertical partitioning
- Data marts and materialized views implementation
Advanced SQL and Query Execution for Government
- Join strategies and data redistribution methods
- OLAP capabilities and window functions
- Temporary tables, subqueries, and derived table usage
EXPLAIN Plans and Query Tuning for Government
- Reading and interpreting EXPLAIN output results
- Cost analysis techniques and plan optimization strategies
- Join movement and segment-local operation considerations
Greenplum Utilities and Best Practices for Government
- ANALYZE and VACUUM operations
- Data loading and movement using Nexus tools
- Security measures, permissions management, and performance optimization tips
Summary and Next Steps for Government
Requirements
- A comprehensive understanding of relational databases and SQL
- Practical experience with data warehousing or analytical systems
- Proficiency in Linux command line operations
Audience for Government
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists working with Greenplum
21 Hours
Testimonials (1)
the practices