|
|
| Oracle Administrator11g/12g |
PROGRAMS |
PREREQUISITES |
MODULE WISE DETAILS |
COURSE
DURATION |
ORACLE 10g/11g/12g
DBA |
UG / PG / Diploma /BE/ Bteh / ME / Mtech in any stream with/without Programming
Knowledge |
Module |
Days |
13 Days |
OCA Developer |
4 Days |
a. SQL with Dumps |
2 days |
b. PLSQLwith Dumps |
2 days |
OCA + OCP – in DBA |
6 Days |
a.DBA 1 with Dumps |
3 Days |
b.DBA 2 with Dumps |
3 Days |
Advanced DBA Concepts with with Performance Tuning |
1 Day |
UNIX and Shell Scripts |
1 Day |
Projects & Real time scenarios |
1 Day |
Case Studies and
Mock Interviews |
1 Day |
Session 1: RELATIONAL DATABASE CONCEPTS
• What is an Oracle Database
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Supported Data types
• The Data Dictionary
Session 2: USING SQL*PLUS
• What is SQL*Plus
• Getting Started
• Entering and Executing SQL Statements
• Editing SQL Statements
• Creating, Editing and Executing SQL Files
Session 3: USING SQL DEVELOPER
• What is Oracle SQL Developer
• Starting SQL Developer
• Configure a Connection
• Navigation Tabs
• SQL Worksheet
Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT
• The SELECT Statement
• The SELECT and FROM Clauses
• Conditions and the WHERE Clause
• Other Conditional Operators
• Logical Operators
• The ORDER BY Clause
• Column Aliases
• Arithmetic Expressions
• Precedence of Operators
Session 5: AGGREGATE FUNCTIONS
• Overview of Built In Aggregate Functions
• The GROUP BY Clause
• The HAVING Clause
Session 6: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
• Self Joins
• ANSI Standard Joins
• Set Operators
Session 7: NUMERIC, CHARACTER AND DATE FUNCTIONS
• Function Types
• Using the Table dual to try out Functions
• Numeric Functions
• Character Functions
• String Concatenation
• Date Arithmetic and Date Functions
Session 8: CONVERSION AND MISCELLANEOUS FUNCTIONS
• Conversion Functions
• The NVL and NVL2 Functions
• The DECODE Function
• CASE Expressions
• The COALESCE and NULLIF Functions Session 9: SQL*PLUS PARAMETERS
• Command Line Substitution Parameters
• The Accept Command
• The Define and Undefined Commands
Session 10: USING SUBQUERIES
• Overview of Subqueries
• In-Line Views
• Top-N Queries
• Complex Subqueries
• Multi Column Subqueries
• Correlated Subqueries
• Subquery Rules
• Using the ANY, ALL and SOME Operators
Session 11: MANAGING DATA
• Inserting Rows
• Updating Rows
• Deleting Rows
• Verifying Updates
• Transaction Control
• Commit and Rollback
• Savepoints
• Commits and Constraints
• Amending Data in SQL Developer
Session 12: MANAGING TABLES
• Creating Tables
• Specifying Constraints
• Altering Tables, Columns and Constraints
• Dropping Tables, Columns and Constraints
• Copying Tables
Session 13: MANAGING INDEXES AND VIEWS
• Creating Indexes
• Dropping Indexes
• Listing Indexes
• Creating and Using Views
• Dropping Views
• Listing Views
Session 14: MANAGING SEQUENCES AND SYNONYMS
• Create a Sequence
• View Sequence Details
• Create a Synonym
• List Synonyms
Session 15: RETRIEVE DATA USING SUBQUERIES
• ANY, ALL or SOME Operators
• Correlated Subqueries
• In-Line Views
• The Exists Operator
• The WITH Clause
• Multi-Column Subqueries
• Insert and Update Using a Query
• Correlated Update and Delete
Session 16: HIERARCHICAL QUERIES
• Hierarchical data
• The START WITH and CONNECT BY clauses
• The LEVEL pseudo-column
• Sequencing the output
• Eliminating nodes and branches
Session 17: ENHANCED GROUPING FEATURES
• Review of basic grouping concepts
• The ROLLUP and CUBE extensions
• The GROUPING SETS extension
• Using the GROUPING and GROUPING_ID functions
Session 18: MANAGE LARGE DATA SETS
• Multi-table Inserts
• Conditional and Unconditional Inserts
• Merging Data into a Table
• Table and View Based Merge
• A Sub Query Based Merge
Session 19: FLASHBACK TECHNOLOGY
• Flashback Query
• The DBMS_FLASHBACK Package
• The AS Clause
• Flashback Table
• Flashback Drop
• Flashback Data Archive
Session 20: DATE, TIME AND TIMEZONE SUPPORT
• Date, Timestamp and Interval datatypes
• Handling dates and times
• Handling intervals
• Date, timestamp and interval functions and literals
• Related NLS parameters
Session 21: REGULAR EXPRESSION SUPPORT
• Regular Expression Notation
• Character matching
• Repetition operators
• Sub expression grouping
• Regular expression functions
Session 22: MANAGE SCHEMA OBJECTS
• Column Operations
• Constraint Operations
• Creating and Dropping Indexes
• B-Tree Indexes
• Function Based Indexes
• Descending Indexes
• Creating and Using External Tables
Session 23: ACCESS CONTROL
• System Privileges and Roles
• Create Users
• Alter User Details
• Grant and Revoke
Session 24: MANAGE OBJECTS WITH THE DATA DICTIONARY
• The Data Dictionary
• Useful Data Dictionary Tables
Oracle 10g DBA:
Installing Oracle and Building the Database
• Overview of Installation
• Checking Prerequisites
• Installation Choices
• Installing Oracle Software and Database
• Using DBCA to Create and Configure a Database
• Database Identification
• Management Options
• Database Credentials Storage options
• Database File Locations
• Recovery Configuration
• Database Content Initialization Parameters
• Database Storage
• Creation Options
• Configuring Database Options with DBCA
• Deleting a Database with DBCA
• Managing Templates with DBCA
• Advantages of Using Templates
• Types of Templates
• Configuring Automatic Storage Management with DBCA
• Upgrading a Database
• Overview of the Database Upgrade Assistant
• Before the Upgrade
• During the Upgrade
• Support for Real Application Clusters
• Support for Automatic Storage Management
• Support for Silent Mode
• Oracle Database Version Restrictions
• Starting the Database Upgrade Assistant
• Upgrading the Database Using the Database Upgrade Assistant
• Installation: Oracle by Example Series
Getting Started with Oracle Enterprise Manager
• Introduction to the Oracle Enterprise Manager Database Control
• Database Management Features
• Navigational Features
• Starting and Stopping the Oracle Enterprise Manager Console
• Starting dbconsole in Windows
• Accessing the Oracle Enterprise Manager Database Control
• Granting Database Control Administrative Privileges
• Setting Up Enterprise Manager Preferences
• Defining Blackout Time Period
• Setting Preferred Credentials
• SQL Statements and Other Management Tools: SQL*Plus and iSQL*Plus
• Starting SQL*Plus Starting iSQL*Plus
• Managing Your Database: A Roadmap
Configuring the Network Environment
• Understanding Network Configuration
• Oracle Net Listener Configuration
• Client Configuration
• Connection Requests
• Naming Method
• Tools for Network Configuration
• Oracle Net Configuration Assistant
• Enterprise Manager
• Oracle Net Manager
• Viewing Listener Configuration
• Starting and Shutting Down the Listener
• Configuring Oracle Networking on Client Machines
• Networking: Oracle by Example Series
Managing the Oracle Instance
• Overview of an Instance and Instance Management
• Instance Memory Structure
• The System Global Area (SGA)
• Program Global Area (PGA)
• Oracle Background Processes
• Accessing the Database
• How the Oracle Instance and Database are Started
• Server and Client Processes
• Network Connections
• Shutting Down and Restarting the Instance and Database
• Starting and Shutting Down the Database Instance on Windows
• Viewing and Modifying Initialization Parameters
• Managing Memory Parameters
• Modifying Memory Parameters
• Instances: Oracle by Example Series
Managing Database Storage Structures
• Exploring the Storage Structure of Your Database
• Control Files
• Displaying Control File Information
• Online Redo Log Files
• Displaying Redo Log File Information
• Multiplexing the Redo Log
• Archive Log Files
• Displaying Archive Log File Information
Rollback Segments
Displaying Rollback Segment Information
Tablespaces
• Some Tablespaces in the Database
• Temporary Tablespace Groups
• Datafiles
• Viewing Datafile Information
• Other Storage Structures
• Initialization Parameter File
• Password File
• Backup Files
• Performing Common Database Storage Tasks
• Viewing Tablespaces in Your Database
• Creating a Tablespace
• Modifying a Tablespace
• Dropping a Tablespace
• Reclaiming Wasted Space
• Viewing Segment Advisor
• Recommendations
• Running the Segment Advisor Manually
• Managing Undo for Your Database
• About Undo Data
• Undo Tablespace Size and Retention Time
• Automatic Undo Management
• Managing Undo with Enterprise Manager
• Using the Undo Advisor
• Gaining Advice from Undo Advisor
• Extending the Undo Tablespace
• Setting Minimum Undo Retention Time
• Making Changes to the Database Storage Structure
Administering Users and Security
• Overview of Users and Security
• Database Administrative Accounts
• SYS
• SYSTEM
• Administrative Privileges
• Administering Roles
• About Privileges and Roles
• Viewing Roles
• Creating Roles
• Modifying Roles
• Dropping Roles
• Administering Profiles
• Administering Database Users
• Creating Users
• Using a Shortcut to Create Users
• Editing Users
• Changing the Tablespace Quota for a User
• Unlocking Accounts and Resetting Passwords
• Granting Roles
• Revoking Roles
• Dropping Users
Managing Schema Objects
• Overview of Schemas and Common Schema Objects
• Exploring Your Database's Schema Objects
• Managing Database Objects
• Managing Tables
• Viewing Tables
• Viewing Table
• Types of Table
• Column Attributes
• Table-Level constraints
• Attributes
• Other Table Creation Considerations
• Estimating the Size of New Tables
• Creating a Table: Example
• Modifying Table Attributes
• Adding a Column
• Dropping a Column
• Creating a New Table Constraint
• Modifying an Existing Constraint
• Dropping a Constraint
• Dropping a Table
• Managing Indexes
• Viewing Indexes
• Creating Indexes
• Index Types
• Creating an Index: Example
• Dropping Indexes
• Managing Views
• Displaying Views
• Creating a View: Example
• Dropping Views
• Managing Database-Resident Program Units
• Managing Packages
• Viewing Packages
• Creating Packages
• Editing Packages
• Dropping Packages
• Managing Package Bodies
• Viewing Package Bodies
• Managing Standalone Subprograms
• Managing Triggers
• Other Schema Objects
• Loading Data Into Tables
Performing Backup and Recovery
• Overview of Database Backup and Recovery
• Oracle Backup, Restore, and Recovery Concepts
• Consistent and Inconsistent Backups
• Media Recovery
• The Flash Recovery Area
• The RMAN Repository
• Configuring Your Database for Basic Backup and Recovery
• Planning Space Usage and Location for the Flash Recovery Area
• Retention Policy and the Flash Recovery Area
• Sizing the Flash Recovery Area
• Credentials for Performing Oracle Enterprise Manager Backup and Recovery
• Preferred Credentials for Backup and Recovery
Configuring the Flash Recovery Area
• Configuring ARCHIVELOG Mode For the Database
• Configuring Backup Settings
• Understanding Backup Device Settings for Disk
• Configuring Backup Policy Settings
• Backing Up Your Database
• Database Backup Concepts
• Full Backups of Datafiles
• Incremental Backups of Datafiles
• Incrementally Updated Backups: Rolling Forward Image Copies of Datafiles
• Using Tags to Identify Backups
• Performing and Scheduling Backups with Enterprise Manager
• Performing a Whole Database Backup with Oracle Enterprise Manager
• Using the Oracle-Suggested Backup Strategy
• Scheduling Other Backup Tasks
• Validating Backups and Testing Your Backup Strategy
• Performing Restore and Recovery Operations
• Recovering a Whole Database from Backup
• Recovering from a Lost SPFILE or Control File
• Validating the Restore of Datafiles from RMAN Backup
• Returning a Table to a Past State: Flashback Table
• Enabling Row Movement on a Table
• Performing Flashback Table
• Recovering Dropped Tables: Flashback Drop
• Managing Your Backups
• Backup Management: Concepts
• Using the Manage Current Backups Page
• Searching for Backups on the Manage Current Backups Page
• Managing Current Backups: Backup Sets
• Managing Current Backups: Image Copies
• Validating the Contents of Backup Sets or Image Copies
• Crosschecking Backups
• Deleting Expired Backups
• Marking Backups as Available or Unavailable
• Deleting Obsolete Backups
• Displaying Backup Reports
Monitoring and Tuning the Database
• Proactive Database Monitoring Alerts
• Performance Self-Diagnostics: Automatic Database Diagnostics Monitor
• Monitoring General Database State and Workload
• Managing Alerts
• Viewing Metrics and Thresholds
• Setting Metric Thresholds
• Responding to Alerts
• Clearing Alerts
• Setting up Notification
• Diagnosing Performance Problems
• Viewing Performance Analysis
• Responding to Performance Findings
• Modifying Default ADDM Behavior
• Running ADDM Manually
• Using Advisors to Optimize Database Performance
• About Performance Advisors
• Using the SQL Tuning Advisor
• Using the SQL Access Advisor
• Using the Memory Advisor
• Setting New SGA or PGA Targets
• Determining Performance Impact for Altering your SGA or PGA
• Managing Oracle Software
• About Software Management and Patch Releases
• Applying a Patch Release
• Determining your Oracle Software Environment
• Determining the Oracle Database Version
• Determining the Location of your Oracle Home
• Determining Your Hardware Configuration
• Setting your Oracle MetaLink Login Credentials
• Staging the Patch Release
• Installing the Patch Release
• Installing the Patch Release: General Steps
• Automatic Storage Management
• What is Automatic Storage Management?
• Overview of Disks, Disk Groups, and Failure Groups
• Installing Automatic Storage Management
• Accessing the Automatic Storage Management Home Page
• Accessing the ASM Home Page on a Single Instance System
• Accessing the ASM Home Page On a Real Application Clusters System
• Starting Up and Shutting Down the ASM Instance
• Monitoring Disk Group Space Usage
• Creating a Disk Group
• Dropping a Disk Group
• Adding Disks to a Disk Group
• Dropping Disks from a Disk Group
• Backing Up ASM-Managed Files
Overview of Real Application Clusters
• What is Real Application Clusters?
• Real Application Clusters Database Configuration Scenario
• Differences in Administering RAC and Single-Instance Databases
• Monitoring RAC with Enterprise Manager
• Overview of the Cluster Database Home Page
• Viewing RAC Database Targets
• Navigating to Oracle Enterprise Manager Cluster-Related Pages
• Viewing and Modifying RAC Database Initialization Parameters
• Starting and Stopping the RAC Database and Database Instances
• Starting and Stopping RAC Databases
• Starting and Stopping Individual Instances in a RAC Database
• Managing RAC Backup and Recovery
• Redo Log Groups and Redo Threads in Real Application Cluster Databases
• Backing Up RAC Databases
• Overview of Restore and Recovery Operations for a RAC Database
• Using a Flash Recovery Area with a RAC Database |
|
|
|
|
