Introduction to PostgreSQL Course

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

Download

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

Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.

about our training

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners

Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

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