Section- 1

Oracle10G:Introduction

• Oracle10G features
• Client/Server architecture
• Oracle application development
• Oracle Products and Components

SQL*Plus

• Introduction
• Basic terms
• Entering SQL*Plus commands
• Setting up SQL*Plus environment
• SQL*Plus Commands

Net10

• Introduction
• Benefits of SQL*Net
• SQL*Net Architecture
• Distributed Processing

Section- 2

Database Objects

• Introduction
• Managing Tables, Views (*)
• Managing Sequences, Synonyms
• Managing Indexes
• Renaming Schema Objects
• Oracle Data types
• Data Conversion
• Data Partitioning (*)
• Index Partitioning (*)

Section- 3

Integrity Constraints

• Using NOT NULL Integrity Constraints
• Setting Default Column Values
• Choosing a Table's Primary Key
• Using Unique key Integrity and Referential Integrity Constraints
• Nulls and Foreign Keys
• Naming Integrity Constraints

Section- 4

PL/SQL

• Block Structure
• Variables and Constants
• Cursors
• Control Structures
• PL/SQL Tables

Stored Procedures, Functions and Packages

• Introduction
• Stored Procedures
• Functions
• Packages
• Debugging

Section- 5

Database Triggers

• Introduction
• Guidelines for creating triggers
• Creating database triggers
• Mutating and Constraining Tables

Database Transactions and Database Security
Database Transactions

• Introduction
• Commit
• Rolling Back
• Save points
• Read Only transactions

Section- 6

Database Security

• Application Level Security
• Object Level Security
• Roles

Oracle Utilities

• Export/Import
• SQL*Loader (*)

Memory Structures and Oracle Processes
Memory Structures

• SGA
• PGA

Oracle Processes

• User Processes
• Server Processes
• Background Processes

Functioning of Oracle

Project

Each Day includes Theory and Lab practice

• Examples based on theory
• Exercises

What you’ll learn

• Creating Table, Constraints, SQL, Database objects PL/SQL, Stored Procedure, Triggers, Security.