DASVM’s DBA Experts have designed our DBA Industry-Ready PostgreSQL Course Curriculum to develop a strong background in PostgreSQL basics, advanced enterprise architecture, and performance tuning, to help you acquire the skills most in-demand for Database Administration jobs. Our PostgreSQL Training course aims to deliver quality training that covers solid fundamental knowledge on core concepts with a practical approach. Such exposure to the current industry use-cases and scenarios will help learners scale up their skills and perform real-time projects with the best practices.
Course Objectives:
After this training, students can gain expertise in the following:
- Understand the working of relational databases and their relevancy
- Learn about kinds of DBMS, and PostgreSQL concepts
- Installing, setup PostgreSQL, and running queries on it
- Creating applications with PostgreSQL as a backend DBMS
Course content
Introduction to PostgreSQL
- PosgreSQL Platform
- Facts about PostgreSQL
- History of PostgreSQL
- Major Features
- General Database Limits
- Common Database Object Names
Installation
- OS User and Permissions
- Installation Options
- Wizard Installer
- YUM/Package Installer
- RPM/OFFLINE Installer
- Source Code Compilation
- Installation of Postgres server
- Setting Environmental Variables
System Architecture
- Process and Memory Architecture
- Utility Processes
- Disk Read Write Buffering
- Background Writer Cleaning Scan
- Commit and Checkpoint
- Statement Processing
- Physical Database Architecture
- Data Directory Layout
- Installation Directory Layout
Creating and Managing DB Clusters
- Database Clusters
- Creating a Database Cluster
- Starting and Stopping the Server (pg_ctl)
- Connecting to the Server Using psql
Configuration
- Setting Server Parameters
- Access Control
- Connection Settings
- Security and Authentication Settings
- Memory Settings
- Query Planner Settings
- WAL Settings
- Log Management
- Background Writer Settings
Creating and Managing Databases
- Object Hierarchy
- Creating Databases
- Users
- Access Control
- Creating Schemas
- Schema Search Path
User Tools – Command Line and GUI Interfaces
- Introduction to PSQL
- Conventions
- Connecting to Database
- PSQL Command Line Parameters
- Entering PSQL Commands
- PSQL Meta-Commands
- PSQL SET Parameters
- Information Commands
Security
- Authentication and Authorization
- Levels of Security
- conf File
- Object Ownership
- Application Access Parameters
SQL Primer
- Data Types
- Structured Query Language(SQL)
- Tables and Constraints
- Manipulating Data using
- INSERT, UPDATE and DELETE
- Creating Other Database Objects
- Sequences
- Views
- Indexes
- Domains
Backup, Recovery and PITR
- Backup Types
- Handling Large Databases
- Restoring SQL Dumps
- Cluster Dump
- Online Directory Backups
- Continuous Archiving
- Backup with Low-level API
- How to use pg_basebackup for Online Backups
- Point-In Time Recovery Concepts
Table Partition
- Partition types
- What is declarative partitioning?
- Explanation of new partitioning features
- Performance problems
- New partitioning performance features in PostgreSQL 12
Data Dictionary
- The Catalog Schema
- Information Tables
- Information Functions
- Administration Functions
- Information Views
Data Loading
- Loading flat files
- Import and export data using COPY
- Examples of COPY Command
- Using COPY FREEZE for performance
Maintenance Tasks
- Database Maintenance
- Maintenance Tools Optimizer Statistics
- Data Fragmentation
- Routine Vacuuming & Vacuuming Commands
- Transaction ID Wraparound
- Visibility Map File
- Per Table Thresholds
- Reindexing & Clustering
Tablespace
- Data Files Advantages
- Changing Default Tablespace
- Altering Tablespace
- Dropping Tablespace
PostgreSQL Replication
- Replication Architect
- Why is replication required?
- Features of replication
- Replication Mode
- Switchover/Switchback and Failover
- Logical Replication
Database Upgrade
- PostgreSQl Major version & minor version
- Upgrade Options
- Pg_Upgrade
Migration
- Why migrate to PostgreSQL?
- Migration process -overview
- Migration Analysis
- Migration challenges
- Data Migration challenges
Extensions & FDW
Performance Tuning
- Important Parameters
- Basic query tuning
- Query plan reading
- Indexes
PG-pool
- What is Pgpool
- Pgpool Architecture
- Features of Pgpool
- Pgpool Example
Tools for PostgreSQL
- Backup
- Replication
- High availability
- Monitoring
To see the full course content Download now
Course Prerequisites
- Basic knowledge of SQL and Database concepts is essential to learn PostgreSQL, and Knowledge of Linux environment is suggested but not mandatory.
Who can attend
The following job roles will get benefited from this training:
- Professionals getting started on PostgreSQL DBA projects
- Anyone wishing to add PostgreSQL DBA skills to their profile
Number of Hours: 30hrs
Certification
- PostgreSQL Associate Certification
- PostgreSQL Professional Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are 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 before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com
