"ORACLE PL/SQL" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: Goto Meeting, Teamviewer

Course ID: 27233

Course type: Online Instructor led Course

Platform: Goto Meeting, Teamviewer

No Reviews Yet

Date and Time

Not decided yet.

Narayana Sahu

B.Tech in CS

About Narayana Sahu

I have above 3 year of experience in oracle
No reviews currently

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

No reviews currently

Explore the following courses which may meet your requirement (1)

Discussions

Post your requirement and let us connect you with best possible matches for Oracle Developer Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more