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.
課程簡介
介紹
設置 Pivotal Greenplum
Pivotal Greenplum功能和架構概述
Access 數據
- DDL、DML 和 DQL
實現表存儲模型
- 瞭解表空間
- 壓縮表數據
分發數據
- 分佈鍵和分區
- 管理聯接和索引
載入數據
- 表分區
OLAP 查詢
- 實現Greenplum函數
對數據進行建模
- 物理設計注意事項
擴展系統
- 添加節點
- 遷移數據
監控Greenplum系統
- Database 活動和績效
性能調優
- 優化查詢
- 優化 SQL 聯接
- 索引優化
Greenplum最佳實踐
故障排除
總結和結論
最低要求
- 了解資料庫概念。
觀眾
- 開發人員
21 時間:
客戶評論 (2)
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.