Friday, 2 December 2016

Oracle PL SQL Online Training

ORACLE PL/SQL ONLINE TRAINING @ VIVANTA IT LABS

An online course designed to make you an expert in using Oracle PL/SQL and learn all that is required to date functions, Creating Subqueries and Transaction Control Language.
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. That provides specific syntax for this purpose and supports exactly the same data types as SQL. PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. PL/SQL includes procedural language elements such as conditions and loops. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. It automatically inherits the security, robustness,  and portability of Oracle Database. Oracle PL SQL Online Training gives high productivity to programmers as it can transform, query,  and update data in a database.

Oracle PL SQL Online Training Overview

Vivanta IT LABS is the Global innovative corporate in Oracle PL SQL Online Training, students enrich the capabilities of ensuring desired success for organization. The sessions cover architecture concepts, Working with date functions, Creating Subqueries and Transaction Control Language. The classes range from basic to advanced techniques over the spectrum of skills that we teach with exercises and home work.

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

FEEL FREE TO CONTACT US

Your feedback is valuable to us. Please send us your suggestions.

USA OFFICE

INDIA OFFICE

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)