Develop Intelligence
Introduction to PostgreSQL
Learn how to install, configure, and administer the world's most advanced open source database, PostgreSQL.

The Introduction to PostgreSQL training course focuses on installing, configuring, and tuning PostgreSQL as an RDBMS for use with Java, PHP, Ruby, and .NET.

The PostgreSQL Administration training is structured around the most recent PostgreSQL 9.x release.

After this course, you will be able to:

  • Describe the advantages and disadvantages PostgreSQL has over other databases
  • Install PostgreSQL on a linux / unix platform
  • Perform basic configuration, including user setup, db design, monitoring, and logging
This course will be delivered in 3 Days

DI will work with you and your team to define the most appropriate delivery structure, schedule and dates. Structure, schedule and dates will be determined by project schedule, team availability and classroom availability. And of course, it will also be determined by DI’s instructor availability.

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

Call us at (877) 629-5631