Loading Course Schedule...
PT3297
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.
Prerequisites
Students should have taken SQL for Application Developers, have recent training in SQL, or at least six months of hand-on experience with SQL in any database environment.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for application developers 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::Statistics and access paths::Locking and performance issues::Advanced Joins:: Advanced Subqueries::Set operators::Case logic::Advanced use of SQL Functions::Advanced Summarization::Stored Procedures::User Defined Functions::Triggers