Oracle PL SQL Training

Course Details

PL/SQL is specifically designed for the seamless processing of SQL commands. It designs specific syntax for this purpose and supports exactly the same data types as SQL and also includes procedural language elements, conditions and loops. It is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the security, robustness, and portability of Oracle Database. PL/SQL works analogously to the embedded procedural languages associated with other relational databases.

Oracle PL SQL Training Overview

In this ORACLE PL SQL training, students enrich the capabilities of ensuring desired success for the 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 Group Functions

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 Anonymous 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 Exceptions
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

Faqs

1. Who are the trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

2. What if I miss a class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

3. How will I execute the practical?

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

4. If I cancel my enrollment, will I get the refund?

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

5. Will I be working on a project?

The Training itself is Real-time Project Oriented.

6. Are these classes conducted via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

7. Is there any Offer / Discount I can avail?

There are some Group discounts available if the participants are more than 2.

8. Who are our Customers?

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad, San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

9. Mindmajix Oracle PL SQL Training Classes At Other Stateside Locations of USA