Training

Oracle SQL Advanced (2 days)

This course is for delegates who want to further their skills in developing SQL queries and SQL code and covers joins, data manipulation and tuning.

Course Content
- Understanding Query Logical Processing
- Joins, Table Expressions and Ranking functions
- Data Modification and Datatypes
- Aggregating and Pivoting Data
- Dynamic Execution
- Error Handling
- Tuning T-SQL
- Hierarchies and Recursive Queries

Benefits
This course will benefit T-SQL Programmers, Architects, Analysts and Data Base Administrators or those with a need to write or review T-SQL code in SQL Server 2000 and 2005.