PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
This two-day course provides students with the knowledge and concepts on
how to administer, maintain and troubleshoot PostgreSQL. Topics covered
include installation, configuration, basic tuning, monitoring and
backup/recovery. Some basic database design work is also included.
This three-day course contains some of the most basic DBA topics from
the other courses, but the focus is on developing database
applications. Topic includes writing and optimizing SQL queries,
advanced reporting queries, recursive queries, writing and using stored
procedures in SQL and pl/pgsql.