January 2012
M T W T F S S
« Dec   Mar »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

ONLINE ORACLE SQL&PLSQL TRAINING|ORACLE SQL&PLSQL TRAINING FROM HYD

Hello,

We are the experts in providing  ORACLE SQL&PLSQL online trainings by using real time scenories.

Here is my content :

SQL AND PLSQL

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

 

 Set operators

 

1)     Unionand 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

 

 

 

 

If anyone interested please mail me on  Info@tektrainings.com or call me on  +91 998 941 6000

Did you like this? Share it:

Leave a Reply

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.