Advanced SQL

Training Summary
This course covers ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 luw and z/os, and MySQL, with emphasis on SQL Server and Oracle. Labs can be done in any of those database environments.
Before taking this course, students should take SQL Basics and Intermediate or have equivalent work experience, and have several weeks of experience using SQL.
2 Days/Lecture & Lab
This course is designed for application developers.
Course Topics
  • Introduction
  • View issues
  • Index issues
  • Stored procedures
  • User-Defined Functions
  • Triggers

Related Scheduled Courses