Infoschool

Oracle 11g Database Administration

Training Overview

Course Duration: 45 Days (Regular Program) / 25 Days (Fast Track) / 10 Weekends (Weekend Batch)
Who Should Join: Any graduate or postgraduate or professional having basic knowledge of computer and database

Oracle Database Course Objectives

Learning SQL/ SQL Plus to communication with Database
Learning to retrive data from database
Creating and Managing Tables and Other Database Objects
Performing Update, Insertion and Deletion Command on Database
Installing Oracle 11g Database on Server
Understaning Oracle Architecture
Learn to manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
Learn to monitor performance, troubleshoot problems, and resolve lock and conflict issues.
Learn to use the Oracle Enterprise Manager and SQL interfaces for administration tasks.
Learn about basic backup and recovery structures and strategies.

Oracle 11g DBA Courseware

Module 1: Introduction to Oracle 11g SQL

Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects

Module 2: Oracle 11g Database Administration Workshop-1

Exploring the Oracle Database Architecture
Preparing the Database Environment
Creating an Oracle Database
Managing the Oracle Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data and Concurrency
Managing Undo Data
Implementing Oracle Database Security
Database Maintenance
Performance Management
Intelligent Infrastructure Enhancements
Backup and Recovery Concepts
Performing Database Backup
Performing Database Recovery
Moving Data

Module 3: Oracle 11g Database Administration Workshop-2

Database Architecture and ASM
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Specifications
Using RMAN to Create Backups
Performing User-Managed Backup and Recovery
Using RMAN to Perform Recovery
Using RMAN to Duplicate a Database
Performing Tablespace Point-in-Time Recovery
Monitoring and Tuning RMAN
Using Flashback Technology
Additional Flashback operations
Diagnosing the Database
Managing Memory
Managing Database Performance
Space Management
Managing Resources
Automating Tasks with the Scheduler
Administering the Scheduler

ON-DEMAMD OPTIONAL MODULES

Module 4: Managing Oracle on Linux

Review of Linux Basis
Preparing Linux for Oracle
Installing Oracle on Linux
Managing Storage on Linux
Using Oracle ASM on Linux
Automating Oracle on Linux
Optimizing Oracle For Linux
Additional Linux Tips For DBAs
Troubleshooting Oracle Issues on Linux

Module 5: Oracle 11g Database Suite Implementation on Linux or Windows Server

What is Virtualization Technology
Types of Virtualization
How Virtualization can help to cut the cost
Demonstration of Virtual Infrastructure
Assumption of Scenario
Database Designing for Scenario
Setting Up Windows 2008 Server Environment For Oracle Installation
Installing Oracle 11g R2 Software
Creating Database Without Sample Schema
Creating Schemas and Delegating Authorities with Roles and Privileges
Implementing Database Designing
Generating Runtime SQL statement for common tasks
Installing "TOAD For Oracle" for administrative jobs
Installing "NAVICAT For Oracle" on Client Devices
Implementing Clients and Server inside virtual private network to access each other
Setting up Backup procedures
Automating Backup

Email: infoschool.in@gmail.com

Join this course now

E-Mail:*	Enter correct e-post adress Enter e-post adress
Password:*	Enter Password
	register

Contact counselors

Training @ infoschool

Success stories

I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.

By Vidya,
SAS Developer, PowerSoft Technologies,