A PostgreSQL powered database environment will help you increasing the profitability of your business and will help you to achieve your business goals.

"Teach on the Beach"
Location: Dominican Republic

During this 5 day training course you will learn about all important aspects of PostgreSQL development and you will learn to design and create databases from scratch.

This course will be held in a relaxed and open environment. Learning in small groups will make sure that you can benefit from this training in an efficient way.

Content of the training course:
Installing PostgreSQL on Linux and Windows
Installing binaries
Installation from source
Getting to know psql and pgAdmin3
Basic command line interaction
Using GUIs
Other GUIs available
Getting started with SQL
Creating tables
Designing database applications properly
PostgreSQL data types
Using schemas
Inserting, modifying and retrieving data
Using subselects
Joins
Inner joins
Outer joins
Using views
Making use of indexes
GROUP BY and HAVING

Advanced features
Understanding foreign keys
Understanding inheritance
Data type abstraction
Working with date and time
Data partitioning
Using XML
Full text indexing

Writing stored procedures
Using PL/pgSQL
Declaring variables
Loops
Dynamic SQL
Debugging PL/pgSQL
Writing trigger procedures
Using other languages (an overview)

Working with transactions
Running simple transactions
Understanding concurrency
Transaction Isolation
Locking
Using savepoints
2 Phase Commit

No previous experience with PostgreSQL is required. It is recommended to be familiar with the UNIX command line interface.
The course will be held by Hans-Juergen Schoenig, a leading expert who has written 4 books on PostgreSQL. He has been in professional PostgreSQL business since 1999.

Register for this training now: email

Price: USD 2.100
Early Bird: USD 1.900

<< back