Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
DB2 SQL Performance & Tuning w QMF
Overview

This course offers students a lecture/lab intensive environment on DB2's Data Server Technology. The class covers the concepts of both performance tuning of SQL, Objects and Advanced SQL in a DB2 database and the use of SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SPUFI and QMF. Advanced technique such as ROLLUP, CUBE, set operators and creation of user-defined datatypes discussed.

LEARNING OBJECTIVES

The student upon completion of this course will be able to:

  1. Create, Retrieve and Manipulate database objects with performance objectives
  2. Evaluate DB2 SQL for better performance and execution
  3. Understand relational versus object database concepts
  4. Identify performance objectives in using joins, subqueries or set operators
  5. Utilize EXPLAIN utilities to examine SQL performance
  6. Use DB2 non-ansi SQL and evaluate performance issues
  7. Utilize QMF to produce reports and jobs in different environments
  8. Understand QMF 7.0 for windows interface to DB2 table concepts
  9. Create Objects in the DB2 Object/Relational Database
Audience

Application Developers
Database Administrators
Systems Analysts
Technical Support Professionals


Prerequisites

Working knowledge of computers

Hardware/Software Requirements

Hardware

Minimal processor speed of 266 mhz or higher
Memory requirements - 128 mb
Video: 16 color (800 x 600 resolution minimum)
50 mb of storage space per student

Course outline

I. INTRODUCTION TO DB2
 
Objectives
A. DB2 RDBMS Architecture.................................................
B. DB2 Components ...........................................................
C. DB2 Environment .............................................................
D. User Roles................................................................................

II BASIC SQL LANGUAGE
 
Objectives
A. Understanding the SQL Format .............................................
B. Querying Row and Columns ..................................................
C. Using the Where clause .........................................................
D. Accessing tables with compound statements ........................
D. Utilizing Built-In Functions .....................................................
E. Searching for Null values .......................................................

III. DB2 FUNCTIONS AND NON ANSI SQL
 
Objectives
A. Converting data to different data types.....................................
B. Using DB2 datatypes ........................……...............................
C. Date conversions and functions ..............................................
D. Executing Scalar Functions......................................................

IV. ADVANCED SQL LANGUAGE
 
Objectives
A. Accessing tables through Joins ................................................
B. Understanding the use of Outer Joins ......................................
C. Comprehending Subqueries .....................................................
D. Selecting rows with the Union, Intersect and Except clauses ....
E. Modifying data through Inserts,Updates and Deletes ...............

V. QMF (Query Management Facility)
 
Objectives
A. Introduction to QMF
B. Typical QMF Session
C. QMF Screens
D. Concepts of Reporting Formatting
E. Report Format


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy