[ FreeCourseWeb.com ] PostgreSQL v12 Database Administration on Windows and Linux
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 65 lectures (9h 23m) | Size: 1.87 GB
Comprehensive Guide to PostgreSQL v12 Database Administration : Walk-in a Beginner, Walk-Out an Expert
What you'll learn:
Understand PostgreSQL Process and Memory Architecture.
Install PostgreSQL v12 on Windows and Linux.
How to Setup Environment Variable on Windows and Linux.
PostgreSQL Directory Structure.
PostgreSQL Configuration Files.
How to use PSQL command line interface to connect to PostgreSQL.
How to Create Database/User/Schema from utility and Psql commands.
Learn how to use pg system catalogs.
CRUD operations on PostgreSQL.
Table Inheritance in PostgreSQL.
Partitioning in PostgreSQL using Table Inheritance.
Copy table from/to PostgreSQL.
How to Create/Move/Drop Tablespace.
Logical (pg dump, pgdumpall), Physical backup (Offline, Online).
Continuous Archiving and PITR.
What is Explain plan and how to calculate cost of query.
Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster).
What is Transaction Id Wraparound Failure and Vacuum Freeze.
How to use Pgadmin 4 Interface.
Uninstall PostgreSQL on Windows and Linux.
Requirements
Basic Knowledge of Database Concepts
Internet access is required to download PostgreSQL Server
Working Knowledge on Windows and Linux
Description
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.
Use Winrar to Extract. And use a shorter path when extracting, such as C: drive
ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
Get More Tutorials and Support Us -->> https://DevCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
