Intermediate SQL

PT9011
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 an SQL Basics course, or have equivalent work experience, and had several weeks of experience using SQL.
Duration
2 Days/Lecture & Lab
Audience
This course is designed for application developers.
Topics
Introduction
  • Techniques for solving complex problems
  • Using multiple tables
  • Text handling issues
  • Case logic
  • SQL Summarization
  • Stored Procedures

Related Scheduled Courses