Get in Touch
 Duration 14 hours

Course Outline

Introduction to PostgreSQL

  • Historical Overview of PostgreSQL
  • Core Capabilities and Features
  • Architectural Summary
  • Operational Constraints and Terminology

Deployment and Configuration

  • System Requirements
  • Installation via Package Managers and Database Initialization
  • Installation from Source Code
  • Client-Side Implementation
  • Database Server Lifecycle Management
  • Environment Configuration

SQL Language Fundamentals

  • SQL Syntax Standards
  • Data Definition Statements
  • Data Manipulation Operations
  • Query Formulation
  • Data Type Specifications
  • JSON Handling
  • Functions and Operators
  • Type Conversion Mechanisms
  • Indexing Strategies

Transactions and Concurrency Management

  • Transaction Integrity and Isolation Levels
  • Multi-Version Concurrency Control (MVCC)

Client Interface Options

  • Command Line Interface via psql
  • Graphical Interface via pgAdmin4

Server-Side Programming

  • Extending SQL Functionality
  • Trigger Implementation
  • The Rule System Framework
  • Procedural Language Integration
  • PL/pgSQL: SQL Procedural Language
  • Error Management Protocols
  • Cursor Utilization

Foreign Data Wrappers

  • Extension Framework in PostgreSQL
  • Integrating FDW into Databases
  • postgres_fdw Implementation
  • file_fdw Implementation
  • Alternative FDW Solutions

SQL Performance Tuning

  • Logging Mechanisms in PostgreSQL
  • Analysis of Query Plans
  • Query Optimization Techniques
  • Statistical Data Usage
  • Planner Parameter Configuration
  • Parallel Query Scanning
  • SQL Best Practices for Government Systems
  • Index Optimization
  • Table Partitioning Strategies

Requirements

Demonstrated proficiency in SQL

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories