PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.
Course Information:
Course Number: -PG900DEV
Delivery Method: CertCamps,Virtual Live Instructor Led Training,Customer Onsite Training,Classroom Training,
Duration: 4 Days
Pre-Requisite:
- Basic Structured Programming Knowledge or experience
- Linux or Windows OS
- PostgreSQL basics and/or SQL basics
Become a Certified PostgreSQL Developer by attending CertFirst's Instructor-led extensive hands-on CPSDBD training & certification program. Candidates must pass the certification exam in order to successfully complete the certification requirements.
Attend CertFirst CPSDBD training + Pass the Certification Exam = Certified PostgreSQL Database Developer
Course Description:
Getting Started with PostgreSQL: Basic Development
- Writing Queries using psql
- Creating, Altering and Truncating a Table
- Inserting, Deleting, and Updating Data from the Tables
- Data Types, Operators, and Usage
- PostgreSQL Constraints
- The Procedural Language: PL/pgSQL
- Working with Indexes
- Triggers & Rules
- Window Functions
- Interface Details (.Net, DBI, etc.)
- Statement behavior
- Optimization
- Partitioning
- PostgreSQL Large Objects
- Foreign Data Wrappers
- PostgreSQL Using LibPQ
- Extensions
- Database Developers
- Database Administrators
- Database Architects
Customized Group Training (Your site or ours)
- Experienced & certified trainers
- Hands-on training
- Exclusive lab access
Virtual Live
- Live Instructor Led
- Online Webex Based
- Interavtice Classes
- Certified Trainers
Classroom Training
- Customize your training according to your needs
- Save as much as 50%
- 50+CertCamp Locations Worldwide
