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
The syllabus is listed below, but our extensive knowledge of PostgreSQL enables us to customize the course to your needs and speak on topics that may not be in the outline. Let us know what you want.
| 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 |
Price
A five-day class, a student guide, a luxury room, three delicious meals a day, a stylish "Big Nerd Ranch" t-shirt, and transportation to and from the airport for $3500. Plan to arrive on Sunday evening and depart on Friday afternoon.
When the class is offered in Europe, the price is €2800 plus VAT. (€2600 plus VAT if you register at least five weeks before the class begins.)