| DB2 SQL Fundamentals |
| |
| This class provides the basic knowledge and skills needed to code SQL statements. In addition to SQL topics, the course includes relational database management system (RDBMS) concepts such as referential integrity, primary keys, foreign keys, locking, and programming considerations. The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Informix, etc. Workshops are executed using an appropriate interactive tool such as SPUFI, QMF, SQL/PLUS or company standard RDBMS software. |
|
| Covered Topics: |
- Describe the relational model and how it relates to SQL
- Describe the Universal Database (UDB) platforms and IBM's relational database manager
- Understand an Entity Relationship Diagram
- Explain the three categories of SQL; namely DDL, DCL and DML
- Use proper syntax and coding standards when coding SQL statements.
- Code SQL statements to retrieve relational database data using the SELECT verb.
- Use SQL parameters to qualify data retrieval, such as WHERE, DISTINCT, IN, LIKE, BETWEEN,
- ORDER BY, UNION, built-in functions, scalar functions, GROUP BY and HAVING.
- Use SQL parameters to join tables and retrieve data.
- Use subqueries to select information from tables and retrieve data.
- Code SQL statements to change data, including the UPDATE, INSERT and DELETE instructions.
- Code efficient SQL statements by applying numerous performance considerations.
|
| Prerequisites: |
| Introduction to Relational Database, and working knowledge of the editor (ISPF, Windows Notepad, or VI Edit) is required to perform the SQL lab exercises. |
| Audience: |
| This course is designed for people who will be retrieving data from a relational database such as DB2 or Oracle using SQL. |
|
| |
| Course Benefits: |
| Students will be able to mine their databases without relaying on pre-canned scripts. This gives them more flexibility in crafting their own queries to provide the information to make decisions. |
| Materials Furnished: |
- Student Manual
- This course includes a combination of lecture, discussion and numerous computer workshops. Students will receive an extensive course manual covering SQL, which will be a valuable reference after class. There is an optional text book available for future reference.
|
| Recommended Follow-On Course: |
| |
|
|
|
|
|
