Hamburger Icon

Introduction to PostgreSQL

Course Summary

The Introduction to PostgreSQL training course focuses on installing, configuring, and tuning PostgreSQL as a Relational Database Management System (RDBMS) for use with Java, Hypertext Preprocessor (PHP), Ruby, and .NET. The training is structured around the most recent PostgreSQL 9.x release.

The course begins with an overview of PostgreSQL including installation, architectural fundamentals, and creating and accessing a database. Next, students will review the SQL language which includes concepts, creating tables, populating tables, querying, joins, and functions. With the foundation laid, the course then dives into PostgreSQL advanced features, internals, installation, and server setup. The course concludes with a lesson on server configuration, managing databases, routing maintenance tasks, backing up and restoring, and monitoring database activity.

Purpose
Learn how to install, configure, and administer PostgreSQL, the world's most advanced open source database.
Audience
Experienced Developers and Administrators wanting to have a production-quality command of PostgreSQL.
Role
System Administrator
Skill Level
Intermediate
Style
Hack-a-thon - Learning Spikes - Workshops
Duration
3 Days
Related Technologies
PostgreSQL | SQL

 

Productivity Objectives
  • Describe the advantages and disadvantages of PostgreSQL vs. other databases
  • Demonstrate how to install PostgreSQL on a Linux/Unix platform
  • Administer basic configuration, including user setup, database design, monitoring, and logging

What You'll Learn:

In the Introduction to PostgreSQL training course, you'll learn:
  • Getting Started with PostgreSQL
    • Installation
    • Architectural Fundamentals
    • Creating a database
    • Accessing a database
  • Review of the SQL Language
    • Concepts
    • Creating Tables
    • Populating Tables
    • Querying
    • Joins
    • Functions
  • Advanced Features
    • Views
    • Foreign Keys
    • Transactions
    • Window Functions
    • Inheritence
  • Overview of PostgreSQL internals
  • Installation from Source
    • Requirements
    • Getting the source
    • Upgrading
    • Installation Procedure
    • Post-installation
  • Server Setup and Operation
    • The PostgreSQL user account
    • Creating a Database cluster
    • Starting the Database server
    • Managing kernel resources
    • Shutting down the server
    • Securing the server
  • Server Configuration
    • Parameters
    • File locations
    • Connections and Authentication
    • Resource consumption
    • Error reporting and logging
    • Runtime statitistics
    • Vacuuming
    • Versioning and Lock management
  • Managing Databases
    • Creating databases
    • Template databases
    • Database configuration
    • Destroying a database
    • Tablespaces
  • Routing Maintenance Tasks
    • Routine Vacuuming
    • Routine reindexing
    • Log file maintenance
  • Backup and Restore
    • SQL Dump
    • File system level backup
    • Continuous archiving
    • Warm standby servers
  • Monitoring DB Activity
    • Unix tools
    • Statistics collector
    • Viewing locks
    • Dynamic tracing
  • PostgreSQL Internals
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.