home Contact Information
Courses
C Language
OPP Using C++
Java
Oracle
Developer 2000
Visual basic
Active Server pages
E-Commerce Contact Us


    Introduction to Oracle

    Course Summary: The 56 hour course will consist of 36 hours of instructor-led training along with 20 hours of tutoring. The curriculum will include quizzes, hands-on exercises, and a case study.

    Course Objective: The student will understand the fundamental concepts of Oracle by learning syntax and usage of the language. Also, the student will apply the learned concepts in developing applications using Oracle.

    Pre-requisite: Able to function in Windows and DOS operating environments along with general programming knowledge.

Introduction to DBMS and Database Design:

Overview of DBMS

  • Database, DBMS & RDBMS
  • Essentials of Data Modeling
    (ER Modeling)
  • Normalization
  • Client/Server Oracle Architecture 

Introduction to SQL

Working with tables

  • Data types & pseudo-columns
  • Schema, users and synonyms
  • Creating tables with CREATE
    TABLE
  • Adding, deleting and modifying data with INSERT, UPDATE, DELETE
  • Altering and dropping tables

Efficient data access methods

  • Unique and non-unique indexes
  • Concatenated indexes

Using the SELECT command

  • Selecting & ordering rows &
    columns
  • Handling null values
  • Using functions and expressions
  • Joining tables

Additional SQL query techniques

  • Oracle's SQL statement processing
  • Sub-queries, correlated queries
  • UNION, INTERSECT and MINUS
  • Grouping data and applying aggregate functions

Using SQL*PLUS

  • Using SET and SHOW commands to control the environment
  • Writing simple reports
  • Accepting user input

Controlling Data Integrity & Security

Constraints

  • The importance of referential integrity
  • Maintaining referential integrity constraints at CREATE time
Transaction processing and locking
  • The purpose of transactions
  • Controlling transactions through the use of COMMIT, ROLLBACK and SAVEPOINT
  • Data and dictionary locks

Maintaining security through the use of views and roles

  • Creating views and synonyms
  • Specifying object privileges using GRANT and REVOKE
  • Manipulating privileges via roles

Introduction to PL/SQL-Procedural Language extension to SQL

Basic concepts

  • Program Structure
  • Declaring constants and variables
  • Assigning values
  • Logical condition statements and iterations

Producing well-structured modular code

  • Use of variables in SQL statements
  • Using cursors
  • Exceptions and exception handling

Advanced PL/SQL Features

  • Using PL/SQL Tables and Records
  • Stored procedures and functions
  • Constructing database
  • Packages
  • Creating and manipulating triggers

Overview of Oracle tools and utilities

  • Importing and exporting data
  • SQL*Loader

Case Study

Top
Top
Top
Contact

For a consultation to discuss your training needs, please
contact us at
770-458-2727 xtn 1701 or click here to send us email.
Top

| Home | About Us | Services | Partners | Customers | WOL Advantage | Training | Careers |