L'Obel Certified Oracle DBA Training in Bangalore

Certificate Program Provided by L'Obel IT-Palaestra L'Obel Certified Oracle DBA Training in Bangalore, India La Obel Certified Oracle DBA Training in Bangalore, India - http://www. lobelitp. com ------------------------------------------------------------------------------------------ L'Obela s Oracle DBA Training course will help you acquire advanced skills for becoming a skilled Oracle DBA Specialist. ORACLE DBA @ L'Obel :- is designed to make the participant the most sought after Oracle DBA Expert. This makes the participant familiar with the most popular tools and technologies in Oracle DBA. On completion of this course the participant can join the industry as a Oracle DBA Consultant/ Specialist. INTERNSHIP @ L'Obel :- is unique in its Oracle DBA Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous Internship in its SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/ her a complete Oracle DBA Professional. Oracle DBA Course Syllabus --------------------------------------------------- Introduction to Oracle SQL a Writing a basic SQL Statement a Restricting and Sorting Data a Single Row Functions a Displaying Data From Mutiple Tables a Cououp Functions a Writing Subqueries a Producing Readable Output with iSQL *plus a Manipulating Data a Creating and Managing Tables a Including Constraints a Creating Views a Other Database Objects a Controlling User Access a SQL Workshop a Using Set Operators a Aggregate table a Oracle 9i Date time Functions a Enhancements to GROUP by Clause a Hierarchical Rertrieval a Oracle 9i Extension to DML and DDL Statements Oracle Fundamentals I a Oracle Architectural Components a Getting Started with the Oracle Server a Identifying the features of the Universal Installer a Defining the Optimal Flexible Architecture a Creating a database during Installation a Creating a New Database a Identifying database administrative users a Managing an Oracle Instance a Creating a Database a Using the Data Dictionary a Maintaining the Control File a Maintaining Redo Log Files a Managing Tablespaces and Datafiles a Describing Storage hierarchy a Establishing the difference between System and Non-System tablespaces a Storage Structures and Relationships a Managing Undo Data a Understanding the difference between automatic undo Management and Manual undo management a Creating and Maintaining UNDO tablespaces a Managing Tables a Managing Indexes a Identifying unused indexes Oracle Fundamentals II a Networking Overview a Basic Oracle Net Architecture a Basic Oracle Net Services Server-Side Configuration a Basic Oracle Net Services Client-Side Configuration a Usage and Configuration of the Oracle Shared Server a Backup and Recovery Overview a Instance and Media Recovery Structures a Configuration of the Database Archiving Mode a Oracle Recovery Manager (RMAN) Overview and Configuration a User ? Managed Backups a RMAN Backups a User Managed Complete Recovery a RMAN Complete Recovery a User Managed Incomplete Recovery a RMAN Incomplete Recovery a RMAN Repository Maintains a RMAN Catalog Creation and Usage a Transporting Data between Databases a Backup and Recovery and Networking Workshop Oracle Performance Tuning a Overview of Oracle 9i Database Performance a Tuning a Diagnostic and Tuning Tools a Database Configuration and I/ O Issues a Tuning the Shared Pool a Tuning the Buffer Cache a Dynamic Instance Resizing a Sizing Other SGA Structures a Tuning the Oracle Oracle Shared Server a Optimizing Sort Operations a Using Resource Manager a SQL Statement Tuning a Managing Statistics a Using Oracle Blocks Efficiently a Using Oracle Data Storage Structures Efficiently a Application Tuning a Using Materialized Views a Monitoring and Detecting Lock Contention a Tuning the Operating System Oracle PL/ SQL a Introduction a Declaring Variables a Writing Executable Statements a Interacting with the Oracle Server a Writing Control Structures a Working with Composite Data Types a Writing Explicit Cursors a Advanced Explicit Cursor Concepts a Handling Exceptions a Creating Procedures a Creating Functions a Managing Subprograms a Creating Packages a More Package Concepts a Using Oracle-Supplied Packages a Creating Database Triggers a More Trigger Concepts a Managing Dependencies Oracle Forms Release a Introduction to Forms a Overview of the Designer Interface a The Runtime Interface a Querying the Database a Normal and Enter Query Mode a Manipulating the database a Enhancing the Form a The Form Designer a The Object Navigator a The Layout Editor a The Properties Window a The Menu Editor a Forms Objects a Blocks and Relations a Items a Controls a Windows and Dialogue Boxes a Record Structures and Other Objects a Manus and Toolbars Oracle Reports Release a Introduction to Reports a Overview of the Designer Interface a The Object Navigator the Data Model a Defining the Data Model a The Layout Model a The Specifying a Runtime Parameter Form a Creating Reports a Formulas and Summaries a Changing Fonts and Modifying Field Properties a Page Layout adjusting Page Size a Report Headers and Footers a Anchors a Creating Forms a Creating Forms Letters a Creating Mailing Labels a Creating Matrix Reports a Combination Reports a Creating Parameter Forms a Adding Buttons, Images and Other Objects to Your Reports a Creating Templates a Adding Templates to the Default design interface a The Runtime Interface Course Duration ------------------------ The duration of the Oracle DBA course is 80 Hours. Contact us --------------- for more information about this Oracle DBA course Visit: http://www. lobelitp. com Write to: info@lobelitp. com Walk into our IT Training centers located in Bangalore.

L'Obel Certified Oracle DBA Training in Bangalore L'Obel Certified Oracle DBA Training in Bangalore, India



L Obel Certified Oracle DBA Training in Bangalore, India - http://www. lobelitp. com
------------------------------------------------------------------------------------------

L'Obel s Oracle DBA Training course will help you acquire advanced skills for becoming a skilled Oracle DBA Specialist.

ORACLE DBA L'Obel :- is designed to make the participant the most sought after Oracle DBA Expert. This makes the participant familiar with the most popular tools and technologies in Oracle DBA. On completion of this course the participant can join the industry as a Oracle DBA Consultant/ Specialist.
INTERNSHIP L'Obel :- is unique in its Oracle DBA Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous Internship in its SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/ her a complete Oracle DBA Professional.


Oracle DBA Course Syllabus
---------------------------------------------------

Introduction to Oracle SQL
Writing a basic SQL Statement
Restricting and Sorting Data
Single Row Functions
Displaying Data From Mutiple Tables
Cououp Functions
Writing Subqueries
Producing Readable Output with iSQL *plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Other Database Objects
Controlling User Access
SQL Workshop
Using Set Operators
Aggregate table
Oracle 9i Date time Functions
Enhancements to GROUP by Clause
Hierarchical Rertrieval
Oracle 9i Extension to DML and DDL Statements
Oracle Fundamentals I
Oracle Architectural Components
Getting Started with the Oracle Server
Identifying the features of the Universal Installer
Defining the Optimal Flexible Architecture
Creating a database during Installation
Creating a New Database
Identifying database administrative users
Managing an Oracle Instance
Creating a Database
Using the Data Dictionary
Maintaining the Control File
Maintaining Redo Log Files
Managing Tablespaces and Datafiles
Describing Storage hierarchy
Establishing the difference between System and Non-System tablespaces
Storage Structures and Relationships
Managing Undo Data
Understanding the difference between automatic undo Management and Manual undo management
Creating and Maintaining UNDO tablespaces
Managing Tables
Managing Indexes
Identifying unused indexes
Oracle Fundamentals II
Networking Overview
Basic Oracle Net Architecture
Basic Oracle Net Services Server-Side Configuration
Basic Oracle Net Services Client-Side Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuration of the Database Archiving Mode
Oracle Recovery Manager (RMAN) Overview and Configuration
User ? Managed Backups
RMAN Backups
User Managed Complete Recovery
RMAN Complete Recovery
User Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Repository Maintains
RMAN Catalog Creation and Usage
Transporting Data between Databases
Backup and Recovery and Networking Workshop
Oracle Performance Tuning
Overview of Oracle 9i Database Performance
Tuning
Diagnostic and Tuning Tools
Database Configuration and I/ O Issues
Tuning the Shared Pool
Tuning the Buffer Cache
Dynamic Instance Resizing
Sizing Other SGA Structures
Tuning the Oracle Oracle Shared Server
Optimizing Sort Operations
Using Resource Manager
SQL Statement Tuning
Managing Statistics
Using Oracle Blocks Efficiently
Using Oracle Data Storage Structures Efficiently
Application Tuning
Using Materialized Views
Monitoring and Detecting Lock Contention
Tuning the Operating System
Oracle PL/ SQL
Introduction
Declaring Variables
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Writing Explicit Cursors
Advanced Explicit Cursor Concepts
Handling Exceptions
Creating Procedures
Creating Functions
Managing Subprograms
Creating Packages
More Package Concepts
Using Oracle-Supplied Packages
Creating Database Triggers
More Trigger Concepts
Managing Dependencies
Oracle Forms Release
Introduction to Forms
Overview of the Designer Interface
The Runtime Interface
Querying the Database
Normal and Enter Query Mode
Manipulating the database
Enhancing the Form
The Form Designer
The Object Navigator
The Layout Editor
The Properties Window
The Menu Editor
Forms Objects
Blocks and Relations
Items
Controls
Windows and Dialogue Boxes
Record Structures and Other Objects
Manus and Toolbars
Oracle Reports Release
Introduction to Reports
Overview of the Designer Interface
The Object Navigator the Data Model
Defining the Data Model
The Layout Model
The Specifying a Runtime Parameter Form
Creating Reports
Formulas and Summaries
Changing Fonts and Modifying Field Properties
Page Layout adjusting Page Size
Report Headers and Footers
Anchors
Creating Forms
Creating Forms Letters
Creating Mailing Labels
Creating Matrix Reports
Combination Reports
Creating Parameter Forms
Adding Buttons, Images and Other Objects to Your Reports
Creating Templates
Adding Templates to the Default design interface
The Runtime Interface

Course Duration
------------------------

The duration of the Oracle DBA course is 80 Hours.

Contact us
---------------

for more information about this Oracle DBA course
Visit: http://www. lobelitp. com
Write to: info lobelitp. com
Walk into our IT Training centers located in Bangalore.

About The Training Provider: L'Obel IT-Palaestra

More L'Obel Certified Oracle Training from L'Obel IT-Palaestra

• L'Obel Certified Oracle Training in Bangalore