Mindmajix

Oracle PL SQL Training

120
Oracle PL SQL Training
4.5 98

Oracle PL/SQL Training is required to date functions, Create Subqueries and Transaction Control Language. PL/SQL is a procedural language designed explicitly to adapt SQL statements within its syntax.


Date :
09 Dec 2016
Course Duration (Hrs):
30
Date :
10 Dec 2016
Course Duration (Hrs):
30
Date :
11 Dec 2016
Course Duration (Hrs):
30
Date :
16 Dec 2016
Course Duration (Hrs) :
30
Date :
17 Dec 2016
Course Duration (Hrs):
30
Date :
18 Dec 2016
Course Duration (Hrs):
30
Contact Us Now!    

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

curriculum_moduleSQL

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

 curriculum_moduleBasic SELECT Statement

Writing the statement in sqlplus
Running the SELECT statement

curriculum_moduleOrdering the Output

Single Column
Descending order
Multiple column sort

 curriculum_moduleConditional Retrieval of Data

Working with complex conditions
AND OR NOT LIKE BETWEEN

curriculum_modulePseudo Columns and Functions

Pseudo Columns
Rownum
Sysdate
User & UID
The Dual Table

 curriculum_moduleWorking With Character Functions

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

curriculum_moduleWorking With Date Functions

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

curriculum_moduleUsing non-character function

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

 curriculum_moduleUsing the SET Operators

Union
Intersect
Minus

curriculum_moduleAggregating Data Using Group Functions

GROUP BY
HAVING

curriculum_moduleCreating Subqueries

Single Row Subqueries
Multiple row Subqueries

 curriculum_moduleEnhancing Group Functions

ROLLUP
CUBE

 curriculum_moduleTransaction Control Language

Rollback
Commit
Savepoint

curriculum_moduleProcessing Hierarchies

Creating the Tree structure
LEVEL
CONNECT BY

curriculum_moduleData Manipulation Language

INSERT
UPDATE
DELETE

curriculum_moduleData Definition Language

CREATE
TRUNCATE
ALTER
DROP
RENAME
DESCRIBE

curriculum_moduleUsing Declarative Constraints

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

curriculum_moduleOther Database Objects

Views
Sequences
Synonyms
Indexes
USER_TABLES
USER_TAB_COLUMNS
USER_OBJECTS

curriculum_moduleDatabase Security

Object Privileges
Granting access to objects

curriculum_modulePL -SQL

 curriculum_moduleBlocks

Structure
Writing Anonymous Blocks

curriculum_moduleVariables

Oracle Datatypes
TYPE and ROWTYPE declarations
Value assignments

curriculum_moduleControl Structures

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

curriculum_moduleCursors

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

curriculum_moduleError Handling

Predefined Exceptions
Non-Predefined Exceptions
User Defined Exceptions

curriculum_moduleProcedures

Creating and Calling Procedures

curriculum_moduleFunctions

Creating and Calling Functions

 curriculum_modulePackages

Package Header
Package Body

curriculum_moduleDesign Tips and Techniques

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

curriculum_moduleTriggers

Database triggers
CALLing procedures from triggers

curriculum_moduleDynamic SQL

EXECUTE IMMEDIATE
DBMS_SQL package

curriculum_moduleOracle Supplied Packages

DBMS_OUTPUT
UTL_FILE

curriculum_moduleCollection Datatypes

Associative Arrays
Nested tables
VARRAYs

 

Oracle PL SQL Course FAQs

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

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

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.

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.

The Training itself is Real-time Project Oriented.

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

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

As we are one of  the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE and other parts of the world. We are located in USA.

Mindmajix Technologies Inc

14 Pasco Drive
East Windsor, Connecticut, 06088
United States (US)
Phone: 201 378 0518

 

Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the Oracle PL SQL training by highly experienced and real time professionals with full stack technical background in the Oracle PL SQL field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Drop Us A Query


Course Reviews

4.5

98 ratings
  • 569
  • 415
  • 310
  • 24
  • 11
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.