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
Understand PostgreSQL Process and Memory Architecture.
Comprehensive Guide to PostgreSQL v12 Database Administration : Walk-in a Bner, Walk-Out an Expert
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.
Basic Knowledge of Database Concepts
Internet access is required to PostgreSQL Server
Working Knowledge 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 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 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--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
Database Administrators
Accidental DBA's
Developers
Architects and Analyst
Students
Anyone who is curious about PostgreSQL
DOWNLOAD
uploadgig
https://uploadgig.com/file/download/CC0e2cb33d816839/ad7ePMDW__PostgreSQL.part1.rar
https://uploadgig.com/file/download/377c9B04ffd28A9d/ad7ePMDW__PostgreSQL.part2.rar
https://uploadgig.com/file/download/627bC57577188729/ad7ePMDW__PostgreSQL.part3.rar
https://uploadgig.com/file/download/554A5e6ad20b6e47/ad7ePMDW__PostgreSQL.part4.rar
rapidgator
https://rapidgator.net/file/30a966708b0f3265a66d33f66e204104/ad7ePMDW__PostgreSQL.part1.rar.html
https://rapidgator.net/file/dca27bf3c7949489f946b0a2ebeb4f18/ad7ePMDW__PostgreSQL.part2.rar.html
https://rapidgator.net/file/c21a699b50952ba789eda0946d6631ae/ad7ePMDW__PostgreSQL.part3.rar.html
https://rapidgator.net/file/3f36301a0513f5ebf3ebe20b786b7b92/ad7ePMDW__PostgreSQL.part4.rar.html
nitroflare
http://nitroflare.com/view/DB93C7C71EE8F12/ad7ePMDW__PostgreSQL.part1.rar
http://nitroflare.com/view/027389E7CBB904B/ad7ePMDW__PostgreSQL.part2.rar
http://nitroflare.com/view/003F69783A7B121/ad7ePMDW__PostgreSQL.part3.rar
http://nitroflare.com/view/C8067672003CB16/ad7ePMDW__PostgreSQL.part4.rar
Feel free to post your PostgreSQL v12 Databases Administration on Windows and Linux Free Download, torrent, subtitles, free download, quality, NFO, Dangerous PostgreSQL v12 Databases Administration on Windows and Linux Torrent Download, free premium downloads movie, game, mp3 download, crack, serial, keygen.