Hi,
Oracle DBA 10g/11g Training Batch's Starting from 14th Aug
Oracle DBA -The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).
Oracle DBA 10g/11g: The Instructor is Oracle Certified DBA. The Instructor has 10 years of Realtime experience working as Oracle Database Administrator using versions 8i/9i/10g on Multiple platforms. Currently working for .................... Instructor will provide lot of real time scenarios and issues DBA will face in real world. Course will immerse you in real world experiences and after finishing the course you will feel you got most of the work experience needed to start working.
Oracle 11g DBA course content
Introduction
· Course Objectives
· Suggested Schedule
· Lesson Objectives
· Oracle Products and Services
· Course Examples: The HR Schema
· Database Architecture: Summary of Structural Components
Installing the Oracle Database Software
· Tasks of an Oracle Database Administrator
· Tools Used to Administer an Oracle Database
· Installation: System Requirements
· Checking the System Requirements
· Optimal Flexible Architecture (OFA)
· Using Optimal Flexible Architecture
· Oracle Universal Installer (OUI)
· Installing the Oracle Software
· Completing Your Installation
· Advanced Installation Options
· Installation Option: Silent Mode
· Practice Overview: Installing the Oracle Software
Creating an Oracle Database
· Planning the Database
· Databases: Examples
· Database Configuration Assistant (DBCA)
· Password Management
· Creating a Database Design Template
· Using the DBCA to Delete a Database
· Practice Overview: Using the DBCA
Managing the Oracle Instance
· Management Framework
· Starting and Stopping Database Control
· Oracle Enterprise Manager
· Accessing Oracle Enterprise Manager Database Home Page
· Setting Up iSQL*Plus for SYSDBA and SYSOPER Access
· Using SQL*Plus
· Starting Up an Oracle Database Instance
· Shutdown Modes
· Viewing the Alert History
· Dynamic Performance Views
· Practice Overview: Managing the Oracle Instance
Managing Database Storage Structures
· Storage Structures
· How Table Data Is Stored
· Anatomy of a Database Block
· Tablespaces and Data Files
· Oracle Managed Files (OMF)
· Space Management in Tablespaces
· Creating a New Tablespace
· Viewing Tablespace Contents
· Enlarging the Database
· What Is Automatic Storage Management?
· ASM: Key Features and Benefits
· ASM: Concepts
· Practice Overview: Managing Database Storage Structures
Administering User Security
· Database User Accounts
· Predefined Accounts: SYS and SYSTEM
· Creating a User
· Authenticating Users
· Administrator Authentication
· Unlocking a User Account and Resetting the Password
· Privileges
· Secure Roles
· Assigning Roles to Users
· Profiles and Users
· Implementing Password Security Features
· Creating a Password Profile
Managing Schema Objects
· What Is a Schema?
· Accessing Schema Objects
· Defining Constraints
· Creating Constraints with SQL: Examples
· Indexes
· BTree Index
· Bitmap Indexes
· Index Options
· Creating Indexes
· What Is a View?
· Sequences
· Using a Sequence
· Temporary Tables
· Data Dictionary: Overview
· Data Dictionary Views
· Data Dictionary: Usage Examples
· Practice Overview: Administering Schema Objects
Managing Data and Concurrency
· Manipulating Data Through SQL
· The INSERT Command
· The UPDATE Command
· The DELETE Command
· The MERGE Command
· The COMMIT and ROLLBACK Commands
· PL/SQL
· Administering PL/SQL Objects
· PL/SQL Objects
· Functions
· Procedures
· Packages
· Package Specification and Body
· Built-in Packages
· Triggers
· Triggering Events
· Locks
· Locking Mechanism
· Data Concurrency
· DML Locks
· Enqueue Mechanism
· Lock Conflicts
· Possible Causes of Lock Conflicts
· Detecting Lock Conflicts
· Resolving Lock Conflicts
· Resolving Lock Conflicts Using SQL
· Deadlocks
· Practice Overview: Managing Data and Concurrency
Managing Undo Data
· Data Manipulation
· Undo Data
· Transactions and Undo Data
· Storing Undo Information
· Undo Data Versus Redo Data
· Practice Overview: Managing Undo Segments
Implementing Oracle Database Security
· Industry Security Requirements
· Separation of Responsibilities
· Database Security
· Principle of Least Privilege
· Monitoring for Suspicious Activity
· Standard Database Auditing
· Enabling Auditing
· Uniform Audit Trails
· Using and Maintaining Audit Information
· FGA Policy
· Audited DML Statement: Considerations
· FGA Guidelines
· DBA Auditing
· Maintaining the Audit Trail
· Security Updates
· Applying Security Patches
· Practice Overview: Implementing Oracle Database Security
Configuring the Oracle Network Environment
· Oracle Net Services
· Oracle Net Listener
· Establishing Net Connections
· Establishing a Connection
· User Sessions
· Tools for Configuring and Managing the Oracle Network
· Listener Control Utility
· Net Services Administration Pages
· Creating a Listener
· Adding Listener Addresses
· Database Service Registration
· Naming Methods
· Configuring Service Aliases
· Advanced Connection Options
· Testing Oracle Net Connectivity
· User Sessions: Dedicated Server
Proactive Maintenance
· Proactive Maintenance
· Introducing Terminology
· Optimizer Statistics
· Statistic Levels
· Automatic Workload Repository (AWR)
· AWR Infrastructure
· AWR Snapshot Sets
· Enterprise Manager and AWR
· Managing the AWR
· Automatic Database Diagnostic Monitor (ADDM)
· The DBMS_ADVISOR Package
· Server Generated Alerts
· Alerts Notification
· Reacting to Alerts
· Alert Types and Clearing Alerts
· Automated Maintenance Tasks
· Practice Overview: Proactive Maintenance
Performance Management
· Performance Monitoring
· SQL Tuning Advisor: Overview
· Using the SQL Tuning Advisor
· SQL Tuning Advisor: SQL Statistics
· SQL Tuning Advisor: Identifying Duplicate SQL
· Using the SQL Access Advisor
· Managing Memory Components
· Enabling Automatic Shared Memory Management (ASMM)
· Manually Setting Shared Memory Management
· Dynamic Performance Statistics
· Troubleshooting and Tuning Views
· Practice Overview: Monitoring and Improving Performance
Backup and Recovery Concepts
· Part of Your Job
· Categories of Failures
· Statement Failure
· Network Failure
· Instance Failure
· Background Processes and Recovery: Checkpoint (CKPT)
· Background Processes and Recovery: Redo Log Files and LogWriter
Background Processes and Recovery: Archiver (ARCn)
· Instance Recovery
· Phases of Instance Recovery
· Tuning Instance Recovery
· Using the MTTR Advisor
· Media Failure
· Configuring for Recoverability
· Control Files
· Redo Log Files
· Multiplexing the Redo Log
· Archive Log Files
· Archive Log File: Naming and Destinations
· ARCHIVELOG Mode
Performing Database Backups
· Backup Solutions: Overview
· Oracle Secure Backup
· User Managed Backup
· Terminology
· Recovery Manager (RMAN)
· Configuring Backup Settings
· Backing Up the Control File to a Trace File
· Managing Backups
· Flash Recovery Area
· Practice Overview: Creating Database Backups
Performing Database Recovery
· Opening a Database
· Changing Instance Status
· Keeping a Database Open
· Loss of a Control File
· Loss of a Redo Log File
· Loss of a Data File in NOARCHIVELOG Mode
· Loss of a Noncritical Data File in ARCHIVELOG Mode
· Loss of a System Critical Data File in ARCHIVELOG Mode
· Practice Overview: Performing Database Recovery
Performing Flashback
· Flashback Technology: Benefits
· When to Use the Flashback Technology
· Flashing Back Any Error
· Flashback Database: Overview
· Flashback Database: Reducing Restore Time
· Flashback Database: Considerations
· Flashback Database: Limitations
· Enabling Flashback Database
· Flashback Table: Overview
· Enabling Row Movement on a Table
· Performing Flashback Table
· Flashback Table: Considerations
· Flashback Drop: Overview
· Flashing Back Dropped Tables Through Enterprise Manager
· Flashback Drop: Considerations
Moving Data
· Moving Data: General Architecture
· Directory Object: Overview
· Creating Directory Objects
· SQL*Loader: Overview
· Loading Data with SQL*Loader
· SQL*Loader Control File
· Loading Methods
· Data Pump: Overview
· Data Pump: Benefits
· Data Pump Export and Import: Overview
· Data Pump Utility: Interfaces and Modes
· Fine Grained Object Selection
· Advanced Feature: Sampling
· Export Options: Files
· Data Pump File Locations
· Scheduling and Running a Job
· Data Pump File Naming and Size
· Data Pump Import
· Data Pump Import: Transformations
· Data Pump: Performance Consideration
· Performance Initialization Parameters
· Data Pump Access Path: Considerations
· Using Enterprise Manager to Monitor Data Pump Jobs
· External Table Population
· Using External Tables
· External Table Population with ORACLE_DATAPUMP
· External Table Population with ORACLE_LOADER
· Data Dictionary
· Practice Overview: Moving Data
Advanced Oracle Enterprise Manager Topics
· Setting up alerts
· Monitoring databases
· Notification of alerts
· Setting up Jobs
Advanced Topics
· Transportable Tablespaces
· External Tables
· Flashback Time Navigation
· Flashback Query: Overview
· Flashback Query: Example
· DataGuard
· ASM (Automatic Storage Management)
Any interested people please feel free to contact me for any more information at:201-377-5953 adityarecruiter21@gmail.com
Thanks & Regards,
Kumar,
201-377-5953
--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=en.
No comments:
Post a Comment