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: -PG100
Delivery Method: CertCamps,Virtual Live Instructor Led Training,Customer Onsite Training,Classroom Training,
Duration: 1 Day
Pre-Requisite:
Basic SQL & Linux OS
Target Audience:
Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in joining the DBA world!
CertFirst offers a basic 1-day virtual live instructor or classroom Instructor-led training. The program covers the introduction & installation topics as part of the blended learning program
Course Description:
1. Installing PostgreSQL
- Compiling and Installing PostgreSQL on Linux/Unix
- Post-Installation Setup
- The PostgreSQL Windows Installer
2. Creating a Database and Testing the Server
- Initializing a Cluster
- Creating a Database
- Starting the Database Server
- The psql Client
- Startup Failures and Client Connection Problems
Delivery Methods
OnSite training (Your Site or Ours)
- Live Instructor Led
- Carry your own Laptop
- Handson Training Labs
- Certified Trainers
Virtual Live
- Live Instructor Led
- Online Webex Based
- Interavtice Classes
- Certified Trainers
Class-room Training
- Classroom Training
- Live Instructor Led
- Courseware & Hand-on Labs
- Certified Trainers & easy Q&A
