Oracle 10g Course Content
Overview:
Oracle 10g is a version of the Oracle Database. The g stands for “grid” to indicate that 10g is “grid-computing ready”. It reduces the costs and increasing up time by making the database easier to manage Applications. One way of doing this is to automate tasks that previously had to be done manually by the DBA. A new Automated Storage Management (ASM) sub system is developed to achieve this for Oracle 10g. This feature removes the need to have a file system or a volume manager for managing the database files and eliminates the complexity of balancing data across the disks and controllers manually.
Training Objectives of Oracle 10g:
Oracle 10g Aspirants can easily learn concepts of create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). We will also be introducing Oracle 10g database features and tools to the students. Students also develop deeper insight into relational Database Architecture Design and RDBMS Operations and learn the concepts and specific SQL syntax for extended Oracle Data types. Analysis and Tuning techniques to increase SQL performance and master advanced features of Oracle® SQL for large data sets and data warehouses.
Target Students / Prerequisites:
Students Must be belong IT Background and aware of Concepts in Database and Logical Programming.
Oracle Training Course Duration
Normal Track : 60 Working days, daily one and half hours Fast Track : 45 Working days, daily two hours
DBMS
- File and File system
- Disadvantages of file
- Concepts of DBMS
- Introduction
- Importance and Need
- Database Models and Normalization
- Models
- Hierarchial
- Relational
- Object
- Normalization Techniques
Introduction to RDBMS
- Concepts of RDBMS
- Introdution
- Comparision with DBMS
- COOD Rules
- Normalization Revisited
- Concepts of ORDBMS & OODBMS
- Introduction to ORDBMS
- Introduction to OODBMS
- Comparision and analysis
- Oracle Corporation Products
- Oracle Versions
- About SQL&SQL*PLUS
Structured Query Language(SQL)
- Introduction to SQL
- Predefined Data Types
- Introduction to database objects
- Table,View
Commands in SQL
- Data Defination Language(DDL)
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Transaction Control Language(TCL)
- Database Security and Privileges(DCL)
Working with DDL,DML,TCL Commands
- Operators
- Conditional,Logical,Comparison,SET
- Functions /
- Date,Number,Character,String,Group,Group by,Having clause
- Transformation Functions
- DECODE,TRANSLATE
- NVL,NVL2(9i)
- Aggregate Functions
Integrity Constraints
- Different Types of Integrity Constraint
- Use of Integrity Constraint in table
PL-SQL (Procedure Language – SQL)
- Introduction to Programming Languages
- Introduction to PL/SQL
- The Advantages of PL/SQL
- PL/SQL Architecture
- PL/SQL Data types
- Variable and Constants
- Using Built_in Functions
- Conditional and Unconditional Statements
- Simple if, if… else, nested if..else, if..else Ladder
- Selection Case, Simple Case, GOTO Label and EXIT
- Iterations in PL/SQL
- Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
- SQL within PL/SQL
- Composite Data types (Complete)
- Cursor Management in PL/SQL
- Implicit Cursors
- Explicit Cursors
- Cursor Attributes
- Cursor with Parameters
- Cursors with LOOPs Nested Cursors
- Cursors with Sub Queries
- Ref. Cursors
- Record and PL/SQL Table Types
Advanced PL/SQL
- Procedures in PL/SQL
- STORED PROCEDURES
- PROCEDURE with Parameters (IN,OUT and IN OUT)
- POSITIONAL Notation and NAMED Notation
- Procedure with Cursors
- Dropping a Procedure
- Functions in PL/SQL/
- Difference between Procedures and Functions
- User Defined Functions
- Nested Functions
- Using stored function in SQL statements
- Packages in PL/SQL
- Creating PACKAGE Specification and PACKAGE Body
- Private and Public Objects in PACKAGE
EXCEPTIONS in PL/SQL
- Types of exceptions
- User Defined Exceptions
- Pre Defined Exceptions
- RAISE_APPLICATION_ERROR
- PRAGMA_AUTONOMOUS_TRANSACTION
- SQL Error Code Values
Database Triggers in PL/SQL
- Types of Triggers
- Row Level Triggers
- Statement Level Triggers
- DDL Triggers
- Trigger Auditing
File Input/Output
- PL/SQL file I/O (Input/Output)
- Using UTL_FILE Package
Implementing Object Technology
- What is Object Technology ? /
- OOPS-Object Instances
- Creation of objects
- Creating User Defined Data Types
- Creating Object Tables
- Inserting rows in a table using Objects
- Retrieving data from Object based Tables
- Calling a Method
- Indexing Abstact Data type Attributes
Using LOBS
- Large Objects (LOBS)
- Creating Tables-LOB
- Working with LOB values
- Inserting, Updating & Deleting Values in LOBs
- Populating Lobis DBMS_LOB Routines
- Using B-FILE
Using Collections
- Advantages of collection
- Ref cursor (Dynamic Cursor)
- Weak ref cursor
- Strong ref cursor
- Nested Tables VARRAYS or VARYING arrays
- Creating tables using nested tables
- Inserting, updating & deleting Nested
- Table records
- Nested table in PL/SQL
Oracle Database Architecture
- Introduction to Oracle Database Architect/ure
- Physical structures Logical structures
- DB Memory Structures Background Process
- 2 Tire, 3 Tire, N-Tier Architecture
Advanced Features
- 9i Joines
- New Date function
- Rename column
- Inner Join/Natural Join
- Left Outer Join/Right Outer Join
- Full Outer Join
- Multiple Inserts
- Insert All Command
- Merge statement
- NVL2(), NULLIF(), COALESCE()
- CASE expression of Select Command
- Temporary Tables/Global Tables
- New Function EXTRACT()
- Autonomous Traction
- Pragma _ Autonomous_ Transaction()
- Bulk Collect
- About Flash Back Queries
- Dynamic SQL
- New data types, Flash back Command
- Purge Command, Recyclebin
- Regular expressions, DML Error Logging
- Data Pump, Virtual Columns
- Read only tables, Cross tab Views using
- Pivot/Unpivot operators, Follows Clause
- Compound triggers, New data types
DBA CONCEPTS
- Database
- Tablespace
- Types of Tablespaces
- Data files /Se