• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

PostgreSQL-Database-Administration-(DBA)


Duration : 25 hours

Fee: 328


Job Trends

Training Calender

Date Time Type Attend
19th September 2020 8:00 AM   IST Demo
22nd September 2020 8:00 AM   IST Regular
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

PostgreSQL Database Administration (DBA) Download  

PostgreSQL Administration

Introduction and Architectural Overview

  1. History of PostgreSQL
  2. Major Features
  3. Architectural Overview
  4. Common Database Object Name

PostgreSQL System Architecture

  1. Architectural Summary
  2. Process & Memory Architecture
  3. Utility Processes
  4. Connection Request-Response
  5. Disk Read Buffering Disk
  6. Write Buffering
  7. Background Writer Cleaning Scan
  8. Commit & Checkpoint
  9. Statement Processing
  10. Physical Database Architecture
  11. Data Directory Layout
  12. Installation Directory Layout
  13. Page Layout

 

Installation

  1. OS User & Permissions
  2. Installation Options
  3. Installation of PostgreSQL

Database Clusters

  1. Database Cluster
  2. Creating a Database Cluster
  3. Starting and Stopping the Server (pg_ctl)
  4. Connect to the Server Using psql

Configuration

  1. Setting PostgreSQL Parameters
  2. Access Control
  3. Connection Settings
  4. Security and Authentication Settings
  5. Memory Settings
  6. Query Planner Settings
  7. WAL Settings

Creating and Managing Databases

  1. Object Hierarchy
  2. Creating Databases
  3. Users
  4. Access Control
  5. Creating Schemas
  6. Schema Search Path

Log Management

  1. Background Writer Settings
  2. Statement Behavior
  3. Configuration File Includes

Security

  1. Authentication and Authorization
  2. Levels of Security
  3. pg_hba.conf File
  4. Object Ownership
  5. Application Access Parameters
  6. Protecting Against Injection Attacks with SQL/Protect
  7. Source Code Protection for Functions

GUI Tools • Intro to PGADMIN4

  1. Introduction to PEM Client
  2. Registering a server
  3. Viewing and Editing Data
  4. Query Tool
  5. Databases
  6. Languages
  7. Schemas
  8. Database Objects
  9. Maintenance
  10. Tablespaces
  11. Roles

PG/SQL

  1. Data Types
  2. Structured Query Language (SQL)
  3. Tables and Constraints
  4. Manipulating Data using INSERT,UPDATE and DELETE
  5. Creating Other Database Objects: Sequences, Views and Domains
  6. Table Partitioning
  7. Partitioning
  8. Partitioning Methods
  9. When to Partition
  10. Partitioning Setup
  11. Partitioning Example
  12. Partitioning and Constraint Exclusion
  13. Caveats

Backup and Recovery & Point-in Time Recovery

  1. Backup Types
  2. SQL Dump Backups
  3. SQL Dump Options
  4. Handling Large Databases
  5. Restoring SQL Dumps
  6. Cluster Dump
  7. Offline Backups
  8. Recovering a Database using Offline


Routine Maintenance

  1. Database Maintenance
  2. Maintenance Tools
  3. Optimizer Statistics
  4. Data Fragmentation
  5. Routine Vacuuming
  6. Vacuuming Commands
  7. Preventing Transaction ID Wraparound Failures
  8. Vacuum Freeze
  9. The Visibility Map

Data Dictionary

  1. The System Catalog Schema
  2. System Information Tables
  3. System Information Functions
  4. System Administration Functions
  5. System Information Views
  6. Oracle-like Dictionaries

Moving Data

  1. Loading flat files
  2. Import and export data using COPY
  3. Examples of COPY Command
  4. Using COPY FREEZE for performance

SQL Tuning

  1. Statement Processing
  1. Common Query Performance Issues
  2. SQL Tuning Goals
  3. SQL Tuning Steps
  4. Identify slow queries
  5. Review the query execution plan
  6. Optimizer statistics and behavior
  7. Restructure SQL statements
  8. Indexes
  9. Review Final Execution Plan

Performance Tuning

  1. Performance Tuning - Overview
  2. Performance Monitoring using PEM
  3. A Tuning Technique
  4. Operating System Considerations
  5. Server Parameter Tuning
  6. Memory Parameters
  7. Temporary File Parameters
  8. WAL Parameters

Streaming Replication

  1. Data Replication
  2. Data Replication in PostgreSQL
  3. Sync or Async • Log-Shipping Standby Servers
  4. Log-Shipping Architecture • Streaming Replication
  5. Hot Streaming Architecture • Cascading Replication
  6. Setup Replication Using Archive
  7. Setup Streaming Replication
  8. Prepare the Primary Server
  9. Synchronous Streaming Replication Setup
  10. Configure Authentication
  11. Take a Full Backup of Primary Server
  12. Setting up the Standby Server
  13. Adding Cascading Replicated Standby Server
  14. Monitoring Hot Standby
  15. Recovery Control Functions

Upgrading Best Practices

  1. Version Change and Upgrade
  2. Need to Upgrade
  3. Upgrade Plan
  4. Upgrade Using pg_upgrade
  5. Upgrading Best Practices

Migration to PostgreSQL

  1. ORAp2G Tool

 

 

Who should Learn PostgreSQL Database Administration (DBA)?

  • Anyone who wants to add PostgreSQL DBA skills to their profile
  • Teams getting started on PostgreSQL DBA projects

 

Prerequisite to learn PostgreSQL Database Administration (DBA)

Mandatory

  • Understanding of SQL
  • Database concepts

Suggested

  • Knowledge of Linux environment

Delivery Methodology used to deliver the PostgreSQL Database Administration (DBA)

Class delivery

PostgreSQL Database Administration (DBA) FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?