Database Training Program

1
Database Training Program

• This training was developed to help improve the
  database skills of programmers throughout AIS
• These classes use a combination of interactive
  labs, discussions, lecture, and reference books
• The workshops are offered throughout the year, as
  the need / demand arises

2
Introduction to Relational Database (2 hour
workshop)

• Workshop Objectives
• Appreciate the evolution from data files to
  databases
• Understand Relational Database theory and
  database design methodology
• Understand database terms/technology
• Use new technology to query and report from
  University data stored in a relational database

3
Database Design Workshop (1 day)

• Includes presentation and supporting document
• Workshop Objectives
• Customer Requirements
• Logical Database Design
• Table Normalization
• Data Integrity - Primary Keys and Referential
  Constraints
• Physical Database Design
• DB2 Suggestions

4
Differences Between DB2 and Oracle (2 hour
workshop)

• Discussion Topics
• Platforms
• Catalog / Data Dictionary
• Tools
• Datatypes
• Functions
• Combining Data from Multiple Tables
• Explain Plan Tables
• Other Differences

5
Advanced SQL Using DB2 V6 (1-2 day
workshop)

• DB2 Developers Guide (by Craig Mullins)
• Topics Include
• SQL Overview
• Union and Union All
• Inner and Outer Join Techniques
• CASE Statement
• DB2 SubSelects (Includes a supporting document
  for this topic)

6
Advanced SQL Using DB2 V6 (1-2 day
workshop)

• Continuation of Topics
• DB2 Functions
• DB2 Datatypes
• Review of Using the Explain Plan
• Programming Guidelines

7
SQL Performance and Tuning (1 day Workshop)

• Workshop Topics
• The DB2 Optimizer
• SQL Coding Strategies and Guidelines
• DB2 Catalog
• Filter Factors for Predicates
• Runstats and Reorg Utilities
• DB2 Explain
• DB2 Insight

8
Oracle SQL Programming (2-3 day
course)

• Oracle SQL Interactive Workbook (by Alex
  Morrison and Alice Rischert)
• Course outline included
• Topics Include
• Relational Concepts / Introduction to SQL
• Oracle Training Database
• Oracle Data Dictionary
• Use SQLPlus Worksheet (or WinSQL)
• Oracle Character, Number, and Date Functions
• Conversion Functions

9
Oracle SQL Programming (2-3 day
course)

• Continuation of Oracle SQL Topics
• Coding SQL Predicates (Between, Like, IN)
• Group BY with the Having Clause
• Decode
• Equi and Outer Table Joins (supporting document
  included for this topic)
• Set Operators (Union, Intersect, Minus)
• Subqueries and In-Line Views
• Data Types Sequence
• Create / Drop Oracle Tables
• Insert, Update and Delete Rows

10
Intro. To SQL Using Oracle (1-2 day course)

• Course developed using the demo business database
  that came with Oracle
• Topics Include
• Relational Concepts
• Introduction to SQL
• Oracle Training Database
• Select Data
• Use SQLPlus Worksheet
• Discover Your Oracle Environment
• AIS Oracle Standards

11
Intro. To SQL Using Oracle (1-2 day course)

• Continuation of Intro to Oracle SQL Topics
• Oracle Functions
• Number Functions
• Character Functions
• Group Functions
• Date Functions
• Conversion Functions
• Coding SQL Predicates
• Grouping Data

12
Advanced SQL Using Oracle (1-2 day course)

• Course developed using the demo business database
  that came with Oracle
• Topics Include
• Combining Data from Multiple Tables
• Decode
• Coding Subqueries
• Data Types Sequence
• Oracle Tables
• Create a Table from another Table
• Insert, Update and Delete Rows
• Drop a Table
• Oracle Performance Considerations