PostgreSQL Administration: Hands-On Training
Three-day, instructor-led, hands-on PostgreSQL course for DBAs and IT pros covering installation, configuration, management, optimization, backup and recovery, performance tuning, and routine maintenance across multi-platform environments.
What you'll learn
- Install and configure PostgreSQL on Linux/UNIX and Windows platforms
- Manage clusters, schemas, roles, tablespaces, and access control
- Implement robust backup, recovery, and disaster recovery strategies
- Optimize PostgreSQL performance and scalability for growing workloads
- Monitor server performance and perform routine database maintenance
Skills you'll gain
- Install and configure PostgreSQL on multiple platforms
- Administer PostgreSQL instances, schemas, roles, and tablespaces
- Implement and manage backup, recovery, and disaster recovery solutions
- Configure security, fine-grained access control, and role management
- Create and maintain indexes to improve query performance
- Manage transactions, isolation levels, and concurrency issues
- Configure logging, extensions, and tablespaces for scalable storage
- Use EXPLAIN and ANALYZE for query optimization and performance tuning
- Set up autovacuum, routine maintenance, and monitoring of PostgreSQL servers
Prerequisites
- • Basic knowledge of relational database concepts and SQL
- • Experience using command-line tools for administration tasks
- • Basic experience with Linux/UNIX and Windows operating systems
- • Prior experience as a database administrator or similar technical role is beneficial but not required
Who this course is for
- → Database administrators working with or moving to PostgreSQL
- → IT professionals responsible for managing PostgreSQL databases
- → Technical staff needing hands-on PostgreSQL administration skills
Provider
Learning Tree
Related Courses
Introduction to Python Training
Learn to rapidly develop feature-rich applications in Python using built-in statements, functions, collections, object-oriented features, data accessors, and library modules in this 3-day instructor-led course.
Python Bootcamp
Python Bootcamp covers fundamentals of Python programming, including control structures, advanced data types, functions, modules, packages, multithreading, exception handling, file handling, GUI design, and database connectivity, preparing learners for future work in data science and machine learning.
Systems Engineering
This course introduces Systems Engineering principles across the lifecycle of complex systems, covering system design, architecture, requirements analysis, modeling, verification, lifecycle models (Waterfall, V-Model, Spiral, Agile), SysML, risk management, trade-off analysis, and a Smart Home Security System project.
IT Systems Design and Analysis
Prepare to design, analyze, and evaluate IT systems using data flow diagrams, ERDs, UML, and feasibility analysis. Learn to assess existing systems, identify inefficiencies, compare solution alternatives, and deliver a digital transformation strategy through a hands-on final project.
Hands On FullStack Development Course with Infrastructure Management Product implementation
A 180-day, project-first full-stack infrastructure course where you build and operate production-grade services with CI/CD, testing, observability, and operational playbooks, aimed at taking you from toy projects to real-world deployment experience.
Learn Typescript
Hands-on introduction to TypeScript fundamentals and their application in real projects. Learn core typing concepts, advanced TypeScript features, and how to use TypeScript with React and Express while building safer, more maintainable JavaScript applications.