KAIZEN TECHNOLOGIES INC

Course: Database Project Package

Course Id: Ora10Gdev
Prerequisite: Introduction to computers



Oracle10G:Introduction

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

ANSI SQL

  • Basic SQL and Advanced SQL

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

Database Objects

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

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



Advanced SQL and PL/SQL

Advanced SQL
  • How SQL works?
  • Embedded SQL
  • Operators
  • SQL Functions
  • For Update Queries
PL/SQL
  • Block Structure
  • Variables and Constants
  • Cursors
  • Control Structures
  • PL/SQL Tables

Stored Procedures, Functions and Packages

  • Introduction
  • Stored Procedures
  • Functions
  • Packages
  • Debugging

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
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
Oracle as Data Warehouse Platform

Project