Advanced SQL

PT9010
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.
Prerequisites
Before taking this course, students should take SQL Basics and Intermediate or have equivalent work experience, and have several weeks of experience using SQL.
Duration
2 Days/Lecture & Lab
Audience
This course is designed for application developers.
Topics
  • Introduction
  • View issues
  • Index issues
  • Stored procedures
  • User-Defined Functions
  • Triggers

Related Scheduled Courses