-
₹4950
-
Duration: 50 Hours
-
Delivery mode: Online
-
Group size: 11 - 20
-
Instruction language:
English,
Hindi
-
Certificate provided:
Yes
Single Row Functions:
Retrieving Data Using the SQL SELECT Statement
SQL Operators
Numeric Functions, String Functions, Date Functions, Conversion Functions and other Functions.
Multi Row Functions:
Group Functions, Using Group By Clause, Using Having Clause, Set Operators.
Joins:
Simple Joins, Outer Joins, Self Joins, Natural Joins, Using Clause, On Clause
Left Outer Joins, Right Outer Joins, Full Outer Joins
Sub-Queries:
Retrieve data using Sub –Queries, Nested Sub Queries and Co-Related Sub Queries
Data Definition Language(DDL):
Data types, Data Definition Language
Create, Alter-Add, Modify, Rename, Drop, Rename, Truncate, Drop, Flashback.
view and how to create view
Data Manipulations Language(DML)/Transaction Control Language(TCL):
Inserts: Basic Insert, Using Functions, Using Sub Query, Multi-Table Inserts.
Update: Basic Update, Using Functions, Using Sub- Queries.
Using Merge Statements
Enhancements in Merge Statements.
Commit, Rollback and Savepoint
Introduction to PL/SQL
Declaring PL/SQL Variables
Writing Executable Statements
Interacting with Oracle Database Server: SQL
Statements in PL/SQL Programs
Writing Control Structures
Loops
Types of Cursors
Cursor Attributes, Cursor with Parameters, Cursor with For Loops, Cursor with Update Clause,
Ref Cursors
Exception Handling
Types of Exception Handlers
System Define Exception Handlers
User Defined Exception Handlers
RAISE_APPLIACTION_ERROR Procedure, Advantages
Parameters Types
How to Create, Compile and Execute
Invoke Procedure from PLSQL
Drop, Catalog for Procedures
Advantages Return Type in Functions
How to Create and Compile a Function
How to Invoke a Function
Online Catalog for Functions
Drop
Difference Between Procedures and Functions
Purpose and Advantage
Package Specification
Package Body
How to Create and Compile a Package
How to Invoke a Package
How to Drop
Online Catalog for Pacakges.
Creating Triggers
DDL, and Event Database triggers