Visão Geral

Objetivo

 Após realizar este Curso PostgreSQL for Developers and Administrators, você será capaz de:

• Encontre documentação e recursos do PostgreSQL
• Trabalhe com funções PostgreSQL
• Crie suas próprias funções
• Programa com PL / pgSQL
• Instale e configure o PostgreSQL com segurança
• Trabalhe com tarefas básicas de administração, como criação de usuário, catalogação e backup
• Use SLONY e PGPOOL
• Trabalho com herança em PostgreSQL
• Tabelas de partição
• Use Tablespaces
• Monitore o banco de dados
• Use a declaração EXPLAIN
• Use PITR
• Ajuste o servidor PostgreSQL

Pre-Requisitos

Todos os alunos do treinamento PostgreSQL devem ter um conhecimento sólido dos princípios básicos do banco de dados relacional e instruções SQL SELECT antes deste treinamento.

Informações Gerais

• Carga horaria, 32h
• Se noturno este curso acontece de segunda-feira a sexta-feira das 19h às 23h, total de 8 noites
• Se aos sábados este curso acontece das 09h às 18h, total de 4 sábados,
• Se integral esse curso acontece das 09h às 18h, total de 4 dias

Formato de entrega:

• On-line ao vivo via Plataforma Microsoft Teams, na presença de um instrutor/consultor de mercado

Materiais

Conteúdo Programatico

1. History and Overview
2. PostgreSQL Major Features
3. PostgreSQL Limits
4. PostgreSQL Architecture
5. MVCC
6. Write Ahead Logs
7. The Background Writer
8. PostgreSQL Data Types

1. Overview
2. Binary Installation
3. Source Installation
4. Initializing a PostgreSQL cluster
5. Starting and stopping a PostgreSQL cluster
6. Automatic startup/shutdown

1. Access Control
2. Connection settings
3. Security and Authentication settings
4. Memory settings
5. Kernel resource settings
6. Log management
7. Background writer settings
8. Vacuum cost settings
9. Autovacuum settings

1. Command line parameters
2. Meta commands
3. Security

1. PostgreSQL Clusters
2. PostgreSQL Databases
3. Tables, Joins and Aggregates
4. PostgreSQL Indexes and Foreign Keys

1. Schemas
2. Tables, Views and Rules
3. Users, Groups and Roles
4. Tables and Sequences
5. Object Security

1. Vacuum
2. Tablespaces
3. Inheritance
4. Table Partitioning
5. Windowing Functions
6. Transactions
7. Concurrency Control
8. Functions and Operators
9. Type conversion
10. Full text search

1. Basic DML
2. COPY
3. Other Tools

1. Log Management
2. Query analysis
3. Routine Vacuuming
4. Recovering disk space
5. Managing Planner statistics
6. REINDEX

1. Database Logs
2. OS Process monitoring
3. The PostgreSQL Statistics Collector
4. Statistics Views
5. Statistics Functions

1. OS Tuning
2. Hardware configuration
3. Transaction logs
4. Tablespaces and Partitioning
5. Checkpoint tuning
6. Query tuning

1. The pg_dump utility
2. The pg_dumpall utility
3. Recovery options
4. Point In Time Recovery

1. The pg_upgrade utility
2. RPM based upgrades
3. Source based upgrades
4. Replication based upgrades
5. Rolling back

1. Streaming Replication
2. Synchronous Replication
3. Replication Slots
4. Failover management
5. Connection Poolers
6. HA configurations

1. Overview
2. Triggers

1. Overview
2. Event Triggers

1. Overview
2. SELECT Views
3. Updating a View
4. Materialized Views
5. Rules and privileges

1. Structure
2. Declarations
3. Expressions
4. Statements
5. Control Structures
6. Cursors
7. Errors and Messages
8. Trigger Procedures

1. PL/Perl
2. PL/Python
3. More...

1. Overview of additionally supplied modules