Course details

ORACLE

Part I - SQL - Structured Query Language

Introduction to SQL
Retrieving Data
Restricting and Sorting Data
Using Single row Functions
Conversion Functions
Date
Strings / Characters
Numbers
Reporting data using Data Aggregation functions
Displaying data from Multiple Tables
Using sub-queries to problems

Part I - SQL - Structured Query Language

Using set Operators
Managing Tables using DML Statements
Managing Users & Privileges using DCL Statements
Working with DDL statements
Introduction to Data Dictionary Views
Creating Synonyms, Views, Sequences and Indexes
Managing Schema Objects
Managing Data in Different Time Zones
Working with Advanced Queries
Regular Expressions
Hierarchy Queries

Join Us

Part - II PL/SQL (Procedural Language/Structured Query Language)

Introduction to PL/Sql
Declaring Variables
Understanding Blocks
Anonymous
Named
Writing Executable Statements
Using SQL Statements within PL/SQL
Writing Control Structures
Working with Composite DataTypes
Understanding Cursors
Implicit Cursors
Explicit Cursors
Handling Exceptions
Introduction to Functions, Procedures and Triggers
Creating and Using Functions
Creating and Using Procedures
Working with Triggers
Creating Compound, DDL and Event Database Triggers
Introduction to Packages
Working with PL/Sql Supplied packages
Creating custom Packages
Using Dynamic SQL
Using PL/SQL compiler

Part-III APEX (Application Express)

Introduction to Oracle Application Express
Understanding Basic APEX application Structure
Creating a Workspace and connect Database Schema
Login Into a Workspace
Understanding User Roles
Working with Application Builder
Creating a Application
Creating a Dashboard
Creating components on a Dashboard
Creating and Adding Pages to a dashboard
Working with Forms
Understanding Master / Detail Forms
Working with reports
Creating a Custom Report
Creating a Parameterized Report
Working with Items in a Form/Report
Deploying Application
Security Considerations for APEX

Join Us