PostgreSQL Bootcamp
PostgreSQL Bootcamp is an intensive 5-day PostgreSQL training course. PostgreSQL is the most advanced open-source database available anywhere, and the Big Nerd Ranch offers the most comprehensive PostgreSQL training available.
PostgreSQL is a sophisticated relational DBMS, supporting almost all SQL constructs, including subselects, transactions, triggers and user-defined types and functions.
PostgreSQL Bootcamp is taught on PostgreSQL 8.2., with 25 sessions made up of half lecture/questions and half student exercises.
Why Attend?
Getting a PostgreSQL server up and running is not difficult. Making a secure, high-performance, reliable database is. PostgreSQL Bootcamp is the only way to get hands-on, end-to-end coverage of PostgreSQL administration.
Reviews
Prerequisites
This class assumes attendees are familiar with:
- the Unix command line
- basic Unix administration
- simple SQL statements
- basic programming concepts
It is also helpful if attendees have some familiarity with simple PostgreSQL installation and administration.
Syllabus
| Section | Contents |
|---|---|
| Part 1 | Building and installing PostgreSQL |
| Part 2 | Creating a cluster with initdb |
| Part 3 | Configuring, starting, and stopping the server |
| Part 4 | Stupid psql tricks (and some really useful ones) |
| Part 5 | pgAdmin and phpPgAdmin |
| Part 6 | Creating databases and schemas |
| Part 7 | Users and access control |
| Part 8 | Logs |
| Part 9 | Security and OpenSSL |
| Part 10 | Backups |
| Part 11 | Monitoring |
| Part 12 | Replication with Slony-I |
| Part 13 | SELECT in-depth |
| Part 14 | JOIN and subqueries |
| Part 15 | Localization and Internationalization |
| Part 16 | Data types and table constraints |
| Part 17 | Large objects (Blobs) |
| Part 18 | Transactions |
| Part 19 | PL/pgSQL functions |
| Part 20 | C functions |
| Part 21 | Full-text indexing |
| Part 22 | Views |
| Part 23 | Triggers |
| Part 24 | Rules |
| Part 25 | Query plans and basic optimization |
| Part 26 | Advanced optimization and benchmarking |
| Part 27 | Dealing with the free space map and VACUUM |
| Part 28 | Dealing with the write-ahead log and checkpointing |
| Part 29 | Choosing hardware, operating systems, and file systems |
| Part 30 | pgpool |
| Part 31 | libpq (the C client library) |
| Part 32 | DBI (the Perl client library) |
| Part 33 | pgpool |
What's Included
Class price includes all class materials, a luxury room, three delicious meals a day, a stylish Big Nerd Ranch t-shirt, and ground transportation to and from the airport. Plan to arrive the afternoon or evening before your class begins and depart on the last day of your class after 4 PM.