PostgreSQL Database Administration on Windows/Linux- Part 1

Udemy
Deal Score+2
Deal Score+2

Udemy Coupon Code for PostgreSQL Database Administration on Windows/Linux- Part 1 Course. PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert ( Updated with Latest PostgreSQL V16)

Created by Sadiq Basha | 13.5 hours on-demand video course

PostgreSQL Database Administration Course Overview

PostgreSQL Database Administration on Windows/Linux- Part 1

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 PostgreSQL Database Administration on Windows/Linux- Part 1 course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

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.
  • Bonus Module
  • Course Extra Documents
  • Journey into Postgresql v13
  • Postgresql v13 – New Features
  • Let’s Explore Postgresql v15
  • Postgresql v15- New Features

SQL and PostgreSQL for Beginners: Become an SQL Expert Best seller

SQL & PostgreSQL for Beginners: Become an SQL Expert Become an Expert in SQL and PostgreSQL: Master SQL …

Comprehensive SQL Course:Hands-on Project & Coding Exercises

Udemy Coupon Code for Comprehensive SQL Course:Hands-on Project & Coding Exercises. Become a Confident SQL …

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours Learn about Subqueries, CTEs, Indexes, PL/SQL, …

Who this course is for

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

Taught by Sadiq Basha

Josh Smith
Josh Smith

The Couponos team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.

      Udemy Coupon & Discount - July 2024

      Gain access to over 11,000+ courses for just $16.58 per month with Udemy Personal Plan

      Udemy Promotions For the week

      Learn Data Science. Courses starting at $12.99

      Promo Code: UDEAFFDS0724