PostgreSQL is a fully featured open source relational database. It supports many of the features of large scale commercial database management systems such as Oracle and SQLServer, including an embedded programming language PG/plSQL for coding triggers and stored procedures, database replication and Object-Relational capabilities.
In the last couple of years FTT has run PostgreSQL programming and database administration courses for private and public organisations who, in these times of economic constraint, have chosen to migrate their database oriented applications from Oracle to PostgreSQL. The reason cited being the high cost of migrating from older versions of Oracle such as Oracle 9 to newer versions such as Oracle 11g, for example, or the costs of licensing involved in adding new Oracle server systems.
For many software projects for public organisations, in various European Union countries, directives have been issued to the effect that new projects should embrace open source technologies unless there are good reasons for doing otherwise. There are, in all fairness, situations for which Oracle or SQL Server databases may be the better option, and these will be discusses elsewhere.

Click on the links below for HTML versions of the full course outllines

Crs	Title	Days	Outline
DB580	Introduction to SQL and Relational Databases via PostgreSQL	5	HTML
DB582	PostgreSQL - An Intensive Introduction	5	HTML
DB586	PostgreSQL Database Administration	3	HTML
DB590	An Introduction to Building Web Sites using Apache, PostgreSQL and PHP	5	HTML

PostgreSQL — Standard Courses

FTT offers training for both developers and administrators for the popular Open Source PostgreSQL database. These courses take you from a broad introduction to relational databases through to full-blown database-driven e-commerce web sites based entirely on open-source technologies, including Apache and PHP.

Custom Courses

FTT can also provide training in more specialised topics, such as:

• Embedding SQL into C and C++
• GUI application development for PostgreSQL using Tcl/Tk or Qt on Linux platforms
• Using PostgreSQL for C++ and Java object persistance