Name: DB2 Advanced SQL Topics
Course Code: CI625
Duration: 2
Scheduled Dates for CI625
In this course students will review the following SQL commands - Basic Select, Scalar Functions, Joins, SubQueries, Unions, and Insert/Update/Selects. Students will learn and practice features of the current version of DB2 and look into the next version of DB2.
Target Audience
This course is intended for experienced data processing personnel who have used SQL and need to refresh / deepen their current skills and learn and use "advanced" SQL topics.
Key Topics
- DB2 - Concepts, and Terminology
- The SELECT Statement
- Special Features
- ORDER BY, GROUP BY, HAVING
- Join, Sub-select, UNION
- Data Definition Language
- Data Manipulation Language
- Data Control Language
- SQL Programming V - Other Programming Considerations
- DB2 Performance Considerations
- DB2 Catalog and Runstats
- Concepts In DB2 Efficiency
- DB2 Explain and Visual Explain
- DB2 Additional features - User Defined Data Types, User Defined
- Functions, Triggers, Large Objects
- Other Advanced Topics - Recursive SQL, Group By - CUBE, ROLLUP
Objectives
- Use SPUFI to "run" SQL statements
- Build queries using the ORDER BY, GROUP BY, HAVING clauses
- JOIN tables together to get information from each
- "Change" tables using the INSERT, UPDATE, DELETE statements
- Describe the security provided by the GRANT and REVOKE
- Discuss the design considerations of REFERENTIAL INTEGRITY
- Discuss overall DB2 PERFORMANCE considerations
- Run the EXPLAIN PLAN SQL statement and analyze results
- Discuss additional SQL features of the latest DB2 Feature
- Review the DB2 Catalog and Runstats Utility
- Discuss Concepts in DB2 Efficiency
- Discuss the DB2 Explain and Visual Explain
Required Skills/Experience
- At least six months experience using DB2 SQL
Fee: $800.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
