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