PostgreSQL v12 Database Administration on Windows and Linux

Format: MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, Stereo
Category: eLearning | Language: English + .srt | Duration: 65 Lectures (9 hours, 23 mins) | File Size: 1.87 GB

Course Title:
Comprehensive Guide to PostgreSQL v12 Database Administration
Tagline: Start as a Beginner, Finish as an Expert!

What You’ll Learn:

• PostgreSQL Architecture: Gain a deep understanding of PostgreSQL’s process and memory structures.
• Installation: Set up PostgreSQL v12 on both Windows and Linux.
• Environment Configuration: Configure environment variables on Windows and Linux.
• Directory and Configuration Files: Understand PostgreSQL's directory layout and key configuration files.
• PSQL Command Line: Use the PSQL interface for connecting to PostgreSQL.
• Database Management: Create databases, users, and schemas through utilities and PSQL commands.
• System Catalogs: Explore PostgreSQL's pg system catalogs.
• CRUD Operations: Execute basic Create, Read, Update, and Delete operations in PostgreSQL.
• Table Inheritance: Understand and apply table inheritance for data structuring.
• Table Partitioning: Partition data using inheritance.
• Table Copying: Copy tables to and from PostgreSQL.
• Tablespaces: Create, move, and drop tablespaces.
• Backups and Recovery: Perform logical (pg_dump, pg_dumpall) and physical (offline, online) backups.
• Archiving and PITR: Implement continuous archiving and point-in-time recovery.
• Query Optimization: Use explain plans to assess query costs.
• Database Maintenance: Maintain PostgreSQL with planner statistics, vacuuming, reindexing, and clustering.
• Transaction ID Wraparound: Prevent failures with Vacuum Freeze.
• PgAdmin 4: Manage PostgreSQL through the PgAdmin 4 interface.
• Uninstallation: Remove PostgreSQL from Windows and Linux environments.

Requirements:

• Basic database knowledge
• Internet access to download PostgreSQL Server
• Basic Windows and Linux knowledge

Description:
PostgreSQL is an advanced, open-source Object-Relational Database Management System (ORDBMS) with features like Multi-Version Concurrency Control (MVCC), point-in-time recovery, tablespaces, replication, and online backups. With support for SQL and JSON querying, PostgreSQL is scalable and adaptable, handling international character sets and Unicode.

Extraction Tip:
Use WinRAR for file extraction and shorten paths (e.g., C: drive). WinRAR also allows renaming long files or folders if Windows Explorer encounters issues.

Welcome to your PostgreSQL journey!