The eLearning Center for Gatlin Education Services

Oracle Fundamentals (Second Edition)

Course Type: Self-paced Courses
Estimated Time of Completion: 10 hour(s) 24 minutes
CEU Credits:
Language: English

Description: In this course, you will list the users of Oracle, trace the history of databases, list the phases in the development life cycle for Oracle systems, list and define the levels of normalization, distinguish between data modeling techniques, create entities, add attributes and relationships, use SQL *Plus, query with the SELECT statement, work with set operators, subqueries, joins, and grouping functions, work with tables, grant and manage privileges to users, commit and rollback changes to data, and control a transaction with savepoints. You will also examine variables and constants, anonymous blocks, conditional logic flow, and cursors, list the purpose and syntax of packages, procedures, triggers, and functions, list the contents of a datablock, manage datablocks, explain the architecture of Oracle8i and the overall operation of the Object-Relational Database Management System (ORDBMS). After completing this course, you will be able to describe basic Oracle concepts and how they relate to DBAs and developers, list and describe the levels of normalization, identify and apply the techniques of logical database design to design a basic entity-relationship diagram (ERD), describe the use of SQL, write SQL statements to manage data, create and execute a simple PL/SQL program, describe the use and syntax of packages, procedures, functions, and triggers, list and describe the objects in an Oracle database, and explain the architecture of Oracle8i and the overall operation of the ORDBMS.
Objectives:

  · After completing this course, you will be able to list the users of Oracle, trace the history of databases, list the phases in the development life cycle for Oracle systems, list and define the levels of normalization, distinguish between data modeling techniques, create entities, add attributes and relationships, use SQL *Plus, query with the SELECT statement, work with set operators, subqueries, joins, and grouping functions, work with tables, grant and manage privileges, commit and rollback changes to data, control a transaction with savepoints. You will also be able to identify variables and constants, describe anonymous blocks, conditional logic flow, and cursors, list the purpose and syntax of packages, procedures, triggers, and functions, list the contents of a datablock, manage datablocks, describe the architecture of Oracle8i, and the overall operation of a Object-Relational Database Management System (ORDBMS).

Hardware and Software Required:

  ·  Browser Netscape Communicator 4.0
  ·  Browser Other: AOL 4.0
  ·  Operating System MacOS 8.5
  ·  Browser Microsoft Internet Explorer 4.0
  ·  Operating System MS-Windows 95

Content Outline:

Introduction to Database Concepts
Users of Oracle
The Relational Database Model
The Development Life Cycle

Data Normalization
Overview of Normalization
The Normal Forms

Logical Design
Data Modeling
Entities and Attributes
Entities and Their Relationships

Introduction to Structured Query Language
Introduction to SQL*Plus
The SELECT Statement
Data Definition Language (DDL)
Data Control Language (DCL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)

Procedural Language / Structured Query Language
Overview of PL/SQL
Stored Packages, Procedures, and Functions
Triggers

Database Objects
Datablocks
Database Storage
Oracle and Object-oriented Methodology

Oracle Architecture
The Oracle Database
The Oracle Instance
Accessing the Database
Other Oracle Products and Tools