loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for ORACLE PL/SQL

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Narayana

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

ORACLE PL/SQL

Online Instructor led Course

Platform: Goto Meeting, Teamviewer

15,000

No Feedback Yet

No Reviews Yet
0 Interested

About the Course


Purely Online

Topics Covered

Oracle Training Contents
Introduction
• Overview of Database
• Concept of DBMS
• Components of a DBMS
• Relationship among data
• Overview of RDBMS
• Overview of ORDBMS
• CODD’S Rule
• Normalization
• Denormalization
Overview Of Oracle Database Architecture
• Introduction Of Oracle
• Oracle Database Memory Structure
• Overview Of System Global Area
• Database buffer Cache
• Shared Pool
• Oracle Process
• Oracle Files
• Storage Architecture
• Segments
• Data Blocks
• Working Of Oracle Architecture Engine
Introduction to SQL
• Sub languages Of SQL
• SCHEMA Concepts
• Rules Of SQL commands
• Working with Alias
• Working with Virtual Column (VC)
• Dual Table

Conditional Selections and Operation
• Clause in Oracle
• Sorting Column through column number
• Sorting table using multiple columns
• Precedence Order of Operators
• Special Operators
• Case Statements
Single –Row function
• What is Sql function
• Types of Sql function
• Types of single-row function
• Character Function
• Analytical(OLAP) function
Multi-Row functon
• Types of group function
• Group By clause
• Restriction of groups using HAVING clause
• OLAP options in multi-row function
Joins
• Introduction
• Advantages Of joins
• Different types of joins
• Set Operators
Sub-queries
• Types of Sub-Queries
• Applying HAVING CLAUSE with sub-query
• Inline View
• Correlated Sub-query
• Exists and not exists operator

Working with substitution Variables and Producing readable output
• Substitution Variables
• Types of substation variables
• DEFINE and UNDEFINE Commands
Data Definition Language
• DDL statements
• Types of tables
• Table Structure
• Create table statements
• Alter table statement
• Drop statements
• Truncate a table
• Types of integrity constraints
• Viewing a constraint
• Removing a constraint
• Status of constraints
• Deferrable
Database Transaction
• INSERT Statement
• Insert with SELECT
• Insert all statement
• Update statement
• Merge statement
• Delete statement
• TCL Mechanism
Working with view and other database objects
• Why Views?
• Creating views
• Types of view
• Materialized view
• Performing DML operation on view
• Index
• Advantages Of Index
• Types of Index
• Using wild cards during searches
• Synonym
• Sequence
• Snapshot
Tablespace and Partitioning
• Tablespace
• Partitioning
• Types of table-partition
Hierarchical Queries
• Introduction
• Connect_by root clause

Controlling User Access
• Locking and Unlocking user
• Dropping User
• Confirming the user
• Privileges
Concept Of Locking
• Introduction
• Types of locking
• Levels of locking
Introduction to PL/SQL
• Introduction
• Characteristics of PL/SQL
• Architecture of PL/SQL
• Components of PL/SQL
• Types of variables
Interaction with Oracle Server
• SQL statements in PL/SQL
• Working with %type attributes
• Working with composite datatypes
Cursors
• Introduction
• Parts of cursor
• Types of cursor
• Cursor attributes
• Explicit cursor
• Cursor loops
• REF cursor
• Bulk Collect
• Limit in bulk collect
• Multiple fetches in into clause
Subprograms procedure and function
• Introduction
• Procedures
• Function
• Restrictions On Overloading
Packages in Oracle
• Introduction
• Package Specification
• Package body
• Purity Levels
• Pinning in the shared pool
• Method overloading inside in a package
• Built in packages in Oracle
• Advantages of Packages


Exception Handling
• Exception handler
• Methods to raise an exception
• Exception types
• Steps to create a non-pre-defined oracle server error
• Predefined exceptions with its error numbers and SQL code value
• Function for trapping Exception
• Raise-application error procedure
• Program of PL/SQL Exceptions
Triggers
• Components of triggers
• Types of trigger
• Types of trigger events
• Representation of triggers
• Creating a trigger
• Trigger predicates
• Restriction on triggers
Dynamic SQL and PL/SQL wrapper
• Binding
• Types of binding
• Dynamic SQL
• Bulk binds
• Advantages of wrapper
Collections
• Introduction
• Types of collection
• Multilevel collection
• Bulk binding and bulk operations
• Forall statements
• Save exceptions

Database links
• Database links
• Advantages of database links
• Names for database links
• Types of database links
TAC
• Trigger Firing Order
• Compound trigger








Who should attend

Everybody

Pre-requisites

Should know the platform of oracle

What you need to bring

Broadband internet connection

Key Takeaways

Concentration & dedication
Reviews
There are no Reviews yet.
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet.

Date and Time

Not decided yet.

About the Trainer

Narayana Sahu

B.Tech in CS


I have above 3 year of experience in oracle
Seats Left-

Students Interested 0

Course Id: 27233