Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
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
要求
- An understanding of RDBMS
- Experience with SQL
Audience
- System administrators
- Developers
21 時間
お客様の声 (5)
アンドレスは一貫して出席者のすべての質問に確実に答え、全員が彼の教えを確実に理解できるよう努めています。私は彼の専門知識と主題に関する熟練度を賞賛します
Ryan - Questronix Corporation
コース - PostgreSQL for Administrators - 3 Days
Machine Translated
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
コース - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
コース - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
コース - PostgreSQL Advanced DBA
new knowledges that can be apply in our system
