Course Duration
40 HOURS
About 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.
Course Contents
Oracle Database AdministrationIntroduction
- 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
Register Now
You will Learn How To :
On completion of this course You will know
Deal with the DBMS and RDBMS related SQL Queries.
Access the Oracle Database using SQL*Plus and iSQL*Plus
User Security in Oracle 10g
Implementation of Database Security
Monitoring and resolving lock conflicts
Create Oracle Net service aliases using Database Control
Performing Database Backup
Performing Database Recovery
Moving Data in Oracle
Course Benefits :
On completion of Diploma in Oracle Database Administration it will lead to the job role as follows:
Database AdministratorSupport AnalystDatabase Developer
Senior Database AdministratorSenior Database Developer
Register Now