• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Course Details

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and are stored inside the database. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.

Oracle PL SQL Training Curriculum

SQL

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

Basic SELECT Statement

Writing the statement in sqlplus, Running the SELECT statement

Ordering the Output

Single Column, Descending order, Multiple column sort

Conditional Retrieval of Data

Working with complex conditions, AND OR NOT LIKE BETWEEN

Pseudo Columns and Functions

Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table

Working With Character Functions

UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST()

Working With Date Functions

TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function

ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins
Writing Outer Joins

Using the SET Operators

Union, Intersect, Minus

Aggregating Data Using Group Functions

GROUP BY, HAVING

Creating Subqueries

Single Row subqueries, Multiple row Subqueries

Enhancing Groups Function

ROLLUP, CUBE

Transaction Control Language

Rollback, Commit, Savepoint

Processing Hierarchies

Creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language

INSERT, UPDATE, DELETE

Data Definition Language

CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE.

Using Declarative Constraints

Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null.

Other Database Objects

Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS

Database Security

Object Privileges, Granting access to objects

PL -SQL

Blocks

Structure, Writing Anoyomous Blocks

Variables

Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments

Control Structures

IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END, LOOP statement, WHILE condition, FOR condition

Cursors

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

Error Handling

Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions

Procedures

Creating and Calling Procedures

Functions

Creating and Calling Functions

Packages

Package Header, Package Body

Design Tips and Techniques

Format of standard packages in an application, Spec and Body, NOCOPY hint theory

Triggers

Database triggers, CALLing procedures from triggers

Dynamic SQL

EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied Packages

DBMS_OUTPUT, UTL_FILE

Collection Datatypes

Associative Arrays, Nested tables, VARRAYs

Course Reviews

4.6

685 ratings
    • The online course session was good with a lot of discussion on the subject in depth. Demo's were good and the trainer cleared my doubts clearly.The trainer having a very good command on the subject.
      Profile photo of Suneel Kumar
      Raghu
    • Real time/live scenario's were included in the training sessions. The trainer's has very good command on the subject. Thank you..
      Profile photo of Suneel Kumar
      Claire Edwards
    • I like the training period from Tekslate. The course is very well designed that helps to keep track until we demonstrate subject mastery.
      Profile photo of Suneel Kumar
      Anya Vasilisa
    • Using most innovative teaching techniques, Tekslate intended to help students to learn through online. A great part of the coursework is allowed to use and earn certification by the time they finish t ...
      Profile photo of Suneel Kumar
      Alvin Alicia
drop query

Send us a Query

Enroll into this course

Register for Free Webinar

I agree to be contacted via e-mail.

Related Articles

No Related Articles found

Site Disclaimer, Copyright © 2016 - All Rights Reserved.