PostgreSQL Training UK: PostgreSQL Courses at GBdirect

This section of our training site provides details of the PostgreSQL training courses that we deliver in the UK.

Courses offered in this topic are as indicated ( Open Public Course  Closed In-House Course)

• PostgreSQL Administration using Navicat — A 2-Day Course
• Foundations of SQL for PostgreSQL — A 3-Day Course
• Introduction to SQL PostgreSQL — A 2-Day Course
• PostgreSQL Administration — A 5-Day Course
• SQL Querying for PostgreSQL — A 2-Day Course

PostgreSQL is an enterprise capable, open source object-relational database system.

Over 15 years in development it has a well proven architecture which is reliable, and preserves data correctness and data integrity. PostgreSQL runs on Unix, Linux, Windows and MacOSX operating systems.

At the standards level PostgreSQL is completely ACID compliant. It :

• supports foreign keys, joins, views, triggers, and stored procedures
• includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP
• supports storage of binary large objects, including pictures, sounds, or video
• has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC
• comes with very good documentation

From the perspective of enterprise application development, PostgreSQL provides the expected functionality - namely a powerful query optimiser and planner, write ahead logging, online backups (hot backups), point in time recovery, savepoints for nested transaction, tablespaced and Multi-Version Concurrency Control (MVCC).

Unsurprisingly, PostgreSQL also supports Unicode, locale-aware sorting.

PostgreSQL scales very well and can handle very large volumes of data and also support large numbers or users. Currently there are PostgreSQL systems in use that contain around 5 terabytes of data.

Most importantly PostgreSQL is open source under the very liberal BSD license.

Our PostgresSQL courses correspond to the standard kinds of courses for other database management systems such as Oracle, SQLServer and MySQL. They are, however oriented to PostgreSQL. These course have been taught to organisations planning to migrate their applications from Oracle to an open source database environment, or to implement PostgreSQL applications that will interwork with some of their other database applications.

Publicly scheduled dates, locations, and prices