PostgreSQL
Learn PostgreSQL
RisingStar Tech provides a comprehensive PostgreSQL training program designed to empower DBA aspirants with the skills and knowledge needed for a successful career. Our training options include self-paced videos and live online interactive sessions, totaling 28 hours of engaging learning content. The curriculum covers essential theory, practical discussions on complex DBA Administration scenarios, and real-world use cases. Additionally, the training aligns with both PostgreSQL Associate and Professional Certifications Exams, ensuring a comprehensive understanding of the subject matter. Upon completion, learners will benefit from continued support, including job-search assistance and mock interviews, to enhance their career prospects in the field of PostgreSQL.
PostgreSQL Training
July Ist
Mon-Fri
Timing
9:00 AM – 11:00 AM
Aug Ist
Mon-Fri
Timing
9:00 AM – 11:00 AM
Sep Ist
Mon-Fri
Timing
9:00 AM – 11:00 AM
Light Package
For Advanced
Full Package
For Beginners
Courses Include
30 Hours of Session
10 Hours of Lab
Flexible Schedule
One-on-One Doubt Session
Real Time Project Use
Certificate Oriented Curriculum
PostgreSQL Content
Below, you will find comprehensive details of the PostgreSQL course, covering all the essential aspects you will be exposed to throughout the program.
PostgreSQL Course
RisingStar Tech offers an industry-focused PostgreSQL course curated by our expert DBA professionals. This comprehensive curriculum is designed to provide you with a solid foundation in PostgreSQL fundamentals, advanced enterprise architecture, and performance tuning. By enrolling in our PostgreSQL training, you will gain the in-demand skills required for successful careers in Database Administration, ensuring you are well-equipped to meet the industry’s needs.
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
- 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
RisingStar Tech offers advanced PostgreSQL Interview Questions And Answers along with PostgreSQL Sample Resumes. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.
Benefits of Learning PostgreSQL in RisingStar Tech, Vancouver
Learning PostgreSQL with RisingStar Tech offers numerous benefits. It equips you with an in-demand skill set, opening up a wide range of career opportunities in Database Administration. The practical training approach, focusing on real-world use cases, enables you to apply your knowledge effectively. By completing the course, you can obtain industry-recognized certifications and receive job placement assistance to kickstart your career with confidence. Gain expertise in PostgreSQL with RisingStar Tech and unlock your potential in the field of Database Administration.
PostgreSQL Training In Vancouver
July 1st
Mon-Fri(21 Days)Timing 07:00 AM to 09:00 AM
August 1st
Mon-Fri(21 Days)Timing 07:00 AM to 09:00 AM
September 1st
Mon-Fri(21 Days)Timing 07:00 AM to 09:00 AM
