Udemy - PostgreSQL Database Administration Complete Course

PostgreSQL Database Administration Complete Course

https://WebToolTip.com

Published 1/2026
Created by Muhammad Riaz Uddin
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 30 Lectures ( 3h 29m ) | Size: 2.34 GB

Master PostgreSQL Administration, Performance Tuning, Security and Backups.

What you'll learn
✓ Introduction of PostgreSQL
✓ Installing and Setting Up PostgreSQL
✓ PostgreSQL Tools
✓ Understanding Databases, Tables, and Schemas
✓ Numeric, Text, Date, Boolean, JSON
✓ Creating, Updating, and Deleting Tables
✓ Primary Keys, Foreign Keys, and Constraints
✓ SELECT, INSERT, UPDATE, and DELETE Statements
✓ Filtering Data with WHERE, ORDER BY, and LIMIT
✓ Using DISTINCT, GROUP BY, and HAVING
✓ INNER, LEFT, RIGHT, FULL
✓ One-to-One, One-to-Many, and Many-to-Many Relationships
✓ Composite Keys and Foreign Key Constraints
✓ JSON and JSONB Data Types in PostgreSQL
✓ Understanding Indexes in PostgreSQL
✓ Optimizing Queries for Large Datasets
✓ Creating and Managing Users and Roles

Requirements
● Basic SQL knowledge is helpful but not required
● No prior PostgreSQL administration experience needed