April 2014
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
282930  

Oracle PL SQL Online Training

Oracle PL and PL SQL Online Training Course Content

Introduction & Basics

1) Introduction

1)      History of relational database management systems.

2)      Oracle vs other RDBMS

3)      Editions and Versions of Oracle

4)      Different development environments.

2) Oracle Setup

1)      Oracle Binaries installation

2)      Creating Sample database.

3)      Connection setup through sqlplus and Sql developer.

3) Oracle Architecture

1)      ACID rules

2)      Concept of Normalization.

3)      Different normal forms.

4)      Oracle Architecture in detail

5)      Logical & Physical structure of oracle database.

SQL

1) Introduction to SQL

1)      DDL commands

2)      DML commands

3)      DCL commands

4)      TCL Commands

5)      Data types in oracle

6)      Detail understanding on Select statement

2) Restricting and Sorting Data

1)      Where clause

2)      Between, In and Like operators

3)      And, OR and Not operators

4)      Order by clause

5)      Defining and Assigning values to variables

3) Single Row functions

1)      Character Manipulation functions

2)      Case conversion functions

3)      Number functions

4)      Date functions

5)      Round and Trunc with date functions

4) Conversion Functions

1)      Data type conversion

2)      To_char,to_date and to_number functions

3)      Replacing null values (NVL2), Decode function

4)      Conditional expressions ( Case)

5) Group functions

1)      Group by clause

2)      Sum, Avg, Min and Max functions

3)      Group by clause on multiple columns

4)      Restricting group results ( Having)

6) Oracle Joins

1)      Type of joins

2)      Join using On and Using clauses

3)      Natural, self and equi joins

4)      Outer joins (left, right and full)

5)      Cross join ( Cartesian product)

7) Sub queries

1)      Types of sub-queries

2)      Single and multiple row sub-queries

3)      Group functions on sub-queries

4)      Using All and Any operators

8) Set operators

1)      Union and union-all operators

2)      Intersect and minus operators

3)      Order by clause in set operators

9) More on DML statements and Data integrity

1)      Inserting data from other table

2)      Conditional insert ( Merge )

3)      Select for update statement

4)      Delete vs truncate

5)      Data integrity ( Commit & Rollback)

10) More on DDL and Constraints

1)      Creating tables and inserting default values

2)      Primary and foreign key constraints

3)      Unique and check constraints

4)      Adding and dropping columns from a table

11) Creating other Schema objects

1)      Simple and Complex views

2)      B-tree and Bitmap indexes

3)      Working with sequences

4)      Creating synonyms

12) Controlling User Access

1)      Creating users

2)      Granting system & object privileges

3)      Creating Roles

4)      Granting and revoking privileges to and from a role

13) Managing other Schema Objects

1) Setting and Dropping UNUSED columns

2) Deleting data from Child Tables (on Delete)

3) Disable & Enable constraints

4) Drop Table…Purge

5) Flashback Table

6) Temporary Table

7) External Table

14) Miscellaneous

1)      Multi Table Insert

2)      Merge statement in detail

3)      Flashback Versions Query

4)      Interval data types

5)      Exists & not exists operators

6)      With Clause

7)      Rollup and Cube operators

 

PLSQL

Introduction to PLSQL

1)      Need and Benefits of PLSQL

2)      Anonymous PLSQL Block

3)      Declaring & Initializing variables

4)      %Type attribute

5)      INTO clause

Control Structures & loops

1)      If and Case statements

2)      For and While loops

Cursors

1)      Implicit and Explicit cursors

2)      Usage of Cursors in Loops

3)      Cursors with parameters

Procedures

1)      Anonymous PLSQL vs Procedure

2)      Writing simple procedures

3)      Exception Handling

4)      Pre-defined exceptions

5)      User defined Exceptions

Functions

1)      Procedure vs Function

2)      Creating simple functions

3)      Usage of functions

Packages

1)      Benefits of creating packages

2)      Package spec and Body

3)      Overloading of subprograms

Working with Oracle supplied Packages

1)      DBMS_OUTPUT

2)      DBMS_MAIL

3)      DBMS_FILE

Triggers

1)      Types of triggers

2)      Creating and Managing triggers

3)      Compound, DDL and Event based triggers

Miscelleneous

1)      Bulk Collect

Partitioning

1)      Different types of partitions

2)      Partition examples

Pay with Credit Card, Debit Card or Paypal Account via PayPal (faster & safer).  
Your Email :
Your Name :
Fee Details:
Please communicate with satish@tektrainings.com for any issues.