Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.

Which course is right for me?

Speak to an IT online learning consultant today

on 844-OPTGHAR for FREE Tailored Advice.

Oracle PL SQL Online Training and Placement

Oracle PL SQL Training for OPT CPT Students

Online Training Courses

Oracle PL SQL Online Training

Oracle PL SQL Course Content:

SQL

1.The Oracle database environment2.Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g

Basic SELECT Statement1.Writing the statement in sqlplus, Running the SELECT statement

Ordering the output 1.Single Column, Descending order, Multiple column sort

Conditional retrieval of data1.Working with complex conditions, AND OR NOT LIKE BETWEEN

Pseudo columns and functions1.Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table

Working with character functions• 1.UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(),

Working with date functions1.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function1.ROUND(), TRUNC(), SIGN(), Working with multiple tables,2.Different type of Joins, Writing Outer Joins

Using the SET operators1.Union, Intersect, Minus

Aggregating data using group functions1.GROUP BY, HAVING

Creating Subqueries1.Single Row subqueries, Multiple row Subqueries

Enhancing groups function1.ROLLUP, CUBE

Transaction Control Language1.Rollback, Commit, Savepoint

Processing hierarchies1.Creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language1.INSERT, UPDATE, DELETE

Data Definition Language1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints1.Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References

Constraint, On Delete Cascade, On Delete Set Null

Other Database Objects1.Views, Sequences, Synonyms, Indexes2.USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS

Database Security1.Object Privileges, Granting access to objects

PL -SQL

Blocks1.Structure, Writing Anoyomous Blocks

Variables1.Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments

Control structures1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors1.Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

Error Handling1.Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions

Procedures1.Creating and Calling Procedures

Functions1.Creating and Calling Functions

Packages1.Package Header, Package Body

Design Tips and Techniques1.Format of standard packages in an application, Spec and Body, NOCOPY hint theory

Triggers1.Database triggers, CALLing procedures from triggers

Dynamic SQL1.EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages1.DBMS_OUTPUT, UTL_FILE

Collection datatypes1.Associative Arrays, Nested tables, VARRAYs

1.The Oracle database environment
2.Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g

Basic SELECT Statement
1.Writing the statement in sqlplus, Running the SELECT statement

Ordering the output
1.Single Column, Descending order, Multiple column sort

Conditional retrieval of data
1.Working with complex conditions, AND OR NOT LIKE BETWEEN

Pseudo columns and functions
1.Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table

Working with character functions
• 1.UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(),

Working with date functions
1.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function
1.ROUND(), TRUNC(), SIGN(), Working with multiple tables,
2.Different type of Joins, Writing Outer Joins

Using the SET operators
1.Union, Intersect, Minus

Aggregating data using group functions
1.GROUP BY, HAVING

Creating Subqueries
1.Single Row subqueries, Multiple row Subqueries

Enhancing groups function
1.ROLLUP, CUBE

Transaction Control Language
1.Rollback, Commit, Savepoint

Processing hierarchies
1.Creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language
1.INSERT, UPDATE, DELETE

Data Definition Language
1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints
1.Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References

Other Database Objects
1.Views, Sequences, Synonyms, Indexes
2.USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS

Database Security
1.Object Privileges, Granting access to objects

Blocks
1.Structure, Writing Anoyomous Blocks

Variables
1.Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments

Control structures
1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors
1.Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

Error Handling
1.Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions

Procedures
1.Creating and Calling Procedures

Functions
1.Creating and Calling Functions

Packages
1.Package Header, Package Body

Design Tips and Techniques
1.Format of standard packages in an application, Spec and Body, NOCOPY hint theory

Triggers
1.Database triggers, CALLing procedures from triggers

Dynamic SQL
1.EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages
1.DBMS_OUTPUT, UTL_FILE

Collection datatypes
1.Associative Arrays, Nested tables, VARRAYs