Trainer

6 yrs exp

Duration

25 Days

Recordings

38 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

Who should go for this training?
The following professionals can go for this course:

What are the pre-requisites for this Course?

Course Overview

Course Content


  • History of PostgreSQL
  • Major Features
  • PPAS Features
  • Architectural Overview
  • General Database Limits
  • Common Database Object Name
  • 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
  • OS User & Permissions
  • Installation Options
  • Installation of PostgreSQL
  • StackBuilder
  • Setting Environmental Variables
  • Database Cluster
  • Creating a Database Cluster
  • Starting and Stopping the Server (pg_ctl)
  • Connect to the Server Using psql
  • 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
  • Setting PostgreSQL Parameters
  • Access Control
  • Connection Settings
  • Security and Authentication Settings
  • Memory Settings
  • Query Planner Settings
  • WAL Settings
  • Background Writer Settings
  • Statement Behavior
  • Configuration File Includes
  • Object Hierarchy
  • Creating Databases
  • Users • Access Control
  • Creating Schemas
  • Schema Search Path
  • Introduction to PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • 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
  • 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
  • Quoting 
  • SQL Functions
  • Concatenation
  • Nested Queries
  • Joins  
  • Materialized Views 
  • Updatable Views o Indexes
  • Backup Types
  • SQL Dump Backups 
  • SQL Dump Options 
  • Handling Large Databases
  • Restoring SQL Dumps 
  • Cluster Dump
  • Offline Backups
  • Recovering a Database using Offline
  • 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)

  • Database Maintenance
  • Maintenance Tools 
  • Optimizer Statistics 
  • Data Fragmentation 
  • Routine Vacuuming
  • Vacuuming Commands 
  • Preventing Transaction ID Wraparound Failures
  • Vacuum Freeze
  • The Visibility Map
  • The System Catalog Schema 
  • System Information Tables
  • System Information Functions
  • System Administration Functions 
  • System Information Views
  • Oracle-like Dictionaries
  • Loading flat files
  • Import and export data using COPY
  • Examples of COPY Command 
  • Using COPY FREEZE for performance
  • Introduction to EDB*Loader for PPAS
  • 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
  • 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
  • Version Change and Upgrade 
  • Need to Upgrade
  • Upgrade Plan 
  • Upgrade Using pg_upgrade
  • Upgrading Best Practices
  • 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
  • Performance Tuning - Overview 
  • Performance Monitoring using PEM 
  • A Tuning Technique 
  • Operating System Considerations
  • Server Parameter Tuning
  • Memory Parameters 
  • Temporary File Parameters
  • WAL Parameters
  • 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

  • Introduction to ora2pg
  • Configure and test Oracle to PostgreSql Migration using ora2pg

Discussion on 50+ PostgreSql 13 Certification Questions.

Modes of Training

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Our Key Highlights

Unique Benefits included in this training

Key Benefits

Upcoming Batches

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 6 yrs exp
  • 25 Virtual online sessions
  • Access for 38 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 50 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

21 % OFF 28,000/- $298 22,000/-

SELF-PACED LEARNING

This Course Includes:
  • Access for 38 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 50 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

15,000/-

Our Instructor

No Records Found

Demo Video

No Video Found

No Demo Video

Certification Guidence

No Records Found

Faq

Our Trainer has 8 years of working experience

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

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.

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

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

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to [email protected] with your queries.


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

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.

* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Testimonials

Manoj Kumar

3 months ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna

7 months ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain

1 year ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8