PostgreSQL v12 Database Administration on Windows and Linux Free Download
7 Likes Comment

PostgreSQL v12 Database Administration on Windows and Linux, FreeTuts Download


PostgreSQL v12 Database Administration on Windows and Linux   Free Tutorial Download

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.



The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

  • PostgreSQL Process and Memory Architecture
  • Installation of PostgreSQL v12 – Windows and Linux
  • Setup PostgreSQL v12 Environment Variables – Windows and Linux
  • PostgreSQL Page Layout
  • Database Directory Layout
  • PostgreSQL Configuration Files
  • Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)
  • Createdb/Dropdb, Createuser/Dropuser Utility
  • Create Schema and Schema Search Path
  • Psql Interface Commands
  • Pg System Catalogs
  • Working with PostgreSQL Objects
  • CRUD Operations
  • Table Inheritance
  • Table Partitioning
  • Tablespace in PostgreSQL
  • Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)
  • Explain plan and Query Execution Cost
  • Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)
  • Data Fragmentation
  • Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon
  • Pgadmin 4
  • Uninstall PostgreSQL v12 on Windows and Linux
  • Bonus Module
Read more course:  Advanced Scripting & Tool Making using Windows PowerShell

Who this course is for:

  • Database Administrators
  • Accidental DBA’s
  • Developers
  • Architects and Analyst
  • Students
  • Anyone who is curious about PostgreSQL

 

Download  PostgreSQL v12 Database Administration on Windows and Linux Free

Go to Download Tutorials Page

Password : freetuts.download



You might like

About the Author: minhtri

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.