|
Provided by: Serebra Learning Corporation IBM DB2 UDB Essentials Part 3 - SQL FundamentalsUnfiled |
 |
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the learner should be able to write basic Data Manipulation Language (DML) SQL statements and basic Data Definition Language (DDL) SQL statements.
|
|
||||||||||
Audience
Learners needing to write support or understand SQL queries. This includes but is not limited to end-users programmers application designers database administrators and system administrators who do not yet have the knowledge included in this course. Basic computer literacy and basic editing skills are pre-requisites of this course. Database skills are not required.
Objective
Upon completion of this course the student will be able to:
- identify characteristics of relational databases.
- identify features of the DB2 UDB catalog.
- identify key elements that comprise an SQL table definition.
- identify syntax used in an SQL query to retrieve data by joining two tables.
- identify syntax used in an SQL query to retrieve data by joining multiple tables.
- identify syntax used in an SQL query to retrieve data by joining a table to itself.
- identify the column functions used in an SQL query to summarize data.
- identify features of the GROUP BY clause.
- identify features of the HAVING clause.
- identify syntax used in an SQL query to write a subquery.
- identify uses of the IN and NOT IN predicates in an SQL subquery.
- identify SQL syntax used to delete rows from a DB2 UDB table.
Topics Include
Unit 1: SQL Introduction and Simple Queries
- Identify characteristics of relational databases.
- Identify features of the DB2 UDB catalog.
- Identify key elements that comprise an SQL table definition.
- Identify properties of views.
- Identify syntax used to write a simple SQL query.
- Identify syntax used in an SQL query to produce an ordered result set.
- Identify syntax used in an SQL query to remove duplicates from a result set.
- Identify methods used to filter rows from a result set.
- Identify ways to filter rows from a result set using multiple conditions.
- Identify predicates used to create a partial string search in an SQL query.
Unit 2: Multiple Tables and Scalar Functions
- Identify syntax used in an SQL query to retrieve data by joining two tables.
- Identify syntax used in an SQL query to retrieve data by joining multiple tables.
- Identify syntax used in an SQL query to retrieve data by joining a table to itself.
- Identify the arithmetic operators used in an SQL query to perform calculations.
- Identify features of the COALESCE scalar function.
- Identify features of the DECIMAL scalar function.
- Identify ways in which dates times and durations are manipulated in an SQL query.
- Match date and time scalar functions with their uses.
- Identify features of the SUBSTR scalar function.
- Identify ways to concatenate fields in SQL.
Unit 3: Column Functions and UNION
- Identify the column functions used in an SQL query to summarize data.
- Identify features of the GROUP BY clause.
- Identify features of the HAVING clause.
- Identify extended forms of the GROUP BY clause.
- Identify rules governing the use of the UNION clause.
- Identify uses of the UNION ALL clause.
Unit 4: Subqueries and Data Maintenance
- Identify syntax used in an SQL query to write a subquery.
- Identify uses of the IN and NOT IN predicates in an SQL subquery.
- Identify SQL syntax used to delete rows from a DB2 UDB table.
- Identify SQL syntax used to update data in a DB2 UDB table.
- Identify SQL syntax used to insert one or more rows into a DB2 UDB table.
Duration
8 Hours
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
