Oracle SQL Pl / SQL

ORACLE SQL PL /SQL  COURSE CONTENT

Oracle Architecture

Introduction to relational databases.

Relational database terminology.

Data normalization.

CODD’s rules.

Data integrity.

Querying the database.

Oracle Database Architecture.

SQL

Subqueries using where and from clauses

Different kinds of select statements.

Hierarchial queries

Corelated queries

Subqueries with examples

Operators

Joins

UNION [ALL]

MINUS

INTERSECT

Indexes

Types of indexes

Case Statements

Basic Usage with examples

types of languages:

DDL -creation tables and DML statements.

DML Statements

Insert

delete

update statements.

Merge statement.

syntaxes

examples

Various Date functions

views:

Creating Views

Join Views,

Altering Views and Dropping Views.

PL/SQL :-

Introduction

PL/SQL program units

Anonymous blocks

Functions

Procedures

Packages

Variables

Numeric variables

Character variables

Date variables

Datatypes for specific columns

Conditional Statements

Array handling

Associative arrays (Index-by tables)

Nested tables

Varrays (variable-size arrays)

Looping

LOOP statements

FOR loops

Cursor FOR loops

 Cursors

Triggers.

Exception handling.

Bulk collect.

Miscellaneous

Performance Tuning techniques.