USA: +1 734 418 2465 | India: +91 40 4018 1306 | info@learntek.org

Setup Menus in Admin Panel

LEARNTEK
rsz_oracle-11g-sql_plsql

Oracle 11g SQL/PLSQL Training

Inquiry Now

Product Description

Oracle SQL

Database Concepts

File Management System

Data Base Management System

Relational Database Management System

Database Design

Normalization

First Normalization Form

Second Normalization Form

Third Normalization Form

Integrity

Data Integrity

Referential Integrity

Types of Constraints

Data Definition Language (DDL)

Creating Tables

Dropping Tables

Altering the Structure of Table

Truncate

Merging of Tables

Data Manipulation Language (DML)

Inserting Records

Deleting Records

Updating Records

Operators

Data Query Language (DQL)

Retrieving Data

Sub Queries

Nested Sub Queries

Correlated Sub Queries

Hierarchical Retrieval

Exists, Any, All

Group By

Having

Rollup

Cube

Data Control Language (DCL)

Grant

Revoke

Joins

Introduction To Joins

Inner Joins

Outer Joins

Self Join

Cross Joins

Multiple Joins

Oracle Proprietary Outer Join Operator

USING Keyword

Set Operators

Union

Union All

Intersect

Minus

System Functions

Aggregate Functions

Single Row Functions

Multiple Row Functions

Date Functions

Regular Expression Support

Managing Data in Different Time Zones

Handling Constraints

Primary Key Constraint

Unique Constraint

Check Constraint

Foreign Key Constraint

Views

Creation Of Views

Updatable , Un updatable Views

With Check Option

With Read Only Option

Creating Complex Views

Sequences

Creating, Altering, Dropping Sequences

Cycle, No Cycle

Cache, No Cache

Indexes

Introduction To Indexes

Duplicate/Unique Index

Creating Simple/Complex Index

Multiple Indexes On A Table

Clusters

Cluster Key

Cluster Indexes

Hierarchal Retrieval

Basic hierarchal retrieval

Using Level

Pruning branches/children

Oracle 11g Tool

Introduction

Creating Schema Objects

Managing Users

Generating Reports

Oracle PL/SQL

Basics Of PL/SQL

Introduction

Declaration Section

Execution Section

Exception Handling Section

PL/SQL Placeholders

Control Structure

Conditional Statements (IF Statements, Case Statements)

Iterative Statements (Simple Loop, While Loop, For Loop)

Sequential Controls (GOTO Statement, Labels)

Oracle’s Exception Handlers

Error Handling In PL/SQL

Oracles-Named Exception Handler

Unnamed System Exceptions

User Defined Exception Handling (For Business Rule Validations)

Raise_Application_Error()

Dynamic PL/SQL

Introduction To PL/SQL Programming

Writing PL/SQL Programs

Functions, Stored Procedures, Packages

Create, Alter and Drop A Function.

Create, Alter and Drop A Stored Procedures

Create, Alter and Drop A Packages

Triggers

Introduction to Triggers

Creating, Altering, Dropping Triggers

After, Before, Instead of Triggers

OLD, NEW Key Words

Cursors

Creating Cursors

Implicit Cursor (Single and Multiple Row Implicit Cursors)

Explicit Cursors

Cursor Execution Cycle

Cursor FOR Loops

Dynamic Cursors FOR Loops

Parameterized Cursor

Using FOR UPDATE Clause in Cursor

Exception With Cursor

Cursor Within Cursor

Transaction Control Language (TCL)

Commit

Rollback

Save point

Locks

Types of Locks

Levels of Locks

Explicit Locking

Deadlock

Bulk

Bulk Collect

Forall

%Type

%Rowtype

Table Variables

Records

Additional advanced topics

LAG and LEAD

Pivot and Unpivot

Decode

Duration & Timings :

Duration – 30 Hours.

Course Fee : $300    Discount Offer  

Training Type: Online Live Interactive Session.

Faculty: Experienced.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. October 21 2017.

Weekday Session – Sun – Thu 8:30 PM to 10:30 PM (EST) – 3 Weeks.  November 5, 2017.

Weekend Session – Sat & Sun 9:30 AM to 12:30 PM (EST) – 5 Weeks. November 25, 2017.

About Learntek

Learntek is global online training provider on Big Data, Hadoop, Data Analytics and other IT and Management courses. We are dedicated to designing, developing and implementing training programs for students, corporate employees and business professional.

Our job is to make sure your training and learning experience is everything it should be – exciting, enjoyable, stimulating and successful.
top