Благодарим ви, че изпратихте вашето запитване! Един от членовете на нашия екип ще се свърже с вас скоро.
Благодарим ви, че направихте своята резервация! Един от членовете на нашия екип ще се свърже с вас скоро.
План на курса
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
Изисквания
- 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 Часа
Oтзиви от потребители (3)
Обучителят имаше добро разбиране на концепциите
Josheel - Verizon Connect
Курс - Amazon Redshift
Машинен превод
аналитични функции
khusboo dassani - Tech Northwest Skillnet
Курс - SQL Advanced
Машинен превод
как треньорът показва своето знание по предмета, който преподава
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Курс - Data Vault: Building a Scalable Data Warehouse
Машинен превод