Brochure
Enquire
- PosgreSQL Platform
- Facts about PostgreSQL
- History of PostgreSQL
- Major Features
- General Database Limits
- Common Database Object Names
- Home
- Mindmajix Technologies
- Courses
- PostgreSQL Training and Certification
PostgreSQL Training and Certification
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
Fees information
₹ 9,000 ₹11,250
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Introduction to PostgreSQL
Installation
- OS User and Permissions
- Installation Option
- 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
- pg_hba.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
Practice Test And Interview Questions
Articles
Popular Articles
prev
next
Latest Articles
prev
next
