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)
Multi-seat - $ 497.00 (CAD)Sorry, no classes are currently scheduled
Audience
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.Prerequisites
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