Diploma in Oracle Database Administration Training Module

Diploma in Oracle Database Administration

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.

Duration

180 Hours

Diploma in Oracle Database Administration
    Introduction
    • Introducing the Structured Query Language
    • Retrieving information from Database Tables
    • Using simple functions
    • Using SQL*plus
    • SubQueries & Advanced Queries
    • Creating Tables,Sequences,Indexes&Views
    • PL/SQL Programming
    • Database Objects
    Oracle Database 10g Architecture
    • Understand Oracle Architecture
    • Recognize the Instance Architecture
    • Installating and configuring Oracle Database 10g
    • Creating an Oracle Database
    • Create, Configure, and Delete a Database Using DBCA
    • Use DBCA to manage templates
    Managing Oracle 10g Instance
    • Enterprise Manager
    • Access the Oracle Database using SQL*Plus and iSQL*Plus
    • Database initialization parameters modifications
    • Stages of database startup and shutdown options
    • Viewing the database alert log
    Oracle Database Storage Structures
    • Usage of tablespaces and data files
    • Space management in tablespaces
    • Create tablespaces
    • Manage tablespaces
    • Obtain tablespace
    User Security in Oracle 10g
    • Creating database user accounts
    • Creating and managing roles
    • Grant and revoke privileges
    • Creating and managing profiles
    • Creating and modifying tables
    • Creating Views and sequences
    • Describe constraints and its states
    • Drop and truncate tables
    • Usage of B-Tree and Bitmap indexes
    Implementation of Database Security
    • Implementing principle of least privilege
    • Auditing database activity
    • Fine-Grained Auditing
    Oracle Data Concurrency
    • Data manipulation using SQL
    • Identify and administer PL/SQL objects
    • Define triggers and triggering events
    • Describe levels of locking
    • Lock conflict
    • Monitoring and resolving lock conflicts
    Managing Undo Data
    • Monitoring and administering undo
    • Configuring undo retention
    • Relationship between transactions and undo
    • Managing the undo tablespace
    Oracle Networking
    • Create listeners using Database Control
    • Create Oracle Net service aliases using Database Control
    • Controlling Oracle Net Listeners
    Performing Database Backup
    • Create consistent database backups
    • Back up your database without shutting it down
    • Create incremental backups
    • Automate database backups
    • Backup a control file to trace
    • Monitor flash recovery area
    Performing Database Recovery
    • Database Recovery
    • Control file
    • Redo log file
    • System-critical data file
    • Non system-critical data file
    Oracle Flashback Technologies
    • Flashback database
    • Flashback Table
    • Flashing Back Dropped Tables
    • Performing Flashback Query to view the contents of the database
    • Viewing transaction history
    Moving Data in Oracle
    • Architecture of Data Pump
    • Using Data Pump export and import
    • Load data with SQL Loader
    • Use external tables to move data

You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

Best - SAP training center in London.