SQLBeginning to Advanced

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is a comprehensive introduction to SQL and Relational Database.. Topics include Structured Query Language, Relational Databases and Tables, Types of Relational Databases, Relational Architecture, Relational Components, and Relational Database Administration. The emphasis is on Structured Query Language (SQL).

PREREQUISITES: Some knowledge of data processing concepts and facilities.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstration, and Labs (when/where available).

AUDIENCE

This course is designed for Users, and Technicians that need to understand Structured Query Language.
KEY HIGHLIGHTS:
  • Explain what is meant by the term Relational Database
  • Explain how size, price, limitations, applications, and capacity impact decisions about relational databases
  • Discuss the components of Relational Databases
  • Understand various Relational objects, including:
    • Database
    • Tablespace & Types
    • Tables
    • Index & Indexspace
    • Storage Group
    • Views
  • Introduction to Structured Query Language
  • Components of SQL
  • Understand the following Structured Query Language Statements:
    • SELECT
    • UPDATE
    • INSERT
    • DELETE
    • FETCH
    • OPEN CURSOR
    • CLOSE CURSOR
    • DECLARE CURSOR
    • Others
  • Understand Relational Interactive Facilities
  • Understand Data Definition Statements:
    • CREATE
    • DROP


  • Understand Data Control Statements:
    • GRANT
    • REVOKE
  • Introduction to Relational Database Application Programming
  • Understanding Query Tools
  • Review of commercially available databases, including:
    • DB2 (all platforms)
    • Microsoft Access
    • SYBASE, Ingres, Oracle, Others
  • Introduction to Distributed Relational Database Architecture
  • Open discussions
  • Distributed Data Facility
  • Indexes
    • Advantages
    • Disadvantages
  • Intermediate SQL
  • Distinct
    o Order By
    o Join
    o Views
    o Security
    o Catalog
    o Table Design
    o Normalization

  • Advanced SQL
    • Outer joins
    • Nested table expressions
    • Subqueries (both types)
    • Case
    • Functions
    • Referential Integrity
    • Large objects
    • Stored procedures
  • Locks in relational databases
  • Introduction to DB2
    • Characteristics of DB2
    • Support for large systems
    • Database
    • Tablespace
    • Subsystem
    • Static and Dynamic SQL
    • User Defined types
    • User Defined functions
    • Triggers

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.