>

ORACLE, An Introduction

LENGTH OF COURSE:
 5 Days

DESCRIPTION: The course will cover the major ORACLE definitions, commands, functions, features, and products. Students will learn the essentials of the product and build a foundation to become proficient in ORACLE.

PREREQUISITES: Prior data processing experience is helpful.
INSTRUCTION TECHNIQUES: A combination of Lecture and Labs (when/where available).

AUDIENCE

This course is designed for end users or developers wishing to become well versed in ORACLE.
KEY HIGHLIGHTS:
  • Introduction to Oracle environment
  • Oracle Concepts
    • Relational Database Overview
    • Structured Query Language
    • SQLPLUS Reports and Commands
  • SQL String Functions
  • Classes of Number Functions
    • Single, Group, and List Values
    • Storing and Calculating Date
    • Date Arithmetic
    • The Year 2000
  • Transforming Data Types
    • Elementary ORACLE Functions: TO_CHAR, TO_DAT, TO_NUMBER
    • Automatic Conversion of Data Types
    • Specialized Conversion Functions
    • Transformation Functions: TRANSLATE and DECODE
  • Grouping
    • Group by and Having
    • Views of Groups
  • Advanced Queries
    • Advanced Subqueries
    • Outer Joins
    • UNION, INTERSECT, and MINUS


  • Reports in SQLPLUS
  • Changing Data
    • Insert, Update, & Delete
  • Solving Difficult Problems
    • Functions in order by
    • Bar Charts and Graphs
    • Using TRANSLATE
    • Complex Cut and Paste
    • Variables and Spooled Substitution
  • Manipulating Data with DECODE
    • if, then, else
    • Tables: Turning rows into columns
    • Effects of MOD in DECODE
    • Greater than, less than, equal to
  • Creating, Dropping, Altering Tables & Views
  • Controlling Data Access
    • ORACLE users, Privileges & Quotas
  • Structure of ORACLE Databases
    • Indexes, Tablespaces, Clusters, Sequences


  • Techniques for Use of SQLPLUS
  • Remote Data Accesses
    • Database Links
    • Synonyms or Location Transparency
    • User Pseudo-Column
    • Dynamic Links
    • Connecting to a Remote Database
    • Oracle*Names
  • Triggers
    • Required Privileges
    • Types of Triggers
    • Syntax
    • Enabling/Disabling and Replacing/Dropping Triggers
  • Stored Procedures
    • Packages, Procedures & Functions
  • Snapshots
    • Commands and Privileges
  • ORACLE Data Dictionary
  • Performance and Design


FROM OUR STUDENT EVALUATIONS...
"Instructor was helpful and enthusiastic!"

Many Ruehl
State of Maryland

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