Intermediate SQL

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.

2 Days/Lecture & Lab

This course is designed for application developers.

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

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


Copyright © 2017 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media