AquinasTraining.co.uk - training courses. Home  -  FAQ  -  Corporate Plans

DB2 SQL Workshop for Experienced Users

CF13      Course duration (days): 2
Talk to a Training Advisor
Tel. 0800 652 0202
Availability
Schedule available upon request within 24 hours.
Need help? Contact us now.

Also known as: CF13GB

About this class

This course builds on the DB2 SQL Workshop (CF12GB) and enhances your existing SQL knowledge. There is ample opportunity to try out 'advanced' statements in practical sessions.

Who will the lesson benefit?

Experienced SQL end users, application programmers, database administrators, and user support staff who need more in-depth knowledge of SQL.

What delegates will learn

What delegates will learn

:

  • Use 'advanced' SQL constructs, such as recursive SQL, CASE expressions, check constraints, and triggers
  • Discuss basic relational database concepts, such as referential integrity, tables, and indexes
  • Create DB2 objects such as tables, indexes and views
  • Use inner and outer joins
  • Use more complex subqueries
  • Use the major scalar functions, and the 'newer' GROUPing column functions
  • Understand the use and impact of summary tables and table expreressions

What prerequisites are required

You should complete the DB2 SQL Workshop (CF12GB) and/or have three to six months of SQL experience.

  • DB2 SQL Workshop (CF12GB)

Contents of this class

Topics

Include:

  • Introduction and Review
  • Using CUBE and ROLLUP
  • Creating DB2 Objects (tables, views, indexes.....)
  • Inner and Outer Join
  • CASE, casting and summary tables
  • Subqueries
  • More on Scalar Functions
  • Table Expressions and Recursive SQL
  • User-Defined Types and Functions 0 Some Performance Considerations when writing SQL