Introduction to Oracle 5 Days course Language: English This course is only available on request!!

OUTLINES

PART I: INTRODUCTION TO SQL, & SQL*Plus

CHAPTER 1: INTRODUCTION OT DATABASES
1) Database Terminology
2) Database Models
3) Advantages of the Relational Database Model
4) What is a Relational Database?
5) The Oracle Database
6) Client/Server Configuration

CHAPTER 2: DATA MODELING
1) The Entity Relationship Model
2) Entities
3) Attributes
4) Types of Relationships
5) Handling many-to-many Relationships
6) Normalization
7) Normalization and Keys
8) Normalization Rules
9) Top-down Design Approach
10) Data Design

CHAPTER 3: INTRODUCTION TO SQL
1) SQL Commands
2) Data Definition Language commands (DDL)
3) Data Manipulation Language commands (DML)
4) Transaction Control Language Commands
5) Data Control Language Commands (DCL)
6) Logging onto the Database

CHAPTER 4: DDL COMMANDS
1) Creating a Table
2) Oracle's naming convention
3) Datatypes
4) Contraints
5) The Primary Key Constraint
6) The Foreign Key Constraint
7) The Not Null Constraint
8) The Unique Constraint
9) The Check Constraint
10) The Check Constraint
11) Editing the scripts
12) Describe Command
13) Altering a table
14) Adding/dropping a Constraint
15) Dropping a table
16) SQL Command Files
17) SQL Command Files
18) SQL*Plus File and Set Commands

CHAPTER 5: DML COMMANDS
1) Select
2) Insert
3) Embedding a Select into an Insert
4) Update
5) Delete

CHAPTER 6: BASIC QUERIES
1) The Select Command
2) Viewing data in a table
3) Displaying Unique Values Using the Distinct Command
4) Order By
5) Sorting Results
6) The Where Clause
7) Using Comparison Operators in the Where Clause
8) Using the (=,<>, !=, <, <=) Operators
9) USing the Like Operator
10) Wildcard Operators
11) Using the IN Operator
12) Using the Between...And...Operator
13) Using the IS NULL Operator
14) Using Logical Operators in the Where Clause
15) Expressions and the Select Command
16) Expressions in the Select Clause
17) Column Alias
18) Expressions in the Where Clause
19) Expressions in the Order By Clause

CHAPTER 7: FORMATTING THE OUTPUT
1) Formatting the Output

CHAPTER 8: SINGLE ROW FUNCTIONS
1) Single Row (Scalar) Functions
2) Numeric Functions
3) Character Functions
4) Date Functions
5) Valid Date Format Elements
6) Conversion Functions

CHAPTER 9: GROUP FUNCTIONS (MORE ABOUT SQL)
1) Group Functions
2) Distinct And All
3) Group By Clause
4) Having Clause

CHAPTER 10: JOINS
1) Joins
2) Types of Joins
3) Simple, Multiple, Outer, and Self Joins

CHAPTER 11: VIEWS
1) Creating a View
2) Removing a View

CHAPTER 12: SEQUENCES
1) Creating a Sequence
2) Generating Sequence Values

CHAPTER 13: TRANSACTION CONTROL COMMANDS
1) Commit
2) Rollback

CHAPTER 14: DATA CONTROL COMMANDS
1) Controlling User Access
2) Creating a Synonym

PART II: INTRODUCTION TO PL/SQL

CHAPTER 1: INTRODUCTION TO PL/SQL
1) Advantages of PL/SQL
2) The PL/SQL Block
3) Basic PL/SQL Block Structure
4) The Declaration Section
5) The Execution Section
6) The Exception Section
7) Generating Output

CHAPTER 2: VARIABLES AND CONSTANTS
1) Datatypes
2) Scalar Datatypes
3) Composite Datatypes
4) Variables
5) Variable Assignment
6) Scope of Variables
7) Constants

CHAPTER 3: CONDITIONS AND LOOPS
1) Conditional Control
2) Iterative Control
3) Guidelines
4) Simple, While, and For Loops
5) While Loop
6) For Loop

CHAPTER 4: CURSORS
1) Implicit and Explicit Cursors
2) Cursor Actions
3) Declaring a Cursor
4) Opening a Cursor
5) Fetching Data from ad Cursor
6) Closing a Cursor
7) Cursor Attributes
8) Cursors and Loops
9) Cursors for Loops

CHAPTER 5: EXCEPTION HANDLING
1) Guidelines
2) Types of Exceptions
3) Named System Exceptions
4) Named User-Defined Exceptions
5) Unnamed System Exceptions
6) Unnamed User-Defined Exceptions
7) SQL ERRM and SQL Code
8) Propagation

CHAPTER 6: PROGRAM UNITS
1) Modules
2) Types of Program Units
3) Named and Unnamed Block Structures
4) Anonymous Blocks
5) Procedures Parameters
6) Parameter Modes
7) IN
8) Out
9) IN Out
10) Referencing a Procedure
11) Parameters in Procedure Calls
12) Positional Notatoin
13) Named Notation
14) Functions
15) Function Parameters
16) Referencing a Function

CHAPTER 7: PACKAGES
1) Defining and Using Packages
2) Advantages of Using Packages
3) Overloading

CHAPTER 8: DATABASE TRIGGERS
1) Trigger Types
2) Trigger Events
3) Trigger Restrictions
4) Trigger Body
5) Compination of Database Triggers
6) Trigger Syntax

---

---

FDDI Institute
De Regenboog 11 - 2800 Mechelen - Belgium - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50