{"product_id":"postgresql-administration-hands-on-training","title":"PostgreSQL Administration: Hands-On Training","description":"\u003cdiv\u003e\u003cp\u003eUnlock the full potential of PostgreSQL with this comprehensive three-day, instructor-led course. Designed for database administrators and IT professionals, this hands-on training equips you with the skills to install, configure, manage, and optimize PostgreSQL databases across multi-platform environments. Learn to implement robust backup and recovery strategies, enhance performance and scalability, and ensure efficient routine maintenance. Whether you're transitioning to PostgreSQL or expanding your expertise, this course provides the practical knowledge needed to thrive in today’s database landscape.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003ePostgreSQL Administration: Hands-On Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGain hands-on experience installing and configuring PostgreSQL on diverse platforms, ensuring you can adapt to any environment.\u003c\/li\u003e\n\u003cli\u003eMaster the skills to efficiently manage database clusters, schemas, roles, and tablespaces, enabling seamless organization and access control.\u003c\/li\u003e\n\u003cli\u003eLearn to implement reliable backup, recovery, and disaster recovery solutions to safeguard critical data.\u003c\/li\u003e\n\u003cli\u003eDiscover techniques to optimize PostgreSQL databases for peak performance, even as workloads grow.\u003c\/li\u003e\n\u003cli\u003eAcquire tools and strategies for routine database upkeep and server performance monitoring, ensuring long-term stability and efficiency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cb\u003eBasic Knowledge of RDBMS Concepts:\u003c\/b\u003e Familiarity with relational database principles, SQL queries, and common database objects like tables, indexes, and views.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eExperience with Command-Line Tools:\u003c\/b\u003e Comfort with using command-line interfaces for database administration tasks.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eUnderstanding of Operating Systems:\u003c\/b\u003e Basic experience with Linux\/UNIX and Windows operating systems, including file systems and user account management.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eTechnical Background:\u003c\/b\u003e Prior experience as a database administrator or similar technical role is beneficial but not required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree exam included.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003ePostgreSQL Administration Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDay 1: Foundations of PostgreSQL Administration\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 1: Course Introduction\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eOverview of course materials and agenda.\u003c\/li\u003e\n\u003cli\u003eIntroductions and expectations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 2: Installation and Configuration\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePostgreSQL versioning.\u003c\/li\u003e\n\u003cli\u003eInstallation on Linux\/UNIX platforms.\u003c\/li\u003e\n\u003cli\u003eBasic server configuration.\u003c\/li\u003e\n\u003cli\u003ePost-installation setup and account management.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 3: PostgreSQL Architecture\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePostgreSQL instance overview.\u003c\/li\u003e\n\u003cli\u003eData processing, shared memory, and directory structures.\u003c\/li\u003e\n\u003cli\u003eConfiguration files and WAL architecture.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 4: Client Applications and Database Setup\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIntroduction to client tools (psql, pgAdmin).\u003c\/li\u003e\n\u003cli\u003eDatabase creation, configuration, and management.\u003c\/li\u003e\n\u003cli\u003eTroubleshooting common client connection issues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDay 2: Advanced Administration and Security\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 5: PostgreSQL Schemas\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eSchema concepts and management.\u003c\/li\u003e\n\u003cli\u003eInformation and system catalog schemas.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 6: Role Management\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eRole creation, attributes, and membership.\u003c\/li\u003e\n\u003cli\u003eTroubleshooting role access issues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 7: Fine-Grained Access Control\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eGrant and revoke commands.\u003c\/li\u003e\n\u003cli\u003eManaging column-level permissions and schema privileges.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 8: Index Creation and Management\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIndex types and best practices.\u003c\/li\u003e\n\u003cli\u003ePartial, unique, and multi-column indexes.\u003c\/li\u003e\n\u003cli\u003eReindexing and maintaining indexes efficiently.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 9: Transactions and Concurrency\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTransaction properties and isolation levels.\u003c\/li\u003e\n\u003cli\u003eMulti-version concurrency control.\u003c\/li\u003e\n\u003cli\u003eDeadlock detection and advisory locks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDay 3: Optimisation, Maintenance, and Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eChapter 10: Database Structure and Tablespaces\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePhysical storage layout.\u003c\/li\u003e\n\u003cli\u003eCreating and managing tablespaces.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 11: Logging and Extensions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfiguring PostgreSQL logging.\u003c\/li\u003e\n\u003cli\u003eInstalling and managing extensions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 12: Backup and Recovery\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eMethods for database backup and restore.\u003c\/li\u003e\n\u003cli\u003epg_dump, pg_restore, and point-in-time recovery.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 13: Query Optimisation and Performance Tuning\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUsing EXPLAIN and ANALYZE to optimise queries.\u003c\/li\u003e\n\u003cli\u003eIndex and query planner statistics.\u003c\/li\u003e\n\u003cli\u003eMemory settings and performance tuning parameters.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChapter 14: Routine Maintenance and Monitoring\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfiguring autovacuum and routine cleanup tasks.\u003c\/li\u003e\n\u003cli\u003eMonitoring activities and statistics.\u003c\/li\u003e\n\u003cli\u003eEfficiently populating databases.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B64US \/ 2026-07-29T09:00:00 \/ Herndon, VA","offer_id":47534202781915,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA51US \/ 2026-10-28T09:00:00 \/ Herndon, VA","offer_id":48216558665947,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A39US \/ 2027-01-27T09:00:00 \/ Herndon, VA","offer_id":48216558698715,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A27US \/ 2027-04-28T09:00:00 \/ Herndon, VA","offer_id":48696372592859,"sku":"US-2112-IL","price":2228.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/postgresql-administration-hands-on-training","provider":"Learning Tree International","version":"1.0","type":"link"}