SELF PACED ON-DEMAND COURSE ONLY

Course designed for Beginners and Experienced IT Personnel, to get Strong Foundation in Oracle (Relational Database) and UNIX (Operating System) which is vital for ALL IT Careers & Advancement Courses!

Target Audience: IT Beginners, Business Analysts, Quality Analysts  and ALL other IT Developers and Analysts.

ORACLE 11g (& TOAD for Oracle Tool)

MODULE-1: ORACLE DATABASE 11g TECHNOLOGY INTRODUCTION

• Relational Database Management System (RDBMS) Concepts
• Data Modeling Concepts: Normalization to 3 NF
• Benefits of RDBMS Concepts over Flat File DBMS

MODULE-2: ORACLE ARCHITECTURE, CONNECTION & TOOLS

• Basic Oracle Architecture: Oracle SGA Memory (Buffer Cache / Shared Pool), Files / Storage (Database / Tablespace / Data FIles / Extent / Data Block)
• SQL Net, TNS Names and LDAP Connections
• Oracle Client Home Directories & Connect Modes
• Connecting to Oracle Database
• SQL Plus / Spool Files / Built-in-Editor Commands / Run Scripts
• Reviewing the Oracle Database Installation

MODULE-4: DATABASE OBJECTS CREATION

• Database, Schema, User & Database Objects Introduction
• Data Definition Language (DDL) Basics
• Oracle Data Types
• Creating / Altering / Dropping Tables

MODULE-5: DATA MANIPULATION

• Data Manipulation Language (DML) Basics
• Structured Query Language (SQL)
• Select Statement Basics
• Executing Select Statements

MODULE-6: DATA DICTIONARY

• Data Dictionary Basics
• Different Views (DBA / ALL / User) & Usage

MODULE-7: SQL / SQL PLUS  & DATA CONTROL 

• Difference between SQL and SQL Plus Commands
• Writing SQL Statements
• Limiting and Sorting
• Single Row Functions

MODULE-8: INDEXES

• Indexes Introduction
• Types of Indexes
• Creating/ Dropping Indexes
• Constraints - Definition, Creation and Dropping

MODULE-9: VIEWS & SEQUENCES

• Creating Simple and Complex Views
• Dropping Views
• Creating Sequences
• Use of Sequences in SQL statements

MODULE-10: USER ACCESS CONTROL & STORAGE COMPONENTS 

• Creating Users and Roles
• Grant and Revoke Statements
• Table Spaces, Segments and Blocks

MODULE-11: MORE DATA MANIPULATION

• Inserting Data
• Updating Data
• Merging data
• Deleting Data
• Transaction Control (Commit & Rollback)

MODULE-12: DATA RETRIEVAL FROM MULTIPLE TABLES 

• Joins Introduction
• Equi-Join and Non Equi-Joins
• Outer Joins
• Self Joins

MODULE-13: AGGREGRATION

• Group Functions  Introduction
• Group Data using Group By clause
• Including and Excluding rows using having clause

MODULE-14: SUB-QUERIES

• Types of Problems Sub-Queries can solve
• Types of Sub-Queries
• Single row and Multiple row Sub-Queries

MODULE-15: ORACLE OPTIMIZER OVERVIEW

• Optimizer Role
• Rule based and Cost based Optimizer
• Execution Plan
• Query Tuning & Statistics

MODULE-16: SERVER PROGRAMMING OVERVIEW WITH PL/SQL

• Programming Language Introduction
• Stored Procedure / Function / Package Overview
• Use of Cursors
• Triggers - Definition and Use
• PL/SQL Constructs - IF THEN ELSE , FOR loop
• CURSOR FOR Loop
• Implicit and Explicit Cursor
• Exception Handling

Classes: 20 Hours