The delegate will learn and acquire skills as follows:
- Advanced datatypes and datatype conversion
- Using regular expression patterns and functions
- Using Analytical functions
- Using extensions to the Group By clause
- Using WITH clauses and Common Table Expressions (CTE)
- Working with transaction management
- Creating Stored Program Units with PL/pgSQL
- Using best practice options to optimise query execution
- Loading and Unloading data with the COPY option
Loading and Unloading data with the COPY option Course Objectives Course Objectives
To provide a broader set of PostgreSQL skills for someone who currently has a good working knowledge of PostgreSQL.