-->
img

PostgreSQL with Relational Database Design Course

Curriculum

Database Design and PostgreSQL

  • Introduction to RDBMS
  • Database Design Principles
  • Entity Relationship (ER) Modal
  • Codd's Rules, ACID Properties
  • Normalization
  • PostgreSQL Introduction and Architecture
  • PostgreSQL CLI & GUI Interfaces

SQL and PL/pgSQL

  • SQL (DDL/DML/DTL/DCL/DRL)
  • SQL Data Types and Constraints
  • SQL Queries (Advance - Joins & Subqueries)
  • Sequence, Views and Indexes
  • Bulk Insert/Copy and Import Export

PostgreSQL Administration

  • PostgreSQL Installation (Linux)
  • Directory Structure and Permissions
  • PostgreSQL Extensions
  • PostgreSQL Data Dictionary
  • Server Configuration
  • Logging and Performance Configuration
  • Client Authentication and Security
  • Backup and Restore
  • Upgrading PostgreSQL

PostgreSQL HA and Replication

  • Synchronous vs Asynchronous Replication
  • Streaming Master-Slave Application
  • Write Ahead Logs (WAL) and Point In Time
  • Recovery (PITR)
  • Connection Pooling