DB2 SQL, Scripts and Optimization with Data Studio

Why take this course?

After completing this course, you will be able to
Use Data Studio to complete development tasks such as
  • develop simple and complex SQL queries
  • verify syntax correctness for different database environments
  • check that your queries correctly refer to database objects
  • use built in content assist and SQL Builder capabilities
  • plan, analyse and tune your queries for better performance
  • use Visual Explain to enhance your tuning activities
1 Day : Fee - $ 697.00 (CAD) :  ? Multi-seat - $ 497.00 (CAD)
Sorry, no classes are currently scheduled
Contact us to arrange your preferred location and date
Students who complete this course will learn how to use IBM's Data Studio to enhance their SQL development and to provide better performing queries in their applications.
Current and future DB2 application programmers who want to gain the productivity advantage provided by Data Studio for development. DB2 DBA and others who need to understand and enhance the performance characteristics of SQL.
The student should possess a basic knowledge of SQL including single and multi table joins.

Major topics covered

Data Studio Overview

  • General concepts and layout
  • Navigation
  • Perspectives and views
  • Workspaces and setting
  • The Web Console
  • The Task Launcher

Creating SQL and Scripts

  • Script development overview
  • Projects : Data Development vs Data Design
  • Database Connections and Schemas
  • The SQL or XQuery editor
  • Syntax Validation and Script Parsers
  • Semantic Validation
  • The content assist feature
  • Special Registers and the statement terminator
  • Script run options
  • Running and review results
  • Using SQL Builder
  • Query tuning and optimization

Query Tuning Overview

  • The Query Tuning Perspective
  • Tuning Workflow
  • Tuning : Capture
  • Tuning : Statistics Advisor
  • Tuning : Review and recommendations
  • Tuning : Analysis and reporting
  • Visual Explain overview
  • Visual Explain special registers and defaults
  • Visual Explain interpretation