PostgreSQL DBA Course

All Levels

Created by Ram Niwas Sangwan Last Updated 28/10/2022 16:07

₹37,500.00 ~~₹38,000.00~~ 1.32% off

What's Included

20 Lectures
8 Assignments
Access on tablet and phone
Certificate of completion

Course Curriculum

Expand all Collapse all

20 Lectures

00:00

Getting Started with PostgreSQL 9 Lectures

PGSQL 1. PostgreSQL Introduction and Features

PGSQL 2. Installing PostgreSQL

PG Lab 1 Installing PostgreSQL

PGSQL 3. PostgreSQL Architecture

PGSQL 4. Getting Started with PostgreSQL

Lab 2. Getting Started with PostgreSQL

PGSQL 5. The logical layout of PostgreSQL

PGSQL 6. The Physical Layout

Lab 3. PostgreSQL Storage Management

Database and Storage Management 7 Lectures

Scalibility 5 Lectures

Performance and Security 2 Lectures

Maintenance and Optimization 5 Lectures

Description

Course Objectives

Understand the PostgreSQL architecture
Installing PostgreSQL
Create databases
Get used to the command line interface: psql
Understand backup and restore procedures in PostgreSQL
Understand extensions in PostgreSQL
Create a hot standby database
Understand the optimizer, statistics and vacuum
Understand monitoring tools
Upgrades in PostgreSQL

Training Method

Recording of Presentation with numerous exercises, case studies, and live demos
Discussions forums and ask a question.
Hands on Lab assignments
Handouts for reference
Doubt clearing sessions by sharing screen one on one.

Target Audience

Database administrators (DBA) as well as network, system and application administrators responsible for or supporting PostgreSQL databases

PostgreSQL Course Topics

Instructors

(0.00)

19 Courses

228 Students

2 Reviews

Ram Niwas Sangwan