We Are Conducting PostgreSQL Corporate and Individual Training

Rayafeel academy brings you a virtual, hands on PostgreSQL training, by the end of which you will learn the fundamental concepts of this open source database. With in-depth tutorials and a practical, hands on workshop, you will learn about the basics and advanced features of PostgreSQL and how to develop applications with PostgreSQL as the back-end.

You will be led by our team of expert trainers who will hand hold you through the concepts of database installation and connection, writing queries to manage the database, and SQL statements to operate PostgreSQL. You will also get the PostgreSQL certification on successful completion of the course..

YOU WILL LEARN TO –

• How relational databases work and how are they relevant in today’s times
• What sort of a database management system is PostgreSQL
• How to install and setup PostgreSQL and run queries on it
• How to create applications with PostgreSQL as a back end database management system

WHY Rayafeel:

• Get Mentored by Industry Practitioners: Rayafeel not only provides trainers for professional courses, we provide you with Industry Experts who are currently working in the field.
• Immersive Hands-on Trainings: All our training sessions are based on Learn by-doing method and hence every trainee learns by being immersed in projects that they develop along with their mentor. Every session is a combination of practical exercises, theoretical learning, hands-on exercises, group discussions, simulations and intensive Q & A sessions.
• Build a Portfolio of Projects: Rayafeel professionals help your employees to not only learn new concepts but also how to apply the theory to practice.
• Mentoring Sessions: Rayafeel professionals can also be retained even after the training session to help incorporate the learned concepts in a particular project and further mentoring.

Rayafeel’S TRAINING DELIVERY METHOD:

• Hands-on Training with immersive, interactive and practice sessions.
• Administered Classroom Assignments, Group Discussions, Simulation based learning and Q & A Sessions
• Learning the concepts through examples and Build a project through the course of training
• Post Training Sessions from Industry Experts(2 – 4 Hours Online sessions)
• Mentors evaluate / review the Project (or)
• Deep dive into specific concepts (or)
• Assistance provided in implementing the technology in existing / new projects
• Exclusive Mentor Support provided via email up to 3 Months.

Course Contents :

Curriculum 1:

1. Introduction and Overview of PostgreSQL
2. PostgreSQL System Architecture
3. Architectural Summary
4. Process Architecture
5. Database Clusters
6. PostgreSQL Terminology
7. Physical Database Architecture
8. Data File Architecture
9. Database Server
10. Installation Using PostgreSQL Binary Windows
11. Installation from Source
12. Creating a database cluster
13. Starting and Stopping the Server (Other)
14. Lab Exercise – Installation
15. Install PostgreSQL from source
16. Create a database cluster
17. Start the database server
18. Connect to the server using psql
19. Stop the database server

Curriculum 2 :

1. Configuration
2. Setting PostgreSQL Parameters
3. Access Control
4. Connection Settings
5. Security and Authentication Settings
6. Configure client/server connectivity
7. Memory Settings
8. Free Space Settings
9. Kernel Resource Settings
10. Log Management
11. Background Writer Settings
12. Vacuum Cost Settings

Curriculum 3:

1. Create and Managing PostgreSQL Database and Security
2. USERS
3. GROUPS
4. ROLES
5. Object Ownership
6. Schemas and Search Paths
7. Lab to create USERS, SCHEMAS, ROLES, Alter SEARCH_PATH
8. GRANT and REVOKE privileges
9. Levels of security: pg_hba.conf, schemas and users and table level
10. pg_hba.conf

Curriculum 4

1. Moving Data with PostgreSQL and Backup and Recovery
2. COPY
3. Perform a Logical Backup Using PG_DUMP
4. Perfomr Entire Cluster Backup using PG_DUMPALL
5. Filesystem Level Backup (Hot and Cold)
6. Server To Server Backup Using BART and PG_ADMIN Tools
7. PITR – Point in Time Recovery
8. pg_start_backup and pg_stop_backup
9. Creating a base backup
10. Archive Backup Local and Standby
11. Recovery file parameters
12. Lab to test PITR

Curriculum 5:

1. Routine Database Maintenance Tasks
2. Routine Vacuuming
3. Recovering Disk Space
4. Vacuum Full
5. Updating Planner Statistics
6. Preventing Transaction ID Wraparound Failures
7. Routine Reindexing

Curriculum 6:

1. Performance Tuning
2. Explain and Explain Analyze
3. Forcing Query Plan Selection
4. Indexing
5. Log Management
6. Clustering

Curriculum 7:

1. PostgreSQL Partitioning and Table spaces
2. Partition Methods
3. Partition Setup
4. Partition Table Explain Plan
5. Table space Management

Curriculum 8

1. High Availability and Replication
2. Hot Standby / Warm Standby
3. Why Use Replication?
4. Hot Streaming Replication
5. Replication Limitations and Monitoring log shipping
6. Replication Configuration and check Logs

Curriculum 09

1. Connection Pooling
2. Why Connection Pooling?
3. Pgpool-II setup
4. Pgbouncer setup

Curriculum 10

1. Advance Monitoring Techniques
2. Importance of Monitoring
3. PGFouine/pg_badger – Log Analyzer

Curriculum11

1. Advance Monitering Tools(community and EDB)
2. Monitering the Database using Pg_admin and pgbadger
3. Pem server(Enterprise Manager). Handle more than 10 server one window
4. pg_client, pg_agent
5. Ora2pg(migration)-oracle to postgres Migration
6. Edb Migration Tool Kit

Note : To access the full course content Please enroll  the course or reach out to below contact if you are facing issue when the enrolling the course.

PostgreSQL Training Contents