Please feel the below form, we will call you very shortly
Oracle Courses
Oracle courses are designed to teach individuals how to manage and use Oracle's database management system. These courses cover a range of topics such as database administration, data warehousing, business intelligence, and application development.
Courses Enquiry
Please feel the below form, we will call you very shortly
Declare and initialize data types and Boolean variables Summary
Decision Making
IF Statement
IF-ELSIF Statements
Summary
Loops
Implement suitable control structures in PL/SQL
Implement a suitable loop construct in PL/SQL for a given scenario
Characteristics of FOR and nested loops in PL/SQL
Implementation of WHILE LOOP
Implementation of DO WHILE LOOP
EXIT Keyword
GOTO Statement
Summary
Sub Blocks
What is Sub Block?
Sub Blocks implementation
Modular Programming
Create and populate a user-defined record in PL/SQL
Create a record using the %ROWTYPE attribute and use it to insert and update a row
Create a record and use it to update a table
Summary
Cursors
What is Cursor?
Cursor Types
Implicit Cursor
Use explicit cursors to retrieve data
Cursor attributes
For Loop Cursors
Advantages of For Loop Cursors
Default values in cursors
Use parameters to make cursors reusable in a given scenario
Use an explicit cursor to retrieve and update data
Summary
Exceptions
What is Exception?
Exception Section
About The Exception Section
Isolating the Specific Exception
Outline how each of the PL/SQL exception types are raised and handled
Trap predefined and non-predefined exceptions in PL/SQL
Trap user-defined exceptions and identify error codes and messages
Use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling
Exceptions in PL/SQL
Handle exceptions in PL/SQL
Pragma Exception_Init
SQLcode & SQL Learn
Example SQL%Rowcount
Summary
Stored Procedures
Create, remove, and view PL/SQL stored procedures
Use IN, OUT, and IN OUT parameter modes to pass values to and from stored
procedures and programs
Outline how to view values returned by OUT parameters
Create stored procedures with suitable parameters
Assign values to multiple parameters
Handle exceptions in stored procedures
Summary
Stored Functions
Create a stored function
Execute a stored function
Call, remove, and view stored functions in PL/SQL
Summary
Managing Subprograms
Definer Rights
Invoker rights
List all Procedures and Functions
Summary
Packages
Identify features of PL/SQL packages
Sequence steps for developing PL/SQL packages
Identify the syntax for creating a PL/SQL package
Identify tasks involved in managing PL/SQL packages
Identify features of the overloaded subprograms contained in PL/SQL packages
Identify features of forward referencing in PL/SQL packages
Summary
Managing LOBs
Identify features of the DBMS_LOB package
Identify the code to work with Large Object (LOB) values
Identify methods of selecting Character Large Object (CLOB) values
Identify features of temporary Large Objects (LOBs)
Summary
Triggers
Identify features of triggers
Identify the code to create a Data Manipulation Language (DML) trigger
Identify the code to create a Data Manipulation Language (DML) row
Trigger Match the options for managing triggers with their descriptions
Identify guidelines for testing triggers
Identify the benefits of triggers in different business application scenarios
Identify the syntax for creating triggers for DDL and system events
Summary
Advanced Triggers
Creating Trigger on DDL Statements
LOGON & LOGOFF Trigger example
CALL Statement in Trigger
Advantages of trigger
Conditional Security
Summary
Introduction
Relational and Object Relational Database Management System
Relational Database Concept
Definition of a Relational Database
Entity Relationship Model
Entity Relationship Modeling Conventions
Relational Database Terminology
Relational Database Properties
Communicating with a RDBMS Using SQL
SQL Statements
Writing Basic SQL SELECT Statements
Capabilities of SQL SELECT Statements
Basic SELECT Statement
Selecting All Columns
Selecting Specific Columns
Writing SQL Statements
Column Heading Defaults
Arithmetic Expressions
Using Arithmetic Operators
Operator Precedence
Using Parentheses
Defining a Null Value
Null Values in Arithmetic Expressions
Defining a Column Alias
Duplicate rows
Displaying Table Structure
Summary
Restricting and Sorting Data
Limiting Rows Using a Selection
Using the WHERE Clause
Comparison Conditions
Using the BETWEEN Condition
Using the IN Condition
Using the LIKE Condition
Using the NULL Conditions
Logical Conditions
Using the AND Operator
Using the OR Operator
Using the NOT Operator
Rules of Precedence
ORDER BY Clause
Sorting in Descending Order
Sorting by Multiple Columns
Summary
Single-Row Functions
SQL Functions
Two Types of SQL Functions
Single-Row Functions
Character Functions
Case Manipulation Functions
Character-Manipulation Functions
Number Functions
Using the ROUND Function
Using the TRUNC Function
Using the MOD Function Working with Dates
Arithmetic Operators with Dates Date Functions
General Functions
NVL Function
Using the NVL2 Function
Using the COALESCE Function
The CASE Expression
Using the CASE Expression
The DECODE Function
Summary
Aggregating Data Using Group Functions
What Are Group Functions? Types of Group Functions Group Functions Syntax
Using the AVG and SUM Functions Using the MIN and MAX Functions Using the COUNT Function
Using the DISTINCT Keyword Group Functions and Null Values
Using the NVL Function with Group Functions
Creating Groups of Data: The GROUP BY Clause Syntax Using the GROUP BY Clause on Multiple Columns Excluding Group Results: The HAVING Clause
Nesting Group Functions Summary
Displaying Data from Multiple Tables (Joins)
Obtaining Data from Multiple Tables Cartesian Products
Generating a Cartesian Product Types of Joins
Joining Tables Using Oracle Syntax What is Equi Join?
Retrieving Records with Equijoins
Additional Search Conditions Using the AND Operator Qualifying Ambiguous Column Names
Using Table Aliases
Joining More than Two Tables Non-Equijoins
Retrieving Records with Non-Equijoins Outer Joins
Outer Joins Syntax Using Outer Joins Self Joins
Creating Joins with the USING Clause Retrieving Records with the USING Clause Creating Joins with the ON Clause Retrieving Records with the ON Clause INNER Vs OUTER JOIN
Summary
Subqueries
Using a Subquery to Solve a Problem Subquery Syntax
Guidelines for Using Subqueries Types of Subqueries
