Oracle Welcome to the our Oracle course detail page


 

 

ORACLE CONTENT

 

Data Base Managament  System( DBMS )

·Overview

·Modeling Language

·DBMS Features and Cpabilities

·Models of Data Bases

·History of Data Bases

 

 

Working with Data Bases

·Introduction 

·Data Definaton Languages( DDL )

·Working with Tables

·Data Types

·Data Manipulation language ( DML )

·Constraints

·Cascading Rules

·Truncate and Drop Commands

 

Data Retrival Language

·Querying Data

·Built-In Functions

·Classification of Functions

·Mathematical Functions

·String Functions

·Date and Time Functions

·Conversion Functions

·Group Functions

·Operators

·Set Operators

· Clauses

· Sub Queries

· Joins

 

Transaction Control Languages

·Introduction

·Commit

·RollBack

·Save Transaction

 

 

Rules of Normalization

·1st,2nd,3rd  Normal Forms

·Boyce- Codd Normal Form

·PL/SQL Programming

 

 

Working with Cursors

·Introduction

·Cursor Process

·Declaring a Cursor

·Opening a Cursor

·Closing and Deallocating a Cursor

 

Working with Function

·Introduction

·Function Process

·Declaring a Function

·Opening a Function

·Closing and Deallocating a Function

 

Working with Triggers

·Introduction

·DML Triggers

·After Triggers

·Instead of  Triggers

·Nested Triggers

·DDL Triggers

 

 

 

Scroll to Top