Training PostgreSQL Basic and Advance
Basic PostgreSQL Class Schedule
Day | Session | Topic | Duration | Description |
---|---|---|---|---|
1 | 1 | Introduction to RDBMS | 4 hours | ACID Concept; OLTP and OLAP Concept; |
2 | PostgreSQL Basic Administration | 4 hours | How to manage PostgreSQL Instance (control scripts); Data directory Structure; Simple binary PostgreSQL install; Physical access of PostgreSQL; | |
2 | 3 | Objects & Query | 2 hours | Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained; ACL |
4 | Advance SQL Languages | 2 hours | Advanced SQL like; Subqueries, WITH, UPSERT, Complex Join, object, Indexes, View, etc | |
5 | Accessibility & Security | 2 hours | Users; Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Using Client Libraries PHP, JAVA, etc; | |
6 | Monitoring | 2 hours | pgAdmin 4; Monitoring Views; PostgreSQL System Catalogs; | |
3 | 7 | Backup & Restore | 4 hours | Cold Backup; Hot Backup; Backup tools; |
8 | Replication Concept and Implementation | 4 hours | Synchronous Replication; Asynchronous Replication; Cascading Replication; |
* Training locations, material and times are subject to change based on availability of facilities or other unforeseen circumstances. Please confirm back one week prior to the training to verify specific details.
BasicPlus PostgreSQL Class Schedule
Day | Session | Topic | Duration | Description |
---|---|---|---|---|
1 | 1 | Introduction to RDBMS and SQL | 4 hours | Database Query Concept; ACID Concept; OLTP and OLAP Concept; |
2 | Introduction to Linux OS | 4 hours | OS Linux Concept; What is Shell; Root Management; What is Kernel and what are the parameters; Software Packages | |
2 | 3 | Linux Installation (Hands-On) | 2 hours | Debian Installation Hands-on, What is SHELL, How to do disk partitioning, Basic File System, Linux Directory Layout, How to manage Software Packages |
4 | File/Device Management (Hands-On) | 2 hours | Tools to list and managed files and directories, How to check partition layout, size, and free size | |
5 | Process Manager (Hands-On) | 1 hour | How to monitor processes, How to start and stop application/instance | |
6 | Network Management (Hands-On) | 2 hours | What is network interface in Linux, How to monitor and manage network interfaces, IP, and connections, Secure Connections | |
7 | Access List in Linux (Hands-On) | 1 hour | How to manage access list and ownership in Linux | |
3 | 8 | Basic PostgreSQL Administration (Hands-On) | 4 hours | How to control PostgreSQL instance; Users; Using psql; |
9 | Simple Objects & Query | 2 hours | Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained | |
10 | Monitoring and Simple Management (Hands-On) | 2 hours | pgAdmin 4; Monitoring Views; PostgreSQL System Catalogs; Where and How to Read Logs | |
4 | 11 | Basic Accessibility & Security (Hands-On) | 4 hours | Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Using Client Libraries PHP, JAVA, etc; |
12 | SQL Query for Transaction and Reporting | 4 hours | What is query difference between OLTP and OLAP Concept, How to execute the queries Hands-On | |
5 | 13 | Simple Backup & Restore | 4 hours | Backup Tools Explained |
14 | Replication Concept and Implementation | 4 hours | Synchronous Replication; Asynchronous Replication; Cascading Replication; |
* Training locations, material and times are subject to change based on availability of facilities or other unforeseen circumstances. Please confirm back one week prior to the training to verify specific details.
Advance PostgreSQL Class Schedule
Day | Session | Topic | Duration | Description |
---|---|---|---|---|
1 | 1 | ORDBMS Concept in General | 2 hours | ACID Concept;OLTP and OLAP Concept; Benchmarking Result Oracle vs PostgreSQL; |
2 | Architecture | 2 hours | Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc.); Journaling Concept; Replication Concept; HA Concept; Archiving Concept; | |
3 | Installation & Administration | 4 hours | Compilation concept on Linux; How to install PostgreSQL from Source Code;Source Code structure of PostgreSQL; How to initialize data directory; How to manage PostgreSQL Instance (control scripts); Data directory Structure; | |
2 | 4 | Monitoring | 2 hours | Pgadmin 4; Monitoring Views; PostgreSQL System Catalogs (stats); Art of Logging; How to analyze slow queries (Introduction); |
5 | Administration & Advance Security | 2 hours | Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters);Plugins Installation; | |
6 | Syntaxes, Query, & Data Types | 4 hours | Keywords on PostgreSQL; Database structures on PostgreSQL; Data Types Explained; Stored Procedure, Trigger, View, Sequence Explained; | |
3 | 7 | Multitier Backup & Restore | 2 hours | Cold Backup; Hot Backup; Incremental Backup; Point in Time Recovery; Backup tools; |
8 | Replication | 2 hours | Synchronous Replication; Asynchronous Replication; Cascading Replication; Multi-slave Replication; Logical Decoding Explained; | |
9 | High Availability Implementation | 4 hours | Linux-HA Concept & Hands-on; Failover & Recovery Mechanism; Combining Replication & Linux-HA on HA Implementation; | |
4 | 10 | Partition & Tablespace | 2 hours | How to configure Tablespace; How to configure Partition; Best practices on Performance Tuning using Tablespace & Partition; |
11 | Load-balancing | 4 hours | Bi-directional Replication Explained; Data sharding Concept; FDW for Loadbalancing, pg_shard, PostgresXL; | |
12 | Benchmarking & Server-side Tuning | 2 hours | How to tune Server-side Configuration; Best Practices on High Performance System; pgBench Tools Explained; Hand-on tuning & benchmarking; | |
5 | 13 | Exotic Features | 2 hours | JSONB; FDW; UPSERT Query; Row Level Security; Paralel Worker; |
14 | Special Topic | 4 hours | SQL Query Tuning; Art of Indexing; pg_upgrade; | |
15 | Free Discussion & Test | 2 hours | Free Discussion;Post-training Test; |
* Training locations, material and times are subject to change based on availability of facilities or other unforeseen circumstances. Please confirm back one week prior to the training to verify specific details.