Total Time: 4 hour(s)

Summary: 
This course explains how to use SQL, which is the language of relational databases, and what to consider when designing applications or databases. In the course, the learner will study the various SQL statements used to access data.

Ojectives: 
After completing this course, students will be able to:
Use various SQL statements
Include SQL statements in application programs
Use constraints and triggers to implement restrictions
Create user-defined-types to extend data types supported by the database
Manage system resources to ensure optimal performance
Manage the interaction of concurrent users

Topics: 
Data manipulation language
Column functions, scalar functions, and grouping
Set operators, predicates, and data manipulation
Using views
Invoking SQL statements
Constraints and user-defined types
Triggers
Routines and large object support
The development center
DB2 Net Search and spatial extenders
Managing System Resources
Concurrent users, indexes, and query applications

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.