Designed for developers looking to migrate to PostgreSQL, this training course does not cover SQL, the SQL language, DML, or DDL - these are pre-requisites.
Location
299/92 Suttisarn Winijchai Rd., Samsen Nok,
Huay Kwang, Bangkok, Thailand
[map|13.791343, 100.587473|contact]
Course Information
Date: May 26-27, 2012
Class Hours: 09:00 am - 05:00 pm (UTC+7)
This is a class taught in Thai (English courses are available upon requests).
Course Outline
Day 1
- Installing & managing PostgreSQL
- Overview of PostgreSQL database
- Using the psql client
- Understanding PostgreSQL data types
- Numeric data types
- Integer data types
- Floating point types
- Serial types
- Character types
- Binary data types
- Date & time values
- Boolean values
- Array types
- Other data types
- Numeric data types
- Understanding sequences
- Creating & managing indexes
- Understanding PostgreSQL indexes
- Partial indexes
- Indexes on expressions
Day 2
- Using COPY to load data
- Working with Array Values
- Advanced SQL Functions
- Using Common Table Expressions (CTE)
- Using Window Functions
- Using Regular Expressions
- Using Recursive Queries
- Writing triggers & stored procedures with PL/pgSQL
- Variables in procedures
- Performing loop operations
- The PERFORM and EXECUTE statements
- Triggers in PostgreSQL
- Using the PostgreSQL query optimizer
- Analyzing & optimizing queries
- Viewing execution plans with EXPLAIN
- Understanding PostgreSQL query operators
- Improving query performance
Price
THB 9,000 (Early bird registration is THB 8,000 before May 12, 2012 )
