PostgreSQL v12 Database Administration on Windows and Linux | Database Design & Development Online Course by Udemy

Development Online Course by Udemy, On Sale Here

Comprehensive Guide to PostgreSQL v12 Database Administration: Walk-in a Beginner, Walk-Out an Expert

An excellent training about Database Design & Development

PostgreSQL v12 Database Administration on Windows and Linux

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 ArchitectureInstallation of PostgreSQL v12 – Windows and Linux Setup PostgreSQL v12 Environment Variables – Windows and LinuxPostgreSQL Page LayoutDatabase Directory LayoutPostgreSQL Configuration FilesCluster in PostgreSQL (Initdb, Start/Stop, Reload/Restart Cluster)Createdb/Dropdb, Createuser/Dropuser UtilityCreate Schema and Schema Search Path Psql Interface CommandsPg System CatalogsWorking with PostgreSQL ObjectsCRUD OperationsTable Inheritance Table PartitioningTablespace in PostgreSQLBackup, Continuous Archiving and PITR (Point-in-Time-Recovery)Explain plan and Query Execution CostMaintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)Data FragmentationTransaction ID wraparound, Vacuum freeze, Auto Vacuum DemonPgadmin 4 Uninstall PostgreSQL v12 on Windows and LinuxBonus Module

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE