Greenplum Architecture, Administration, and Implementation培訓(xùn)課程

課程大綱：

1. Greenplum Fundamental Concepts

• Basics of Data Warehousing
• Greenplum Concepts, Features, and Benefits
• Greenplum Architecture
  • Shared Nothing and MPP Implementation

2. Database Installation and Initialization

• Systems Preparation and Verification
• Greenplum Database Initialization

3. Greenplum Database Tools, Utilities, and Internals

• PSQL Client and Greenplum Utilities
• Greenplum Performance Monitor
• Greenplum Database Server Configuration
• Greenplum Database Internals

4. Defining and Securing the User Database

• Data Definition Language
• Data Manipulation and Data Query Language
• Roles, Privileges, and Resources

5. Data Loading and Distribution

• Data Loading
• Table Partitioning

6. Database Management and Archiving

• Managing the Greenplum Database
• Backup and Restores

7. Data Modeling and Design

• Data Modeling
• Physical Design Decisions

8. Performance Analysis and Tuning

• JOIN Tables
  • Types and Methods
• Database Tuning
• EXPLAIN Plan
  • Analyzing Queries
• Improve Performance with Statistics
• Indexing Strategies

9. Developing Reports Using Advanced SQL

• Advanced Reporting Using Online Analytic Processing (OLAP)
• PostgreSQL Functions
• Advanced SQL Topics and Performance Tips

如果您想學(xué)習(xí)本課程，請(qǐng)預(yù)約報(bào)名
如果沒找到合適的課程或有特殊培訓(xùn)需求，請(qǐng)訂制培訓(xùn)
除培訓(xùn)外，同時(shí)提供相關(guān)技術(shù)咨詢與技術(shù)支持服務(wù)，有需求請(qǐng)發(fā)需求表到郵箱soft@info-soft.cn,或致電4007991916
技術(shù)服務(wù)需求表點(diǎn)擊在線申請(qǐng)

服務(wù)特點(diǎn)：
海量專家資源，精準(zhǔn)匹配相關(guān)行業(yè)，相關(guān)項(xiàng)目專家，針對(duì)實(shí)際需求，顧問式咨詢，互動(dòng)式授課，案例教學(xué)，小班授課，實(shí)際項(xiàng)目演示，快捷高效，省時(shí)省力省錢。

專家力量：
中國科學(xué)院軟件研究所，計(jì)算研究所高級(jí)研究人員
oracle,微軟，vmware，MSC,Ansys，candence,Altium,達(dá)索等大型公司高級(jí)工程師，項(xiàng)目經(jīng)理，技術(shù)支持專家
中科信軟培訓(xùn)中心，資深專家或講師
大多名牌大學(xué)，碩士以上學(xué)歷，相關(guān)技術(shù)專業(yè)，理論素養(yǎng)豐富
多年實(shí)際項(xiàng)目經(jīng)歷，大型項(xiàng)目實(shí)戰(zhàn)案例，熱情，樂于技術(shù)分享
針對(duì)客戶實(shí)際需求，案例教學(xué)，互動(dòng)式溝通，學(xué)有所獲

 點(diǎn)擊進(jìn)入報(bào)名表

咨詢電話：010-62883247

                4007991916

咨詢郵箱：soft@info-soft.cn  

 

微信咨詢 隨時(shí)聽講課 聚焦技術(shù)實(shí)踐