25% DISCOUNT OFFER

Special Discount on Oracle
CERTIFICATION EXAM VOUCHER

Actual Fee 10,475/- INR
Pay only 7,860/- INR
(valid till 5th August)

PostgreSQL DBA

Modes of Training
  • Classroom Sessions
  • Online Sessions​

COURSE SCHEDULE

** drag left & right, for complete view
CLASSROOM SESSIONS
18th Jan
​Timing
​8:00am - 9:00am
Weekdays
( Duration: 22days )
Trainer
Mr. Adhi(OCP)
Course Fee after Discount  ​Rs. 8,000/-
​( Actual : 12,000/- )
4th Feb
​​Timing
​9:00am - 10:00am
Weekdays
( Duration: 22 days )
Trainer
Mr. Adhi(OCP)
Course Fee after Discount  Rs. 8,000/-
​( Actual : 12,000/- )
4th Mar
​​Timing
​9:00am - 10:00am
Weekdays
( Duration: 22 days )
Trainer
Mr. Adhi(OCP)
​Course Fee after Discount  Rs. 8,000/-
​( Actual : 12,000/- )
ONLINE SESSIONS
21st Jan
​Timing
​6:00am - 7:30am
​MON - SAT
( Duration: 22 days )
Trainer
Mr. Amit
Course Fee after Discount  ​Rs. 18,000/-
​( Actual : 20,000/- )
3rd Jan
​​Timing
​7:00am - 8:30am
MON - SAT
( Duration: 22 days )
Trainer
Mr. Amit
Course Fee after  Discount  Rs. 18,000/-
​( Actual : 20,000/- )
5th Feb
​Timing
​7:00am - 8:30am
​​MON - SAT
( Duration: 22 days )
​Trainer
Mr. Amit
​Course Fee after Discount  ​Rs. 18,000/-
​( Actual : 20,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
 

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

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
Copyright © Akswave Oracle Trainigs, Hyderabad 2014-2019. All Right Reserved.