1

Introduction to SQL

1

Retrieving Data

1

Updating Data

1

Inserting Data

1

Deleting Data

1

Advanced Filtering

1

Summarizing Data

1

Grouping Data

1

Using Subqueries

1

Joining Tables

1

Managing Tables

1

Using Views

1

Stored Procedures

1

Using Cursors

1

Using Transactions

1

PL-SQL (Procedure Language – SQL)

2

Introduction to Programming Languages

3

Introduction to PL/SQL

4

The Advantages of PL/SQL

5

PL/SQL Architecture

6

PL/SQL Data types

1

Variable and Constants

2

Using Built_in Functions

3

Conditional and Unconditional Statements

4

Simple if, if… else, nested if..else, if..else Ladder

5

Selection Case, Simple Case, GOTO Label and EXIT

6

Iterations in PL/SQL

7

Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS

8

SQL within PL/SQL

9

Composite Data types (Complete)

10

Cursor Management in PL/SQL

11

Implicit Cursors

12

Explicit Cursors

13

Cursor Attributes

14

Cursor with Parameters

15

Cursors with LOOPs Nested Cursors

16

Cursors with Sub Queries

17

Ref. Cursors

18

Record and PL/SQL Table Types

19

Advanced PL/SQL

20

Procedures in PL/SQL

21

STORED PROCEDURES

22

PROCEDURE with Parameters (IN,OUT and IN OUT)

23

POSITIONAL Notation and NAMED Notation

24

Procedure with Cursors

25

Dropping a Procedure

26

Functions in PL/SQL

1

Difference between Procedures and Functions

2

User Defined Functions

3

Nested Functions

4

Using stored function in SQL statements

5

Packages in PL/SQL

6

Creating PACKAGE Specification and PACKAGE Body

7

Private and Public Objects in PACKAGE

8

EXCEPTIONS in PL/SQL

9

Types of exceptions

10

User Defined Exceptions

11

Pre Defined Exceptions

12

RAISE_APPLICATION_ERROR

13

PRAGMA_AUTONOMOUS_TRANSACTION

14

SQL Error Code Values

15

Database Triggers in PL/SQL

16

Types of Triggers

17

Row Level Triggers

18

Statement Level Triggers

19

DDL Triggers

20

Trigger Auditing

21

File Input/Output

22

PL/SQL file I/O (Input/Output)

23

Using UTL_FILE Package

24

Implementing Object Technology

25

What is Object Technology ?

26

OOPS-Object Instances

1

Creation of objects

2

Creating User Defined Data Types

3

Creating Object Tables

4

Inserting rows in a table using Objects

5

Retrieving data from Object based Tables

6

Calling a Method

7

Indexing Abstract Data type Attributes

8

Using LOBS

9

Large Objects (LOBS)

10

Creating Tables-LOB

11

Working with LOB values

12

Inserting, Updating

13

Populating Lobis DBMS_LOB Routines

14

Using B-FILE

15

Using Collections

16

Advantages of collection

17

Ref cursor (Dynamic Cursor)

18

Weak ref cursor

19

Strong ref cursor

20

Nested Tables VARRAYS or VARYING arrays

21

Creating tables using nested tables Table records

22

Inserting, updating

23

A nested table in PL/SQL

24

Oracle Database Architecture

25

Introduction to Oracle Database Architecture

1

Physical structures Logical structures

2

DB Memory Structures Background Process

3

2 Tire, 3 Tire, N-Tier Architecture

4

Advanced Features

5

9i Joines

6

New Date function

7

Rename column

8

Inner Join/Natural Join

9

Left Outer Join/Right Outer Join

10

Full Outer Join

11

Multiple Inserts

12

Insert All Command

13

Merge statement

14

NVL2(), NULLIF(), COALESCE()

15

CASE expression of Select Command

16

Temporary Tables/Global Tables

17

New Function EXTRACT()

18

Autonomous Traction

19

Pragma _ Autonomous_ Transaction()

20

Bulk Collect

21

About Flash Back Queries

22

Dynamic SQL

23

New data types, Flashback Command

24

Purge Command, Recyclebin

25

Regular expressions, DML Error Logging

26

Data Pump, Virtual Columns

1

Read only tables, Cross tab Views using

2

Pivot/Unpivot operators, Follows Clause

3

Compound triggers, New data types

4

DBA CONCEPTS

5

Database

6

Tablespace

7

Types of tablespaces

8

Data files