Course Duration in Hours
90
90
Introduction to SQL
Introduction to PL/SQL
Filtering and Sorting Data
WHERE Clause
ORDER BY Clause
SQL Functions
Expressions in a SELECT Statement
Single Row Functions
Group Functions
Working with Multiple Tables
Joins
Subqueries
Set Operators
Tables and Constraints
Creating and Modifying Tables
Integrity Constraints
Managing Data in Tables
Transaction Control Language Statements
Other Database Schema Objects
Sequences, Synonyms, and Indexes
Views
Database Object Security
Building PL/SQL Blocks
Creating PL/SQL Blocks
Manipulating Data in PL/SQL
PL/SQL Control Structures
Conditional Control Structures
Iterative Control Structures
Cursors
Introduction to Cursors
Implicit Cursors
Explicit Cursors
Cursor Loops
Exception Handling
Introduction to Exception Handling
Types of Exceptions
Procedures and Functions
Developing Procedures and Functions
Passing Parameters
Oracle Packages
Developing Packages
Oracle-supplied Packages
Oracle Triggers
Building a Trigger
Trigger Restrictions
PL/SQL Collections
Defining and Using Collections
Collection Methods
B.Tech (CS/IT), MCA, BCA, BSCIT
Global Institute Of Technology(GIT), Sector 2 (Noida),Noida,IN