DB2 SQL Refresher Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 417
Course Abstract:	This course is designed to provide experienced DB2 SQL programmers with a refresher course dealing with SQL best practices and DB2 v7.x SQL features and programming hints. This course will also present information on stored procedure design and statement design issues to provide programmers a knowledge base from which to make sound design decisions. ENVIRONMENT: This course will be taught using Mainframe SPUFI in a TSO/ISPF environment.
Audience:	This course is designed for experienced DB2 SQL programmers that already understand the basics and syntax of the SQL language as used in DB2.
Duration:	4 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Utilize DB2 Version 7.x SQL features and facilities and also understand the major SQL performance issues associated with designing, creating, and deploying SQL statements.
Course Topics:	How to effectively use SPUFI The what, why, and when of stored procedures Version 7.x SQL Features and SQL Coding Hints Effective DB2 V7.x data type usage Selecting the right SQL predicate for the task Subqueries, Unions, and Joins Scaler Functions (i.e. substring, length, lower) Aggregate Functions (i.e. avg, sum, count) Group by / having / grouping sets / rollup Designing complex SQL statements for performance Nested table expressions / Materialized views The pros/cons of Locking (RR, CS, RS) Fetch ‘First n Rows’ Additional topics Cursor Processing Scrollable Cursors Effective use of Views Commit and Rollback Other Related topics (not included) Referential Integrity Constraints on data Normalization and good database design DB2 SQL COBOL coding techniques
Prerequisites:	None.

DB2 SQL Refresher Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology