Course Outline
Introduction
- PostgreSQL vs MySQL vs Oracle
- Overview of PostgreSQL 13 features and architecture
Getting Started
- Setting up a database server
- Installing PostgreSQL 13
- Creating and accessing a database
- SQL syntax, commands, and functions
Configuring a Postgres Database
- Data definition, default values, and constraints
- Setting up and modifying tables
- Managing privileges and security policies
- Creating database schemas
- Implementing table inheritance and partitioning
- Adding, updating, and querying data
- Data types, functions, and operators
- Using indexes and running full-text search
- Understanding concurrency control
Managing a Database Server
- Upgrading a PostgreSQL cluster
- Securing the server and encrypting data
- Configuring server parameters
- Enabling client authentication
- Setting up access roles and permissions
- Managing multiple databases
- Performing database maintenance tasks
- Backing up and restoring data
- Optimizing database performance and reliability
- Monitoring database activity and disk usage
- Implementing logical replication
- Running regression tests
Client-Side Programming
- Using the libpq C library and large object interface
- Executing embedded SQL statements
- Exploring the information schema
- Other PostgreSQL client applications
Server-Side Programming
- Extending the SQL query language
- Writing event trigger functions
- Implementing rule systems
- Using procedural languages (PLs)
- Exploring TCL, Perl, and Python PLs
- Executing server programming interfaces
- Examples of logical decoding
- Tracking replication progress
Troubleshooting
Summary and Next Steps
Requirements
- An understanding of RDBMS
- Experience with SQL
Audience
- System administrators
- Developers
Testimonials (8)
step by step examples, byte size information
Esmadee Bin Ismail - SBS transit
Course - PostgreSQL Administration and Development
Great lab setup. Very practical training which reinforced the material.
Brian - Verizon Connect
Course - PostgreSQL for Administrators - 2 Days
That we could follow along on our remote desktops. I like to learn by trying.
Clare - BCP Council
Course - PostgreSQL Essentials
buen nivel de conocimiento
Rolando - CENTRO NETEC SPA
Course - PostgreSQL Advanced DBA
La verdad no conocía nada, asi que todo lo aprendido lo valoro.
Sandra - CENTRO NETEC SPA
Course - PostgreSQL Performance Tuning
What I liked most was the presenter's approach. Everything is great, I am very satisfied. Of course, with satisfaction comes a huge amount of new knowledge.
Olek - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
I liked the exercises
Luis - Verizon Connect
Course - PostgreSQL for Developers
el último día vimos los temas más acertados con lo que necesitamos como administradores