- +63 917 714 4350 or DUO: (02) 7971 5203
-
Main: 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
Satellite Office: 2nd Floor, Bonifacio Technology Center, 31st St. cor. 2nd Ave., Bonifacio Global City, Taguig City
- Courses
High Potential Leadership
Leadership, Professional and Personal Training
Customer Service
Sales
Business Etiquette
Business Communication
- Opportunities
Careers at Acumen
Trainer for Hire
COMPREHENSIVE POSTGRESQL ADMINISTRATION FOUNDATION LEVEL
COURSE DESCRIPTION
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. This class will give you guide to the Basic, Advance and Complete PostgreSQL Administration.
It will cover modules on PostgreSQL Introduction, System Architecture, Database Clusters, Configuration, Creating and Managing Databases, User Tools – Command Line Interface, GUI Tools, PostgreSQL Security, SQL Primer, Backup & Recovery, Routine Maintenance, Data Dictionary, Tablespaces, Performance Tuning, Pgpool, Transactions & Concurrency, Table Partitioning, Upgrading PostgreSQL, Data Loading / UnLoading and Database Replication.
COURSE OUTLINE
DAY 1:
MODULE 1 – POSTGRESQL INTRODUCTION
- History of PostgreSQL
- Major Features
- Architectural Overview
- General Database Limits
- Common Database Object Names
MODULE 2- SYSTEM ARCHITECTURE
- Architectural Summary
- Process and Memory Architecture
- Utility Processes
- Connection Requests-Response
- Buffering
- Background Writer Cleaning
- Commit and Checkpoint
- Statement Processing
- Physical Database Architecture
- Data Directory Layout
- Installation Directory Layout
- Page Layout
DAY 2:
MODULE 3 – DATABASE CLUSTERS
- Introduction
- Creating a Database Cluster
- Starting and Stopping PostgreSQL Server
- Connecting the Server Using psql
MODULE 4 – CONFIGURATION
- Setting PostgreSQL Parameters
- Access Control
- Connection Settings
- Security & Authentication Settings
- Memory Settings
- Query Planner Settings
- WAL Settings
- Log Management
- Background Writer Settings
- Statement Behavior
- Parallel Query Scan Settings
- Parallel Maintenance Settings
- Vacuum Cost Settings
- AutoVacuum Settings
- Configuration Files
DAY 3:
MODULE 5 – CREATING & MANAGING DATABASES
- Object Hierarchy
- Creating Databases
- Users and Roles
- Access Control
- Creating Schemas
- Schema Search Path
MODULE 6 – USER TOOLS – COMMAND LINE INTERFACE
- Introduction to Psql
- Connecting to Databases
- PSql command Line Parameters
- Entering psql commands
- Psql Meta Commands
- Psql set Parameters
- Conditional Commands
- Information Commands
MODULE 7 – GUI TOOLS
- Introduction to Pgadmin
- Installing Pgadmin
- Registering a Server
- Viewing & Editing Data
- Query Tool
- Databases
- Languages
- Schemas
- Database Objects
- Maintenance
- Tablespaces
- Roles
DAY 4:
MODULE 8 – POSTGRESQL SECURITY
- Authentication & Authorization
- Levels of Security
- Pg_hba.conf file
- Row Level Security
- Object Ownership
- Host Based Access Control
- Pgcrypto Module
- Application access parameters
MODULE 9 – SQL PRIMER
- Data Types
- Structured Query Language (SQL)
- DDL, DML and DCL Statements
- Transaction Control Statements
- Tables and Constraints
- Views and Materialized Views
- Sequences
- Domains
- SQL Joins
- Using SQL Functions
- Indexes
DAY 5:
MODULE 10 – BACKUP & RECOVERY
- Backup Types
- Database SQL Dumps
- Restoring SQL Dumps
- Offline Physical Backups
- Continuous Archiving
- Online Physical Backups Using pg_basebackup
- Point-in-time Recovery
- Recovery Settings