Description

Oracle SQL PL SQL Training : Oracle SQL

Oracle SQL PL SQL Training : Database Concepts

File Management System

Data Base Management System

Relational Database Management System

Database Design

Normalization

First Normalization Form

Second Normalization Form

Third Normalization Form

Integrity

Data Integrity

Referential Integrity

Types of Constraints

Data Definition Language (DDL)

Creating Tables

Dropping Tables

Altering the Structure of Table

Truncate

Merging of Tables

Data Manipulation Language (DML)

Inserting Records

Deleting Records

Updating Records

Operators

Data Query Language (DQL)

Retrieving Data

Sub Queries

Nested Sub Queries

Correlated Sub Queries

Hierarchical Retrieval

Exists, Any, All

Group By

Having

Rollup

Cube

Data Control Language (DCL)

Grant

Revoke

Joins

Introduction To Joins

Inner Joins

Outer Joins

Self Join

Cross Joins

Multiple Joins

Oracle Proprietary Outer Join Operator

USING Keyword

Set Operators

Union

Union All

Intersect

Minus

System Functions

Aggregate Functions

Single Row Functions

Multiple Row Functions

Date Functions

Regular Expression Support

Managing Data in Different Time Zones

Handling Constraints

Primary Key Constraint

Unique Constraint

Check Constraint

Foreign Key Constraint

Views

Creation Of Views

Updatable , Un updatable Views

With Check Option

With Read Only Option

Creating Complex Views

Sequences

Creating, Altering, Dropping Sequences

Cycle, No Cycle

Cache, No Cache

Indexes

Introduction To Indexes

Duplicate/Unique Index

Creating Simple/Complex Index

Multiple Indexes On A Table

Clusters

Cluster Key

Cluster Indexes

Hierarchal Retrieval

Basic hierarchal retrieval

Using Level

Pruning branches/children

Oracle 11g Tool

Introduction

Creating Schema Objects

Managing Users

Generating Reports

Oracle SQL PL SQL Training

Oracle PL/SQL

Basics Of PL/SQL

Introduction

Declaration Section

Execution Section

Exception Handling Section

PL/SQL Placeholders

Control Structure

Conditional Statements (IF Statements, Case Statements)

Iterative Statements (Simple Loop, While Loop, For Loop)

Sequential Controls (GOTO Statement, Labels)

Oracle’s Exception Handlers

Error Handling In PL/SQL

Oracles-Named Exception Handler

Unnamed System Exceptions

User Defined Exception Handling (For Business Rule Validations)

Raise_Application_Error()

Dynamic PL/SQL

Introduction To PL/SQL Programming

Writing PL/SQL Programs

Functions, Stored Procedures, Packages

Create, Alter and Drop A Function.

Create, Alter and Drop A Stored Procedures

Create, Alter and Drop A Packages

Triggers

Introduction to Triggers

Creating, Altering, Dropping Triggers

After, Before, Instead of Triggers

OLD, NEW Key Words

Cursors

Creating Cursors

Implicit Cursor (Single and Multiple Row Implicit Cursors)

Explicit Cursors

Cursor Execution Cycle

Cursor FOR Loops

Dynamic Cursors FOR Loops

Parameterized Cursor

Using FOR UPDATE Clause in Cursor

Exception With Cursor

Cursor Within Cursor

Transaction Control Language (TCL)

Commit

Rollback

Save point

%Type

%Rowtype

Table Variables

Records

Decode

Duration & Timings :

Duration – 30 Hours.

Training Type: Online Live Interactive Session.

Faculty: Experienced.

Weekday Session – Mon – Thu 8:30 PM to 10:30 PM (EST) – 4 Weeks. December 9, 2024.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. January 4, 2025.

Oracle is registered trademarks of the Microsoft Corporation Inc.

ORACLE SQL PL/SQL REVIEWS

I am not from computer background, Mr. Rajendra gives step by step guidance through installation and good real time examples. Easy to understand. The practice exercises are very good for learning the real time scenarios. Best place to learn T-SQL for beginners from Rajendra Trainer. Thanks for you time

Swetha

Had some good learning experience through the sessions conducted by Srinu and he was thorough professional and handled all queries raised during class and afterwards with ease and provided good real time examples

Srikanth