Trainer

NA yrs exp

Duration

30 Days

Recordings

44 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 
  • New Features of PostgreSQL 
  • Multi Version Concurrency Control 
  • Write-Ahead Logging 
  • Architectural Overview 
  • Limits 
  • Architectural Summary 
  • Shared Memory 
  • Statement Processing 
  • Utility Processes 
  • Disk Read Buffering 
  • Write Buffering 
  • Background Writer Cleaning Scan 
  • Commit & Checkpoint 
  • Physical Database Architecture 
  • Data Directory Layout 
  • Installation Directory Layout 
  • Page Layout
  • OS User & Permissions 
  • Installation 
  • Setting environment variables 
  • Clusters
  • Creating a database cluster 
  • Starting and Stopping the Server (pg_ctl) 
  • Connect to the server using psql
  • Creating a Database Cluster
  • initdb Utility
  • Starting a Database Cluster
  • Connecting to a Database Cluster
  • Reload a Database Cluster
  • Stopping a Database Cluster
  • View Cluster Control Information
  • Demo - Database Cluster
  • Setting PostgreSQL Parameters 
  • Access Control 
  • Connection Settings 
  • Security and Authentication 
  • Settings 
  • Memory Settings 
  • Query Planner Settings 
  • WAL Settings 
  • Log Management 
  • Background Writer Settings 
  • Statement Behavior 
  • Vacuum Cost Settings 
  • Autovacuum Settings

  • Object Hierarchy 
  • Creating Databases 
  • Creating Schemas 
  • Schema Search Path 
  • Roles, Users & Groups 
  • Access Control
  • The System Catalog Schema 
  • System Information views/tables 
  • System Information Functions
  • Conventions 
  • Connecting to PostgreSQL 
  • PSQL Command Line Parameters 
  • Entering PSQL Commands 
  • PSQL Meta-Commands 
  • PSQL SET Parameters 
  • Information Commands
  • Registering a server 
  • Viewing and Editing Data 
  • Query Tool 
  • Databases 
  • Languages 
  • Schemas 
  • Domains 
  • Functions 
  • Sequences 
  • Tables 
  • Columns 
  • Constraints 
  • Indexes 
  • Maintenance 
  • Rules 
  • Triggers 
  • Types 
  • Views 
  • Table spaces 
  • Roles
  • Authentication 
  • Authorization 
  • Levels of security 
  • pg_hba.conf file 
  • Users 
  • Object ownership 
  • Access control 
  • Application access parameters 
  • Data Types 
  • Tables 
  • SQL Queries 
  • Quoting 
  • Using SQL Functions 
  • Constraints 
  • Dropping or Removing Database 
  • Objects 
  • Views 
  • Sequences 
  • Indexes
  • Recovery 
  • Backup Types 
  • SQL Dump 
  • Cluster Dump
  • Offline Copy Backup 
  • Continuous Archiving 
  • pg_basebackup 
  • Point-In Time Recovery
  • Explain and Explain Analyze 
  • Table Statistics 
  • Updating Planner Statistics 
  • Vacuuming 
  • Scheduling Auto Vacuum 
  • Preventing Transaction ID Wraparound Failures 
  • The Visibility Map 
  • Routine Reindexing 
  • The COPY Command
  • Examples
  • Transaction Definition 
  • Effects of Concurrency on 
  • Transactions 
  • Transaction Isolation Levels 
  • Overview (MVCC) 
  • MVCC Example 
  • Internal Identifiers 
  • Transaction Wraparound 
  • MVCC Maintenance 
  • MVCC Demo 

  • Partitioning
  • Partitioning Methods
  • When to Partition
  • Partitioning Setup
  • Partitioning Example
  • Partitioning and Constraint  Exclusion
  • Caveats
  • Lab 
  • Overview of PostgreSQL 
  • Replication
  • High Availability in PostgreSQL
  • Streaming Replication
  • Performance Tuning 
  • Hardware Configuration 
  • OS Configuration 
  • Server Parameter Tuning 
  • Connection Settings 
  • Memory Parameters 
  • Memory settings for Planner 
  • WAL Parameters 
  • Explain Plan 
  • Explain Example 
  • Statistics Collection 
  • Indexes 
  • Examining Index Usage 
  • pg_dump
  • Non-Durable Settings 
  • Labs

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

  • BEST TRAINER : Having 14 yrs exp, delivered 100+ batches, trained above 3000 candidates
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
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
25-Dec

7:00am to 8:30am IST

30 Days (Mon-Fri)

31-Dec

7:00am to 8:30am IST

30 Days (Mon-Fri)

03-Jan

7:00am to 8:30am IST

30 Days (Mon-Fri)

21 % OFF 28,000/- $260 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 online@akswave-trainings.com 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 years 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

3 years 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

3 years 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