|
 Course
Objective
Getting a PostgreSQL server up and running is not difficult. Making a secure, high-performance, reliable database is. This PostgreSQL course will give you hands-on knowledge of PostGresSQL Administration & Tuning. Learn from our instructors many years of experience and get productive in just one week.
What will you learn
- Ten basic steps for installing PostgreSQL
- Understanding tables and types in PostGreSQL
- Building psql and graphical clients
- Setting up ODBC and JDBC drivers
- Simple and complicated psql hacks
- Advanced table structures, Arrays, Indices, transactions and cursors
- Authentication and Encryption
- Adding PL/pgSQL to your database
- Starting, Stopping and Maintaining your PostgreSQL
- Backing up and restoring data
- Running the SLONY-1 Replication System
- Optimizing PostgreSQL and benchmarking
- Replication with SLONY-I
- OO Database Concepts
Who should attend
Anyone interested in getting up and running with PostgreSQL administration and programming
Prerequisites
This class assumes you are familiar with basic Linux or Unix administration and simple SQL & programming concepts. It would be useful if you have some familiarity with simple PostgreSQL installation and administration.
Onsite Training Class Schedule
Registration
|
