MP9003: Network and Database (General) - SQL and Design Considerations > DB2 Universal Database

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. 

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

Objectives:
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

Duration:
4 Hours