PostgreSQL DBA

Modes of Training

• Classroom Sessions
• Online Sessions​

COURSE SCHEDULE

** drag left & right, for complete view

CLASSROOM SESSIONS

AUG 30th	​Timing ​8:30am - 11:30am	MON - SAT ( Duration: 22 days )	Trainer Mr. Amit ​​	Course Fee after Discount  ​Rs. 8,000/- ​( Actual : 14,000/- )
SEP 30th	​​Timing ​8:30am - 11:30am	MON - SAT ( Duration: 22 days )	Trainer Mr. Amit ​​​	Course Fee after Discount  Rs. 8,000/- ​( Actual : 14,000/- )

ONLINE SESSIONS

AUG 30th	​Timing ​6:00am - 7:30am	​MON - SAT ( Duration: 22 days )	Trainer Mr. Amit ​	Course Fee after Discount  ​Rs. 13,000/- ​( Actual : 18,000/- )
SEP 30th	​​Timing ​6:00am - 7:30am	MON - SAT ( Duration: 22 days )	Trainer Mr. Amit ​​	Course Fee after  Discount  Rs. 13,000/- ​( Actual : 18,000/- )

RECORDED SESSIONS

Trainer Mr. Amit

22 Recorded sessions

Course Fee after 30% Discount  ​Rs.  ​( Actual : 20,000/- )

COURSE OVERVIEW

Duration

---

​22 days
daily 80 minutes

​Pre-Requisite

---

• Basics of SQL

Course Fee

---

Classroom - Rs. 14,000/- INR
Online - Rs. 22,000/- INR

About Trainer

---

Mr. Amit K
12+ years of DBA experience ​more...

30 hours of Instructor Led Oracle DBA Training

Study material and Lab Activity guide provided

Real-time use cases and Scenarios

Expert & Certified Trainer

Online Hands-on Lab environment provided

24/7 technical support

Lifetime Access to Recorded Sessions

LEARN postgresql dba TO GROW CAREER

whO SHOULD ATTEND THIS postgresql database TRAINING PROGRAM

postgresql dba course objective​

COURSE DESIGN and UNIQUE BENEFITS

Course

Design

PostgreSQL DBA course content is designed by our Experts as per Certification requirement, and taught by Expertise Trainer

• EDB Certified Associate - PostgreSQL 10

COURSE CONTENT

• COURSE TOPICS
• DETAILED CONTENT

<

>

1. ​Introduction and Architectural Overview
2. PostgreSQL System Architecture
3. Installation
4. Database Clusters
5. Configuration
6. Log Management
7. Creating and Managing Databases
8. User Tools: Command Line Interfaces
9. GUI Tools • Intro to PGADMIN3
10. Security 
11. PG/SQL
12. Introduction to various SQL functionalities: 
13. Backup and Recovery & Point-in Time Recovery
14. Backups 
15. Routine Maintenance 
16. Data Dictionary 
17. Moving Data 
18. SQL Tuning
19. Performance Tuning 
20. Streaming Replication
21. Connection Pooling 
22. Extension Modules
23. Upgrading Best Practices

1) Introduction and Architectural Overview History of PostgreSQL Major Features PPAS Features Architectural Overview General Database Limits Common Database Object Name	2) PostgreSQL System Architecture Architectural Summary Process & Memory Architecture Utility Processes Connection Request-Response Disk Read Buffering Disk Write Buffering Background Writer Cleaning Scan Commit & Checkpoint Statement Processing Physical Database Architecture Data Directory Layout Installation Directory Layout Page Layout
3) Installation OS User & Permissions Installation Options Installation of PostgreSQL StackBuilder Setting Environmental Variables	4) Database Clusters Database Cluster Creating a Database Cluster Starting and Stopping the Server (pg_ctl) Connect to the Server Using psql
5) Configuration Setting PostgreSQL Parameters Access Control Connection Settings Security and Authentication Settings Memory Settings Query Planner Settings WAL Settings	6) Log Management Background Writer Settings Statement Behavior Configuration File Includes
7) Creating and Managing Databases Object Hierarchy Creating Databases Users • Access Control Creating Schemas Schema Search Path	8) User Tools: Command Line Interfaces Introduction to PSQL and EDB-PSQL Conventions • Connecting to Database PSQL Command Line Parameters Entering PSQL Commands PSQL Meta-Commands PSQL SET Parameters Information Commands
9) GUI Tools • Intro to PGADMIN3 Introduction to PEM Client Registering a server Viewing and Editing Data Query Tool Databases Languages Schemas Database Objects Maintenance Tablespaces Roles	10) Security  Authentication and Authorization Levels of Security pg_hba.conf File Object Ownership  Application Access Parameters  Protecting Against Injection Attacks with SQL/Protect  Source Code Protection for Functions
11) PG/SQL Data Types Structured Query Language (SQL) Tables and Constraints  Manipulating Data using INSERT,UPDATE and DELETE  Creating Other Database Objects: Sequences, Views and Domains Table Partitioning  Partitioning Partitioning Methods When to Partition  Partitioning Setup  Partitioning Example Partitioning and Constraint Exclusion Caveats	12) Introduction to various SQL functionalities:  Quoting  SQL Functions Concatenation Nested Queries Joins   Materialized Views  Updatable Views o Indexes
13) Backup and Recovery & Point-in Time Recovery Backup Types SQL Dump Backups  SQL Dump Options  Handling Large Databases Restoring SQL Dumps  Cluster Dump Offline Backups Recovering a Database using Offline	14) Backups  Online Directory Backups  Continuous Archiving  Backup with Low level API How to use pg_basebackup for Online Backups Point-In Time Recovery Concepts Recovery Example  Backup and Recovery Tool (BART)
15) Routine Maintenance  Database Maintenance Maintenance Tools  Optimizer Statistics  Data Fragmentation  Routine Vacuuming Vacuuming Commands  Preventing Transaction ID Wraparound Failures Vacuum Freeze The Visibility Map	16) Data Dictionary  The System Catalog Schema  System Information Tables System Information Functions System Administration Functions  System Information Views Oracle-like Dictionaries
17) Moving Data  Loading flat files Import and export data using COPY Examples of COPY Command  Using COPY FREEZE for performance Introduction to EDB*Loader for PPAS	18) SQL Tuning Statement Processing  Common Query Performance Issues SQL Tuning Goals  SQL Tuning Steps  Identify slow queries  Review the query execution plan  Optimizer statistics and behavior Restructure SQL statements  Indexes Review Final Execution Plan
19) Performance Tuning  Performance Tuning - Overview  Performance Monitoring using PEM  A Tuning Technique  Operating System Considerations Server Parameter Tuning Memory Parameters  Temporary File Parameters WAL Parameters	20) Streaming Replication Data Replication  Data Replication in PostgreSQL Sync or Async • Log-Shipping Standby Servers Log-Shipping Architecture • Streaming Replication  Hot Streaming Architecture • Cascading Replication  Setup Replication Using Archive  Setup Streaming Replication  Prepare the Primary Server  Synchronous Streaming Replication Setup Configure Authentication  Take a Full Backup of Primary Server  Setting up the Standby Server  Adding Cascading Replicated Standby Server  Monitoring Hot Standby  Recovery Control Functions
21) Connection Pooling  Connection Pooling Overview pgpool-II – Features Connection pooling Replication  Load balance Limiting exceeding connections  Automatic failover pgpool II - Installation and Configuration Configuring pcp.conf, pgpool.conf  Setting up pool_hba.conf for Client Authentication (HBA) Starting/Stopping pgpool-II	​22) Extension Modules What are Extension Modules?  Installing Extension Modules  Module Index Monitoring  Database Monitoring  Database Statistics  The Statistics Collector  Database Statistic Tables Operating System Process Monitoring Current Sessions and Locks Log Slow Running Queries Disk Usage  Postgres Enterprise Manager  PEM – Features PEM – Architecture
23) Upgrading Best Practices  Version Change and Upgrade  Need to Upgrade Upgrade Plan  Upgrade Using pg_upgrade Upgrading Best Practices

Check Upcoming Batches

PROGRAM BENEFITS

MULTIPLE BENEFITS	CLASSROOM	ONLINE	RECORDINGS
Live Sessions by Expert Trainer Sessions by Mr. Adi with real-time examples Training by Certified Trainer Having 18+ yrs Exp as DBA, more than 20 batches delivered	YES	YES	-
Recorded Videos 26+ hours of Recorded sessions	NO	YES	-
​Course Material Course and material designed by Experts Provide you Study Material Step-by-step Lab Practice Guide Provided Online Material for additional reading	YES	​YES	​-
Practice Environment Online Lab Environment Provided	YES	​YES	-
Sharing Videos about few practical sessions	NO	YES	-
Guidance for MongoDB Certification	YES	YES	-
100% Satisfaction guaranteed	YES	YES	-

COURSE ENQUIRY FORM

Enquiry for
CLASSROOM SESSIONS

Enquiry for
ONLINE ​SESSIONS​

Enquiry for
RECORDED SESSIONS

FREQUENTLY ASKED QUESTION  -  FAQ'S

​Who are the trainers?

Our trainer is an OCP & OCM certified consultant and has significant amount of experience in working with the technology, having 18yrs of experience.

How I'll join the live sessions?

Once you get registered, our backend team will share you the details to join the session live over online portal which can be accessed through a browser.

​What if I miss a class?

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that particular session.

​How will I execute the practical?

For practical execution, our trainer/technical team will provide server access details to the student

​Will you help us in building our own lab setup in our local desktop / laptop?

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

​What is the difference between live online and pre-recorded videos training?

Live online training means, our trainer will be live/online with you during the sessions and help you solve your queries.
Pre-recorded training means, there will be no trainer available to solve your issues. You will only be provided with previously recorded live sessions.

​What if I have queries after completion of the class?

You can contact our support team, or just drop an email to online@akswave-trainings.com with your queries.

​Is the course material accessible after completion of the course?

The recorded training videos and course material are provided during the course program. You can download it anytime.

​Is there any offer / discount I can avail?

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant & special discount for 2 or more participants.

​Will I get the refund if I cancel my enrollment?

Your refund is made by cancelling some administration fee from the course. But cancellation must be enrolled within first 2 days of batch starting. The refund will be retained within 3 days of your request.

MongoDB DBA CERTIFICATION

An MongoDB DBA Certification helps build a sense of trust with current and future employers that you can perform the job. Global companies are looking to hire experts they can trust.​

Step 1: Complete the Course

1. Register yourself under our training Program
2. Complete the Course with us
3. Course Completion Certificate will be provided from AksWave

Step 2: Take your Certification Exam

1. Enquire about MongoDB Certification from MongoDB Portal (click here)
2. Register for the exam online
3. Complete your exam and get Certified from MongoDB