ORACLE ADMINISTRATION

Enquire, Join and get training by Well Experienced & Certified tutors
for your professional IT Course.

Watch Sample Session!

Get in Touch

+1 202-403-9022

+91 951 583 9400

info@suvenit.com

MODULE#1- Introduction to database management systems
• What is a database?
• Popular database management system (DBMS) software and why Oracle DBMS
• History and Current trends of DBMS and Database Administration
• Tasks of a Database AdministratorMODULE#2- Relational Database Model and Installing Oracle database software
• Identifying certified operating system,
• Understanding My Oracle Support for certifications,
• CSI numbers,
• Understanding operating system installation procedures for oracle database,
• Configuring operating system (kernel parameters),
• creating users, creating groups,
• Installing OEL 5.4 and Oracle database Software 11gR2.
• Understanding init.ora (initialization files) files,
• important parameters in parameter file,
• purpose of Alert log files,
• location of Alert log files,
• Maintaining Alert log files,
• diagnostic destination location,

MODULE#3- Database Objects
• Introduction various database objects
• Tables, Indexes, Views and Synonyms
• Packages, Stored procedures and Functions
• Oracle Data Dictionary and some popular Data Dictionary views

MODULE#4- Database Storage
• Tablespaces and allocation types
• Create tablespaces
• Create datafiles with fixed size and autoextend option
• Control files, Redolog groups and members
• NoArchivelog mode and Archivelog mode for a database
• Initialization file management
• Creating the init.ora file
• Using spfile
• Displaying init.ora values with v$parameter

MODULE#5 –Oracle Networking
• Introduction
• Oracle listener configuration
• Oracle database connections from other computers
• Oracle listener administration and TNS environment variables
• Database Links

MODULE#6 –Building an Oracle 11g Database Creating the database
• Simplifying memory allocation with memory targets
• Establishing network connectivity
• Converting from text-based to server parameter files
• Configuring control files and redo log files

MODULE#7 –Starting and stopping the database
• Mounting and opening the database with SQL*Plus
• Authenticating connections having SYSDBA privilege
• Closing the database and shutting down the instance

MODULE#8 –User Management, Roles and Privileges
• Create databases users
• User roles and privileges
• Identifying system and object privileges
• Granting and revoking privileges
• Creating and modifying roles
• Displaying user security Information from the data dictionary

MODULE#9 –Oracle Secure Backup
• Installation and Configuration
• Implement the Oracle suggested strategy
• RMAN and Oracle Secure Backup
• Database and File-system files backup/restore to tape
• Using obtool and web interface to configure Oracle Secure Backup devices (CLI/GUI)
• Configuring EM for Oracle Secure Backup and test backup to tape (EM)
• Using RMAN to backup your database to tape
• Using the OB Web tool to backup file system files

MODULE#10 – Used Managed (Manual) Backup and Recovery
• Introduction
• Cold Backup & Hot Backup
• How to recover a database using Cold Backup
• How to recover a database using Hot BackupMODULE#11 –RMAN Backup and Recovery
• Differences between RMAN method and manual method
• Database backup using RMAN
• RMAN catalog
• Database backup using RMAN catalog
• Querying the RMAN metadata
• Introduction and overview to Backups to Tape

MODULE#12 –Data Movement
• External Tables Concepts
• Creating a Directory object and External Table
• Data Pump
• Transport Database
• RMAN CONVERT DATABASE Command
• Transport Tablespaces
• Create a Directory Object
• Create a Temporary Table

MODULE#13 –Performance Tuning
• Introduction
• How to handle performance issues in the real world
• V$ views for performance monitoring and analysis
• How to size the Oracle database and memory for optimal performance
• Explain Oracle UNDO management internals and sizing.
• Explain Oracle TEMP space internals and sizing.
• SQL Query tracing using TKPROF
• Database wide tracing for Oracle Errors (Event Tracing)
• Gather optimizer statistics using DBMS_STATS

MODULE#14 –Managing Resources
• Understanding various database resources
• Database Resource Manager Concepts and Configuration
• Creating a New Resource Plan
• Active Session Pool Mechanism
• Maximum Estimated Execution Time
• Creating a Complex Plan
• Administering and Monitoring Resource Manager
• Resource Plan Directives
• Creating Resource Consumer Groups

MODULE#15 –Oracles ASM (Automatic Storage Management)
• Introduction and benefits of ASM
• ASM Setup and Configuration
• ASM Parameter file, ASM Instance and working with DISKGROUPS
• Querying ASM Information
• Creating Database Files using ASM

MODULE#16 –Automating Tasks with the Scheduler
• Scheduler Concepts
• Creating a Job Class and a Window
• Managing Jobs, Programs, Chains, Events, Schedules, priority
• Viewing and Purging Job Logs
• Creating a program and a schedule
• Creating a job that uses a program and a schedule
• Altering the program and schedule for the job and observing the behavior change of the job
• Monitoring job runs

MODULE#17 – Oracle DBA Utilities
• Data pump (Imp and exp utilities)
• SQL*Loader
• LogMiner
• Flashback
• DataGuard
• Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
• Replication (Streams, multimaster, materialized views)

MODULE#18 – Using Globalization Support
• Globalization Support Features
• Encoding Schemes
• Database Character Sets and National Character Sets
• Specifying Language-Dependent Behavior
• Locale Variants
• Using Linguistic Comparison and Sorting
• Data Conversion Between Client and Server
• Determining the Default NLS Settings

Quick Contact
close slider