Browse Courses

	Request in your area.
	Add course to watch list.
	View full course outline.
	Need more information?

Course Schedule:
Toronto, ON	06/27-06/28
Virtual Classroom	06/27-06/28
Kansas City, MO	06/27-06/28
Pittsburgh, PA	06/27-06/28
Ottawa, ON	06/27-06/28
Sacramento, CA	06/27-06/28
Omaha, NE	06/27-06/28
San Francisco, CA	06/27-06/28
Calgary, AB	06/27-06/28
Vancouver, BC	06/27-06/28
Oklahoma City, OK	06/27-06/28
Tulsa, OK	06/27-06/28
Toronto, ON	08/22-08/23
Virtual Classroom	08/22-08/23
Kansas City, MO	08/22-08/23
Pittsburgh, PA	08/22-08/23
Ottawa, ON	08/22-08/23
Sacramento, CA	08/22-08/23
Omaha, NE	08/22-08/23
San Francisco, CA	08/22-08/23
Calgary, AB	08/22-08/23
Vancouver, BC	08/22-08/23
Oklahoma City, OK	08/22-08/23
Tulsa, OK	08/22-08/23
Toronto, ON	10/19-10/20
Virtual Classroom	10/19-10/20
Kansas City, MO	10/19-10/20
Pittsburgh, PA	10/19-10/20
Ottawa, ON	10/19-10/20
Sacramento, CA	10/19-10/20
Omaha, NE	10/19-10/20
San Francisco, CA	10/19-10/20
Calgary, AB	10/19-10/20
Vancouver, BC	10/19-10/20
Oklahoma City, OK	10/19-10/20
Tulsa, OK	10/19-10/20
[ Select a date to register ]

Intermediate SQL

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.

Duration:
2 Days/Lecture & Lab

Audience:
This course is designed for application developers.

Topics:

Introduction
Techniques for solving complex problems
Advanced use of multiple tables
Text handling issues
Advanced Case logic
Advanced Summarization
Overview of Stored Procedures

Prerequisites:
Before taking this course, students should take SQL Basics or have equivalent work experience, and had several weeks of experience using SQL.

Last Update: June 19, 2013

Course Locations

Popular Courses

Browse Courses

Intermediate SQL