PostgreSQL v12 Database Administration on Windows and Linux

$2.99

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!