Vielen Dank für die Zusendung Ihrer Anfrage! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
Vielen Dank, dass Sie Ihre Buchung abgeschickt haben! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
Schulungsübersicht
Greenplum Architecture
- Parallel processing and symmetric multi-processing
- Segment roles and cluster configuration
- Scalability 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
- Skew handling and performance impact
- Hash maps and row placement strategies
Indexes and Performance Optimization
- Clustered and non-clustered indexes
- B-tree and bitmap index use cases
- Index scan and storage behavior
Physical Database Design
- Normalization and logical model design
- User access strategies and distribution analysis
- Data demographics and indexing decisions
Denormalization Techniques
- Derived data, summary tables, and pre-joins
- Columnar tables as vertical partitioning
- Data marts and materialized views
Advanced SQL and Query Execution
- Join strategies and 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 optimization
- Join movement and segment-local operations
Greenplum Utilities and Best Practices
- ANALYZE and VACUUM
- Data loading and movement with Nexus
- Security, permissions, and performance tips
Summary and Next Steps
Voraussetzungen
- An understanding of relational databases and SQL
- 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
21 Stunden
Erfahrungsberichte (3)
Der Trainer hatte ein gutes Verständnis für die Konzepte
Josheel - Verizon Connect
Kurs - Amazon Redshift
Maschinelle Übersetzung
analytische Funktionen
khusboo dassani - Tech Northwest Skillnet
Kurs - SQL Advanced
Maschinelle Übersetzung
wie der Trainer sein Wissen im Unterrichtsthema zeigt
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Kurs - Data Vault: Building a Scalable Data Warehouse
Maschinelle Übersetzung
