PostgreSQL
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.
What You’ll Learn
Upon completion of PostgreSQL, the student will be able to:
PostgreSQL Syllabus
| PostgreSQL |
Click to Hide |
| 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 |
Requirements
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.
Reviews
For information or to enroll in a class in United States: (404) 478-9005
For information or to enroll in a class in Netherlands: +31 20 708 4546
For information or to enroll in a class in Germany: +49 931 9911 485
For information or to enroll in a class in Australia: +1 404 478 9005
