Advanced SQL for DB2 Course

Course Description

This course covers more advanced aspects of the Structured Query Language (SQL), with specific reference to the IBM DB2 database. Contents include advanced table joins, advanced operators, expressions, operators, views, user defined functions, stored procedures (DB2 SQL PL) and database performance considerations.

Prerequisites

A basic understanding of relational databases and previous experience writing SQL statements is essential.

Intended Audience

Anyone who needs to use advanced SQL to update or query databases, either on its own or within another development environment.

Contents

Database Overview

Review of database components. •  Review of basic SQL statements.

Data Types

Date and time types. •  Type conversions for dates, times and numbers. •  Producing specifically formatted text. •  Effect of type conversions on performance.

Expressions

Understanding various operators. •  Building functions. •  Server-side (custom) functions. •  Using literals, constants and pseudo-constants. •  Using regular expressions in the LIKE clause. •  Effect on performance.

Joining Tables

The INNER join. •  The OUTER join. •  FULL, LEFT and RIGHT in joins. •  Result and cost of the type of join.

Advanced Data Query Commands

The UNION operator. •  The INTERSECT operator. •  The EXCEPT operator. •  Limiting the number of rows and columns returned by a query. •  Creating sub-queries.

Views

Creating and using views. •  Effect of views on performance.

Data Management Commands

The TRANSACTION command. •  The COMMIT command. •  The ROLLBACK command. •  The SAVEPOINT command.

Database Performance

Configuration aspects that influence the behaviour and performance of a database, from a programmer's perspective. •  Creating indices. •  Effect of indices on perfomance. •  Understanding and interpreting the results of the EXPLAIN clause. •  Effect of server-side objects, triggers and stored procedures on performance.

Download the Advanced SQL for DB2 course contents in PDF format for easy printing.

Need a course date? Please contact us at tel: (+27) 12 666 2020 or email us at info@incusdata.com for the next available course date.

Ready to book? Just fill out our course enrolment form and fax it to us at (+27) 12 666 2021 or email it to us at info@incusdata.com.

Home   |    Top of this page   |    Contact Us    Schedule   |    Course List   |    FAQ   |    Sitemap

Essential Skills for IT