This course provides students with the necessary background to take advantage of Pivotal Greenplum. Participants will learn the essential skills to use the Greenplum database system. Students are introduced to fundamental concepts using the psql CLI; DDL, DML, and DQL; data loading strategies; data modeling, as well as some performance tuning strategies. Students will also learn details of the OLAP capabilities of the Greenplum database.
Describe Greenplum database features, benefits, and architecture in terms of shared nothing and the MPP design and how Greenplum database supports redundancy and high availability
Be proficient with DDL, DML, and DQL to access, manage, and query data
Implement appropriate table storage models, compression, and tablespaces
Distribute and store data in Greenplum database using a distribution key and partitioning
Understand best practices for data loading and table partitioning
Be proficient in data modeling and physical design decisions
https://www.exitcertified.com/training/pivotal/greenplum/greenplum-developer-51960-detail.htmlGP-DEVPivotal Greenplum Developerhttps://assets.exitcertified.com/assets/CourseImages/dac089e758/AdobeStock_201833011__FitMaxWzEwMDAsMTAwMF0.jpg2400.00USDInStock/Training/Pivotal/GreenplumThis course provides students with the necessary background to take advantage of Pivotal Greenplum. Participants will learn the...2400.00PivotalClassroom2017-03-15T11:39:22+00:00USD