Course Outline
- Introduction<\/strong><\/li>
- System Architecture and Internals <\/strong>
- Process Architecture<\/li>
- Memory Internals<\/li>
- Storage Architecture<\/li><\/ul><\/li>
- Installations<\/strong>
- Downloading PostgreSQL<\/li>
- Preparing System for Installation<\/li>
- Install PostgreSQL<\/li>
- Create, Start, Stop a Database Server<\/li>
- Viewing Information<\/li><\/ul><\/li>
- PSQL Tool<\/strong>
- Connecting to a Database<\/li>
- Executing SQL<\/li>
- psql Meta Commands<\/li><\/ul><\/li>
- PGAdmin4<\/strong>
- Connecting to a Database<\/li>
- Basic Tasks using GUI<\/li><\/ul><\/li>
- Database Designing<\/strong>
- Database Users<\/li>
- Creating and Managing Databases<\/li>
- Schemas<\/li>
- Tables<\/li>
- Data Types<\/li>
- Sequences<\/li>
- Views<\/li>
- Materialized Views<\/li><\/ul><\/li>
- Database Backups <\/strong>
- Logical or SQL Dump Backups<\/li>
- Physical Backups - Offline<\/li>
- Physical Backups - Online<\/li>
- Archiving<\/li><\/ul><\/li>
- Restoring Backups<\/strong>
- Restoring SQL Dumps<\/li>
- Restoring Offline Backups<\/li>
- Point in Time Recovery<\/li>
- Partial Restore<\/li><\/ul><\/li>
- Proactive Maintenance <\/strong>
- Database Statistics<\/li>
- Data Fragmentation and Vacuuming<\/li>
- Data Re-organization<\/li>
- Automatic Maintenance Configuration<\/li>
- Re-indexing<\/li><\/ul><\/li>
- System Parameters<\/strong>
- Parameter File<\/li>
- Changing Server Parameters<\/li>
- Resource Parameters<\/li>
- Planner Parameters<\/li>
- Logging Parameters<\/li>
- Transaction Logging Parameters<\/li><\/ul><\/li><\/ul>
- System Architecture and Internals <\/strong>
Requirements
There are no specific prerequisites for attending this course. It is particularly recommended for individuals who have not yet undertaken formal PostgreSQL training. <\/p>
Testimonials (7)
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.
Andy Kerslake - HM Land Registry
Course - PostgreSQL Essentials
Lots of hands on exercises and real life examples
Sam Inglis - HM Land Registry
Course - PostgreSQL Essentials
Trainer was very helpful and style of doing exercises together was great
