Administracja PostgreSQL Certificate for Marek Mulewski
Add to LinkedIn
Certificate ID:
543630
Authentication Code:
90fca
Certified Person Name:
Marek Mulewski
Trainer Name:
Michał Kuna
Duration Days:
4
Duration Hours:
28
Course Name:
Administracja PostgreSQL
Course Date:
23 April 2018 09:00 to 26 April 2018 16:00
Venue:
Gdańsk
Course Outline:
What is PostgreSQL?
- A Brief History of PostgreSQL
- Conventions
- Further Information
- Bug Reporting Guidelines
Introduction to PostgreSQL
- Installation and Creating Database
- The SQL Language
- Advanced Features
The SQL Language
- SQL Syntax
- Data Definition
- Data Manipulation
- Queries
- Data Types
- Functions and Operators
- Type Conversion
- Indexes
- Full Text Search
- Concurrency Control
- Performance Tips
Server Administration
- Installation from Source Code
- Installation from Source Code on Windows
- Server Setup and Operation
- Server Configuration
- Client Authentication
- Database Roles
- Managing Databases
- Localization
- Routine Database Maintenance Tasks
- Backup and Restore
- High Availability, Load Balancing, and Replication
- Recovery Configuration
- Monitoring Database Activity
- Monitoring Disk Usage
- Reliability and the Write-Ahead Log
- Regression Tests
Client Interfaces
- libpq - C Library
- Large Objects
- ECPG - Embedded SQL in C
- The Information Schema
Server Programming
- Extending SQL
- Triggers
- The Rule System
- Procedural Languages
- PL/pgSQL - SQL Procedural Language
- PL/Tcl - Tcl Procedural Language
- PL/Perl - Perl Procedural Language
- PL/Python - Python Procedural Language
- Server Programming Interface
Internals
- Overview of PostgreSQL Internals
- System Catalogs
- Frontend/Backend Protocol
- PostgreSQL Coding Conventions
- Native Language Support
- Writing A Procedural Language Handler
- Writing A Foreign Data Wrapper
- Genetic Query Optimizer
- Index Access Method Interface Definition
- GiST Indexes
- GIN Indexes
- Database Physical Storage
- BKI Backend Interface
- How the Planner Uses Statistics
Dedicated themes
- Brewer's CAP Theorem
- Synchronous vs Asynchronous Replication
- Log Shipping (Warm Standby)
- Streaming Master-Slave Replication (Hot Standby)
- Trigger-Based Master-Slave Replication with Slony
- Trigger-Based Multi-Master Replication with Bucardo
- Connection Pooling and Synchronous Replication with Pgpool
- Failover Configurations using DRBD
- Replacing a Failed Server
- Recovering from Network Partition
Course Name Eng:
PostgreSQL Administration