Pivotal Greenplum Developer
Pluralsight
Course Summary
Take advantage of Pivotal Greenplum. Participants will learn the essential skills to use the database system.
-
+
Course Description
This course is intended for developers responsible for designing and developing the Greenplum data warehouse. The course introduces 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 Pivotal Greenplum. This course includes all self-paced videos, lab instructions, and lab installers (located "Exercise Files" tab upon enrolling). Lab exercises are self-paced and in addition to the total duration of the course. Ready to prove your skills? Enroll in the Pivotal Greenplum Developer Certification Exam and checkout the complete portfolio of Pivotal Greenplum training offerings by visiting pivotal.io/training.
-
+
Course Syllabus
Overview, Requirements, and Setup- 15m 2s
—Introduction 15m 2spsql and Utilities- 19m 15s
—psql CLI Utility 19m 15sDefining and Securing the Database- 58m 23sData Loading and Distribution- 1h 18mData Modeling and Design- 47m 10sPerformance Analysis and Tuning- 2h 1mOLAP, Window Functions, UDF- 1h 29mFinal Items- 12m 59s