Advanced SQL

    

Summary:
This course is intended to give experienced application developers better query testing techniques, more depth with complex SQL syntax, a good grasp of performance considerations, and an overview of writing stored procedures, functions and triggers.

Duration:
2-3 Days/Lecture & Lab

Audience:
This course is designed for application developers, data analysts, and others who work in any relational database environment, including Oracle, SQL Server, Sybase, DB2 for z/OS or Universal Database, Access, Ingres, Informix, and many others.

Topics:

• Introduction
• Creating and Updating Tables
• Using Multiple Tables
• Data Types
• Text Handling Issues
• Case Logic
• SQL Summarization
• XML and related issues
• Stored Procedures
• User Defined Functions
• Triggers

Prerequisites:
Students should have taken the SQL for Application Developers (also known as SQL Basics, or SQL Level 1) or an equivalent course, or had at least six months of experience using SQL in any relational DBMS environment, including DB2, Oracle, SQL Server, Sybase, MySQL, Informix, Ingres, Access, etc. The course assumes a good knowledge of the Select, Insert, Update and Delete statements, basic joins and grouping, and of some editor such as SQL Server Management Studio, SQL*Plus, SQL Developer, Toad, etc.

Last Update: February 7, 2012