Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members 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
14 Hours
Testimonials (5)
That we could follow along on our remote desktops. I like to learn by trying.
Clare - BCP Council
Course - PostgreSQL Essentials
Knowledgeable and concise explanations.
Ella - BCP Council
Course - PostgreSQL Essentials
hands on exercises
Peter - BCP Council
Course - PostgreSQL Essentials
Covered a great breadth of information and Michal was brilliant with questions etc
Dominic Bryant - BCP Council
Course - PostgreSQL Essentials
Really flexible with topics and amount of work in each area to fit with our knowledge.