Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Khoá học
PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert ( Updated with Latest PostgreSQL V16)

image
50.000 VND
75 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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

  • Journey into Postgresql v13

  • Postgresql v13 - New Features

  • Let's Explore Postgresql v15

  • Postgresql v15 - New Features

  • Tour of Postgresql v16

  • Postgresql v16 - New Features

Bạn sẽ học được gì

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

Yêu cầu

  • Basic Knowledge of Database Concepts
  • Internet access is required to download PostgreSQL Server
  • Working Knowledge on Windows and Linux

Nội dung khoá học

20 sections

Introduction

2 lectures
PostgreSQL Introduction
08:03
PostgreSQL Page Setup
06:21

Installing PostgreSQL v12 on Windows and Linux

5 lectures
PostgreSQL System Requirement
01:06
Installing PostgreSQL v12 on Windows
09:11
Setup PostgreSQL Environment Variable on Windows
02:50
Installing PostgreSQL v12 on Linux
08:07
Setup PostgreSQL Environment Variable on Linux
07:02

PostgreSQL Architecture

5 lectures
Process and Memory Architecture
09:39
Postmaster Process
06:13
Utility Processes
05:17
Memory Segments
06:29
Physical Files in PostgreSQL
01:40

Database Cluster

3 lectures
PostgreSQL Cluster (Initdb, Start/Stop/Restart/Reload)
03:55
PostgreSQL Cluster Demo on Windows
12:04
PostgreSQL Cluster Demo on Linux
11:34

PostgreSQL Directory Layout

2 lectures
Database Directory Layout
13:56
Base Directory
08:10

Configuration Files

4 lectures
PostgreSQL.conf
11:28
PostgreSQL.Auto.conf
07:48
Pg_Ident.conf
05:07
Pg_Hba.conf
12:36

Create Objects(Database/User/Schema) and Privileges

4 lectures
Create/Drop Database
08:31
Create/Drop User
14:31
Create/Drop Schema and Search Schema Path
15:16
Grant/Revoke Privileges on Database Objects
11:06

Using Psql Command Line Interface

1 lectures
Psql Commands
19:47

Working with Pg System Catalog

1 lectures
Pg_Catalog & Time zones in PostgreSQL
22:07

CRUD Operations in PostgreSQL

5 lectures
CRUD Introduction
01:18
Create Table, Data Types, Constraints, Functions and Operators
19:06
Retrieve Data in PostgreSQL
16:00
Update Records in a Table
07:43
Delete Records in a Table
04:40

Table Inheritance, Table Partitioning and Copy Table in PostgreSQL

3 lectures
Table Inheritance
16:00
Table Partitioning using Inheritance
18:14
Copy Table
03:26

Working with Tablespace

4 lectures
Tablespace Introduction
04:29
Create Tablespace on Windows and Linux
08:14
Move Objects from Tablespace and Drop a Tablespace
05:44
Temporary Tablespace in PostgreSQL
03:58

Backup and Restore

13 lectures
Introduction to PostgreSQL Backups
03:03
Logical Backups on Windows and Linux
16:39
How to Compress and Split Dump Files
03:43
Restore Database using Logical Backups through Psql Interface
05:42
Restore Database using Logical Backups through Pg_Restore Utility
05:59
Offline Backups
06:10
Introduction to Online Backups
03:11
Setup Continuous Archiving In Windows
06:38
Setup Continuous Archiving In Linux
07:35
Online Low Level API Backup
07:26
Pg_Basebackup Utility
11:20
Point-In-Time-Recovery(PITR)
20:25
Point-In-Time-Recovery(PITR) - Demo
20:37

Maintenance in PostgreSQL

11 lectures
Introduction to Maintenance
01:29
How to Calculate Query Cost and Explain Plan
11:42
Updating Planner Statistics\Analyze
16:03
Vacuum Freeze
03:23
Data Fragmentation
01:43
Introduction to Vacuum and Vacuum Full
04:50
Transaction ID Wrap Around Failure
05:38
How to Vacuum a Database and Remove Data Fragmentation
19:51
Routine Re-Indexing
05:42
How to Cluster a Table
07:54
Auto-Vacuum in PostgreSQL
04:26

Introduction to Pgadmin 4 Interface

1 lectures
Pgadmin 4 - Demo
16:39

Uninstall PostgreSQL v12 From Windows and Linux

2 lectures
Uninstall PostgreSQL v12 From Windows - Demo
02:58
Uninstall PostgreSQL v12 From Linux - Demo
04:51

Bonus Module

4 lectures
Introduction to PostgreSQL Upgrade
12:22
PostgreSQL Upgrade using PG_Dumpall Utility.
24:31
Introduction to PG_Upgrade Utility
11:06
PostgreSQL Upgrade using PG_Upgrade Utility
20:54

Journey into Postgresql- v13

4 lectures
Introduction to Postgresql v13
02:01
Postgresql v13 - New Features Part 1
22:48
Postgresql v13 - New Features Part 2
10:04
Postgresql v13 - New Features Part 3
11:17

Let's Explore Postgresql -v15

4 lectures
Introduction to Postgresql v15
02:58
Postgresql v15 - New Features 1
13:41
Postgresql v15 - New Features 2
17:31
Postgresql v15 - New Features 3
14:22

Tour of Postgresql -v16

7 lectures
Introduction to Postgresql v16
01:50
Postgresql v16 - New Features 1
17:15
Postgresql v16 - New Features 2
05:30
Postgresql v16 - New Features 3 - Intro
02:25
Postgresql v16 - New Features 3 - Demo
08:14
Postgresql v16 - New Features 4
08:32
Postgresql v16 - New Features 5
03:41

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Getting Started with Embedded AI | Edge AI

Getting Started with Embedded AI | Edge AI

55 VND
50.000 VND
Hands-on Generative AI Engineering with Large Language Model

Hands-on Generative AI Engineering with Large Language Model

45 VND
50.000 VND
Building web APIs with Rust (advanced)

Building web APIs with Rust (advanced)

70 VND
50.000 VND
Building web APIs with Rust (beginners)

Building web APIs with Rust (beginners)

25 VND
50.000 VND
Master 3D content creation tools in Blender. With 6 projects

Master 3D content creation tools in Blender. With 6 projects

80 VND
50.000 VND
Database Relationships

Database Relationships

25 VND
50.000 VND
Making Your First Game: GameMaker Studio 2

Making Your First Game: GameMaker Studio 2

50 VND
50.000 VND
Data Engineering using Kafka and Spark Structured Streaming

Data Engineering using Kafka and Spark Structured Streaming

80 VND
50.000 VND
Thiết kế website wordpress chuẩn SEO lên TOP Google.

Thiết kế website wordpress chuẩn SEO lên TOP Google.

499.000 VND
99.000 VND
Test Java applications with JUnit 5, Mockito, Testcontainers

Test Java applications with JUnit 5, Mockito, Testcontainers

75 VND
50.000 VND
C++ Komplettkurs: Praxisnahe und Moderne C++ Programmierung

C++ Komplettkurs: Praxisnahe und Moderne C++ Programmierung

75 VND
50.000 VND
Learn Korean! Start Speaking Korean Now!

Learn Korean! Start Speaking Korean Now!

85 VND
50.000 VND
React Native Ultimate - Phát Triển Ứng Dụng Mobile

React Native Ultimate - Phát Triển Ứng Dụng Mobile

95 VND
50.000 VND
THÀNH THẠO ORACLE SQL TỪ SỐ 0 - 2024

THÀNH THẠO ORACLE SQL TỪ SỐ 0 - 2024

30 VND
50.000 VND
Java Spring REST Ultimate từ A tới Z

Java Spring REST Ultimate từ A tới Z

185 VND
50.000 VND
[今更聞けない！] 損しないための社会人マナー・ビジネスマナー講座

[今更聞けない！] 損しないための社会人マナー・ビジネスマナー講座

25 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi