Visão Geral

Curso PostgreSQL Developer Fundamentals & Advanced, Projetado para DBAs, arquitetos, desenvolvedores de aplicativos e profissionais de TI, este curso e ministrados por experientes especialistas em PostgreSQL que mostrarão como gerenciar rapidamente suas responsabilidades de banco de dados com facilidade.

Abordagem de entrega

• O Curso PostgreSQL Developer Fundamentals & Advanced inclui lições, laboratórios práticos e exercícios de acompanhamento para ensiná-lo a usar o Postgresql
• 100% on-line via Microsoft Teams na presença de um instrutor/consultor PostGreSQL

EXPERIÊNCIA PESSOAL

• Materiais e laboratórios relevantes e atualizados permitem que você coloque rapidamente suas novas habilidades em prática em seu próprio ambiente. Todo o treinamento inclui lições modulares, palestras, cópia da apresentação e exercícios práticos reais de laboratório.
  

Objetivo

Pre-Requisitos

• Experiência básica em administração de banco de dados e compreensão dos conceitos de banco de dados relacional serão úteis. A compreensão do ambiente Linux e dos comandos básicos ajudará a compreender melhor as sessões de laboratório prático
  

Materiais

Conteúdo Programatico

O Curso PostgreSQL Developer Fundamentals & Advanced, é um treinamento que inclui a parte fundamentos do postGreSQL e a parte avanadada, ministrado por instrutor que oferece as habilidades essenciais para o desenvolvimento de banco de dados no PostgreSQL. Aprenda sobre tipos de dados PostgreSQL, objetos de banco de dados, índices, transações e como trabalhar com conectores e drivers, com instalação básica.

Procedural Languages:

1. What is a Procedural Langauge
2. Introduction to PL/pgSQL
3. Working of PL/pgSQL
4. How to Create PL/pgSQL Functions
5. How to use Control Statements
6. How to Handle Exceptions in PL/pgSQL
7. Declaring and Using Cursors

Rules and Triggers:

1. How to define Rules
2. Write Database Trigger Procedures
3. Create Triggers in PostgreSQL
4. Add Triggers on Views

Localization:

1. PostgreSQL Locale Support
2. Working with different Locales
3. PostgreSQL Character Sets
4. Changing Server and Client Encoding

Foreign Data Wrappers:

1. What are Postgres
2. Foreign Data Wrappers
3. How to Setup FDWs
4. Example – postgres_fdw
5. Example – file_fdw

Full Text Searching:

1. What is Full-Text Search
2. How to store and query Full Text Search data in Postgres

SQL Tuning:

1. Statement Processing
2. Common Query Performance Issues
3. SQL Tuning Goals
4. SQL Tuning Steps
5. Identify slow queries
6. Review the query execution plan
7. Optimizer statistics and behaviour
8. Restructure SQL statements
9. Indexes

Background Worker Processes:

1. What is Background Worker
2. How to Setup Background Worker
3. Examples of Pre-built Background Worker Processes

Data Encryption:

1. What is Database Security
2. PostgreSQL options for Eata Encryption and Security
3. What is Host Based Access Control
4. How to implement Row level Security
5. Introduction to pg_crypto Extension

Working with Geo Data: Postgis

1. What is PostGIS
2. Installation of PostGIS
3. Creation of spatial database
4. Load and retrieve data in a spatial database

A parte Avançada do Curso PostgreSQL Developer Fundamentals & Advanced, abrange as habilidades avançadas necessárias para desenvolvedores de banco de dados PostgreSQL Você aprenderá a usar adaptadores de dados para interagir com fontes de dados adicionais, um plano de várias etapas para ajuste de SQL e abordagens para segurança e localização de dados. Esta é a segunda parte do PostgreSQL Developers Track e segue o PostgreSQL Developer Fundamentals.

Installation:

1. Installation Options
2. PostgreSQL Installation
3. PostgreSQL Source Code
4. Database Clusters
5. Start and Stop Postgres
6. PostgreSQL Introduction:
7. Introduction to PostgreSQL
8. Describe the sample tables used in the course

pgAdmin III:

1. PgAdmin3
2. PEM Client
3. Registering a server
4. Viewing and Editing Data
5. Query Tool
6. Databases
7. Languages
8. Schemas

PostgreSQL Connectors and Extensions:

1. JDBC
2. Installing JDBC Connectors
3. Connecting Java Applications to PostgreSQL
4. .NET Connectors
5. Extensions

Database Design:

1. Object Hierarchy
2. Creating Databases
3. Users
4. Access Control
5. Creating Schemas
6. Schema Search Path

Data Types:

1. Numeric Types
2. Character Types
3. Date and Time
4. Arrays
5. JSON and JSONB
6. Other Data Types

SQL Primer:

1. Tables
2. Constraints
3. Table Inheritance
4. Viewing Data Using SELECT
5. SQL Queries: DML
6. Quoting in PostgreSQL

Other Database Objects:

1. Views
2. Materialized Views
3. Sequences
4. Domains

Indexes:

1. Types of Indexes
2. Creating an Index
3. Index on Expression
4. Unique Indexes
5. Partial Indexes
6. Removing Indexes
7. Viewing Index Usage
8. Re-indexing

SQL Functions:

1. Operators
2. String Functions
3. Date Functions
4. Numeric Function
5. JSON Functions
6. XML Functions
7. Aggregate Functions
8. Data Type Conversion

Large Objects:

1. Data Types for large data
2. Adding lo extenstion
3. Using Java File Stream for inserting
4. image in postgres

Large Objects:

1. Introduction to PLPGSQL
2. PL/PGSQL
3. Creating Functions using PL/PGSQL

PostgreSQL Introduction:

1. Introduction to PostgreSQL
2. Describe the sample tables used in the course

Installation:

1. Installation Options
2. Postgres Installation
3. PostgreSQL Source Code
4. Database Clusters
5. Start and Stop Postgres

pgAdmin III:

1. PgAdmin3
2. PEM Client
3. Registering a server
4. Viewing and Editing Data
5. Query Tool
6. Databases
7. Languages
8. Database Objects
9. Maintenance
10. Tablespaces
11. Roles
12. Command Line Tool: PSQL
13. Command Line Tool: EDB*Plus

Transactions and Concurrency:

1. Transaction Definition
2. Effects of Concurrency on Transactions
3. Transaction Isolation Levels
4. Sharing Data Snapshots
5. Locking Modes
6. Multi-Version Concurrency Control Overview (MVCC)
7. Internal Identifiers
8. Schemas
9. Database Objects
10. Maintenance
11. Tablespaces
12. Roles
13. Command Line Tool: PSQL
14. Command Line Tool: EDB*Plus

Transactions and Concurrency:

1. Transaction Definition
2. Effects of Concurrency on Transactions
3. Transaction Isolation Levels
4. Sharing Data Snapshots
5. Locking Modes
6. Multi-Version Concurrency Control Overview (MVCC)
7. Internal Identifiers

PostgreSQL Connectors and Extensions:

1. JDBC
2. Installing JDBC Connectors
3. Connecting Java Applications to PostgreSQL
4. .NET Connectors
5. Extensions

Database Design:

1. Object Hierarchy
2. Creating Databases
3. Users
4. Access Control
5. Creating Schemas
6. Schema Search Path

Data Types:

1. Numeric Types
2. Character Types
3. Date and Time
4. Arrays
5. JSON and JSONB
6. Other Data Types

SQL Primer:

1. Tables
2. Constraints
3. Table Inheritance
4. Viewing Data Using SELECT
5. SQL Queries: DML
6. Quoting in PostgreSQL

Other Database Objects:

1. Views
2. Materialized Views
3. Sequences
4. Domains

Indexes:

1. Types of Indexes
2. Creating an Index
3. Index on Expression
4. Unique Indexes
5. Partial Indexes
6. Removing Indexes
7. Viewing Index Usage
8. Re-indexing

SQL Functions:

1. Operators
2. String Functions
3. Date Functions
4. Numeric Function
5. JSON Functions
6. XML Functions
7. Aggregate Functions
8. Data Type Conversion

Large Objects:

1. Data Types for large data
2. Adding lo extenstion
3. Using Java File Stream for inserting
4. image in postgres

Large Objects:

1. Introduction to PLPGSQL
2. PL/PGSQL
3. Creating Functions using PL/PGSQL