Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

ORACLE PL/SQL

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

Students Interested 0 (Seats Left 0)

₹ 15,000

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

Discussions

Students Interested 0 (Seats Left 0)

₹ 15,000

Post your requirement and let us connect you with best possible matches for Oracle Developer Post your requirement now
₹ 15,000 Enquire