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 an SQL Basics course, or have equivalent work experience, and had several weeks of experience using SQL.
This course is designed for application developers.
- Techniques for solving complex problems
- Using multiple tables
- Text handling issues
- Case logic
- SQL Summarization
- Stored Procedures