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.
- View issues
- Index issues
- Stored procedures
- User-Defined Functions