Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
- Introduction
- System Architecture and Internals
- Process Architecture
- Memory Internals
- Storage Architecture
- Installations
- Downloading PostgreSQL
- Preparing System for Installation
- Install PostgreSQL
- Create, Start, Stop a Database Server
- Viewing Information
- PSQL Tool
- Connecting to a Database
- Executing SQL
- psql Meta Commands
- PGAdmin4
- Connecting to a Database
- Basic Tasks using GUI
- Database Designing
- Database Users
- Creating and Managing Databases
- Schemas
- Tables
- Data Types
- Sequences
- Views
- Materialized Views
- Database Backups
- Logical or SQL Dump Backups
- Physical Backups - Offline
- Physical Backups - Online
- Archiving
- Restoring Backups
- Restoring SQL Dumps
- Restoring Offline Backups
- Point in Time Recovery
- Partial Restore
- Proactive Maintenance
- Database Statistics
- Data Fragmentation and Vacuuming
- Data Re-organization
- Automatic Maintenance Configuration
- Re-indexing
- System Parameters
- Parameter File
- Changing Server Parameters
- Resource Parameters
- Planner Parameters
- Logging Parameters
- Transaction Logging Parameters
Requirements
There are no specific requirements needed to attend this course. It is recommended to start with this training if you have never taken a formal training of PostgreSQL
Testimonials
Really flexible with topics and amount of work in each area to fit with our knowledge.
Andy Kerslake - HM Land Registry
Lots of hands on exercises and real life examples
Sam Inglis - HM Land Registry
Michal was a very good trainer. On the course I attended we all had different levels of experience with PostgreSQL, but he managed to teach at the right level that meant those with less experience could keep up and did not make it dull or useless for those with more experience.
HM Land Registry
Mix of classroom style tuition and hands-on practical exercises
HM Land Registry
Trainer was very helpful and style of doing exercises together was great
Mark Wyatt - Services Australia
I liked Michal's approach to ensuring that everyone was involved on exercises. Obviouslyi this would present challenges given the remote training scenario, but I think he did this in a far more effective manner than other trainers I've had recently on other courses.
Services Australia
The trainer scribbling on the pages to provide extra illustration, making the learning easier. It is unusual but effective.
Services Australia
The hands on practical parts of the training were engaging, I tended to lose a little interest if there was too much talking.
Bob Burt - Services Australia
I liked that we got hands on experience with exercises in the Virtual Desktop, rather than just purely listening to a presentation. The trainer was great - very understanding and helpful when one of us was lost.
Cruise Speck - Services Australia
Related Courses
PostgreSQL for Developers
14 hours
PostgreSQL Advanced DBA
14 hours
PostgreSQL Performance Tuning
14 hours
PostgreSQL with Python
21 hours
Data Management
35 hours
SAP ASE for Database Administrators
28 hours
Pivotal Greenplum for Developers
21 hours
MarkLogic Server
14 hours