COURSE SEARCH
 
   HOME > COURSES > ORACLE V8: INTRODUCTION TO DATABASES AND PROGRAMMING MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Oracle v8: Introduction to Databases and Programming




Course Aims
Oracle is the world's leading relational database. This course aims to teach the fundamentals of Oracle (version 8). This course includes several practical exercises complete with solutions in order to practice what you are learning.
Assumed Knowledge
Previous knowledge of databases and programming would be an advantage but is not essential.
Course Audience
This course is for programmers, database administrators and systems analysts who are new to Oracle.

This course can be found in the following categories:
Courses > Databases > Oracle

Table of Contents
Introduction to RDBMS
  		• DBMS Concepts
  		• RDBMS Terminology
  		• Data Base Models
  		• Data Integrity
  		• Codd’s Rules
     
    Introduction to SQL*Plus and DDL Commands
  		• Introduction
  		• SQL and SQL*Plus
  		• The CREATE Command
  		• The DESC Command
  		• Data Types In Oracle
  		• Integrity Constraints
  		• The ALTER Command
  		• The DROP TABLE Command
  		• The GRANT PRIVILEGE Command
  		• The REVOKE PRIVILEGE Command
     
    Data Manipulation Commands
  		• The INSERT COMMAND
  		• Copying Rows between Tables
  		• The SELECT Command
  		• The UPDATE Command
  		• The DELETE Command
     
    LAB: Creating Tables and Inserting Records
  		• Create the AUTHOR Table
  		• Create the BOOK Table
  		• Create the STUDIES Table
  		• Insert records in the AUTHOR Table
  		• Insert records in the BOOK Table
  		• Insert records in the STUDIES Table
  		• Solutions
     
    Joins and Subqueries
  		• Joins
  		• Equi-Joins and Non-Equi-Joins
  		• Outer Joins
  		• Subqueries
  		• Subqueries returning set of values
  		• Multiple Subqueries
  		• Correlated Subqueries
     
    Arithmetic and Group Functions in SQL*Plus
  		• Arithmetic Expressions
  		• Arithmetic Functions
  		• Group Functions
  		• Group Functions Vs Individual Functions
  		• Date Arithmetic
  		• The NVL Function
     
    Oracle Lab: Queries
  		• Section I - Problems
  		• Section I - Solutions
  		• Section II - Problems
  		• Section II - Solutions
  		• Section III - Problems
  		• Section III - Solutions
  		• Section IV - Problems
  		• Section IV - Solutions
     
    More Database Objects
  		• Views
  		• The Create View Command
  		• View of more than one table
  		• Views based on Arithmetic Expressions
  		• Synonyms
  		• Sequences
  		• Indexes
     
    LAB Exercises on Views, Synonyms and Indexes
  		• Section I - Views
  		• Solutions - Section I - Views
  		• Section II - Synonyms
  		• Solutions - Section II - Synonyms
  		• Section III - Indexes
  		• Solutions - Section III - Indexes
    Transaction Control Commands and SQL*Plus Formatting Commands
  		• Transaction
  		• The COMMIT Command
  		• The ROLLBACK Command
  		• The SAVEPOINT Command
  		• SQL*Plus Formatting Commands
     
    Introduction to PL/SQL
  		• Relation between SQL and PL/SQL
  		• Advantages of PL/SQL
  		• A Simple PL/SQL Block
  		• Declaration using attributes
  		• Loop Statements
  		• Displaying the user messages on screen
     
    Cursors and Error Handling
  		• Cursors
  		• Using the Explicit Cursors
  		• Explicit Cursor Attributes
  		• Implicit Cursor Attributes
  		• Example of an Explicit Cursor and Attribute
  		• Error handling in PL/SQL
     
    Stored Procedures, Functions and Database Triggers
  		• Stored Procedures
  		• How Oracle creates a Procedure?
  		• Advantages of Procedures
  		• Deleting the Procedure
  		• Stored Functions
  		• How Oracle creates a Function?
  		• Advantages of Functions
  		• Creating a Function
  		• Deleting a Function
  		• Database Triggers
  		• Use of Database Triggers
  		• Applying a Database Trigger
  		• Types of Triggers
  		• Before Vs After Triggers
  		• Creating a Trigger
  		• Deleting a Trigger
  		• The Raise_Application_Error Procedure
     
    Lab Exercises on Stored Procedures, Functions and Triggers
  		• Section I - Stored Procedures
  		• Solutions - Section I - Stored Procedures
  		• Section II - Stored Functions
  		• Solutions - Section II - Stored Functions
  		• Section III - Database Triggers
  		• Solutions - Section III - Database Triggers
     
    Game of Cricket - Lab Exercises
  		• Section I - Tables
  		• Section I - Solutions - Tables
  		• Section II - Queries
  		• Section II - Solutions - Queries
  		• Section III - PL/SQL Validations
  		• Section III - Solutions - PL/SQL Validations
     
    New Features in Oracle 8.0
  		• Creating Abstract Data Types
  		• Using Object Types in Relational Table
  		• Object Table
  		• Creating a Partitioned Table
  		• Introduction to Varray
  		• Nested Tables
  		• Introduction to Object Views
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 13th March 2010  © COPYRIGHT 2010 - VISUALSOFT