ORACLE SQL/PLSQL

 

 

FACULTY : ANAND/MURALI

 

24HOURS LAB/UNLIMITED WI-FI

NO OF DAYS: 45

 

DEMO DATE:


 Oracle 10g/11g (SQL / PL SQL)]

 

Introduction to Oracle

What is Difference Between Oracle and Sql Server

What is Difference Between System Software and Application Software

Software Ware Hierarchy Diagram

What is DBMS and Types of DBMS

               HDBMS (Hierarchy)

               NDBMS (Network)

               RDBMS (Relational)

Versions of Oracle

What Is SQL and Advantage of SQL

What Is Table and Rules for naming the Table

What is Data type and types of Data types

Types of Sub Languages in SQL

               DDL (Data Def Language)

               DML (Data Manipulation  Language)

               TCL (Transaction Control Language)

               DCL (Data Control Language)

               DRL (Data Retrieval Language)

What is Recycle bin And Advantage of Recycle bin

What is Flashback And Advantage of Flashback

Operators In Oracle

               Arithmetic Operators

               Relational Operators

               Logical Operators

Difference between Delete and Truncate

Converting Table as Read-only Table

Converting Read-only table as Read-write table

Virtual Columns

Types of Clauses

               Order By

               Having

               Group By

What are Functions and Types of Functions

               Single Row Functions

               Multi Row Functions & Group Functions

What are Constraints and Types of Constraints

               Primary key

               Foreign key

               Unique key

               Not Null

               Check

What are Joins and Types of Joins

               Simple Join (Equi, Non-Equi)

               Outer Join (Left, Right and  Full)

               Self Join

               Cross Join

What are Sub Queries and Types of Sub Queries

Database Objects

               Views

               Synonyms

               Sequences

               Indexes

 

PL/SQL

 

Basics

               Introduction to PL/SQL

               Benefits of PL/SQL

               PL/SQL Environment

               PL/SQL Architecture

Data Types and Variables in PL/SQL

               Scalar Data Types(%Type)

               Composite Data Types(%Row  Type)

               Difference between PL/SQL variables and Non- PL/SQL Variables

Conditional Structure

               Conditional control   statements

Interactions in PL/SQL

               Simple Loop or Basic Loop

               While Loop

               For Loop

Cursors

 

Writing Implicit and Explicit Cursors

               Implicit Cursor Attributes

               Explicit Cursor Attributes

               Cursor in Loops

Advanced Explicit Cursors

Exceptions in PL/SQL Anonymous Block

               Predefined Exceptions

               Non-Predefined Exceptions

               User-Defined Exceptions

               Handled Exception in an Anonymous Block

               Unh andled Exception in an Anonymous Block

 

Subprograms

Stored Procedures

 

               What is stored procedure

               How to create stored procedure & Execute Procedure

               How to Call one Procedure to another Procedure

 

Functions

               What is function

               How to create function & Execute function

               How to call from one function to another function

               Difference between function and stored procedure

 

Packages

               Package Specification

               Package Body

               Exploring various Data Dictionary Views

 

Triggers

               Application Trigger

               Database Trigger

               Statement level Trigger

               Row Level Trigger