Oracle dba online training
Download as PPTX, PDF1 like648 views
This document provides an overview of an Oracle DBA online training course. The course aims to guide students to become excellent Oracle database administrators. It covers 25 units on topics related to Oracle database installation, configuration, administration, performance tuning, and disaster recovery. These include installing the Oracle software and Linux operating system, creating and managing database objects, tuning memory and I/O, backup and recovery using RMAN, and implementing a high availability architecture with Data Guard. The course also provides hands-on practice with real-world scenarios.
More Related Content
What's hot (20)
Similar to Oracle dba online training (20)
Recently uploaded (20)
Oracle dba online training
- 2. Introduction to Oracle DBA Oracle database is an object relational database management system RDBMS). Database Administrator play key role in efficiently administrating the databases. The Major responsibilities of DBA is to perform the capacity planning for creating and maintaining all databases, perform ongoing tuning of instances, implement backup, recovery and security for database. It improves understanding of technology stack and credibility. It uses the SQL commands to invoke the capabilities and also retrieve the information. Oracle DBA online training guide students to emerge as the excellent DBA admin in the industry by performing the roles of administrator effectively developing, planning and designing the database strategies.
- 3. Course Curriculum Unit 1: Introduction Topics- Types of Databases, Duties of a DBA, Classifications of DBA, Oracle Versioning and versions history, Grid ? Advantages of Grid Computing, What is Instance? What is Database? What is Database Server?, Users the DBA interacts with Supported OS, Introduction to Linux OS, Linux File Layout structure Unit 2: Installation of Linux OS Topics- OS Users, Installation process, Disk layout, Different mount points used by oracle, Swap Area, Creation of User groups, Oracle needed file layout Unit 3: Installation of Oracle Software Topics- Fulfilling prerequisites for installation, Setting up environment, Installation, Post Installation scripts, Changes done to the OS files after installation is complete, /etc directory, /home/oracle directory, global inventory, oracle home
- 4. Unit 4: Database Creation Topics- Database files introduction, Tablespaces and Schemas, Control files introduction, PFile Introduction, Creation and default parameters(10g/11g), Instance States, Database Creation Manually and Using DBCA, Unit 5: Background processes and Different stages of Database Topics- Instance Start, Mount and Open states, Dynamic views related to database, Oracle memory layout, Background processes, Instance states more detailed, How to look for background processes Unit 6: Database objects and Tablespaces. Topics- Introducing putty and VNC server(How it works in realtime environment), Sys owned objects, Data Dictionary, User Created objects, Sys Tablespaces, User Tablespaces, Dictionary Managed Tablespace, Locally managed tablespace, Bigfile tablespace, Managing tablespaces, Managing datafiles, Datafiles layout, Internal organization, Tables and Fragmentation
- 5. Unit 7: Threads and Redo log groups Topics- Archive log, No Archive log, Threads and Groups concepts, Multiplexing Redo logs, Log switching, Different stages of Log files, Processes related to online Redo logs, Adding Threads, Groups, Dropping Threads, Groups Unit 8: Oracle Memory architecture Different components of memory(10g/11g) Topics- Dedicated Server and Shared Server, SGA and PGA, Differences between them, Different Stages of a query, Parsing: Hard parsing and Soft parsing, Different stages during an update statement, Checkpointing Unit 9: Indexes Topics- Different types of Indexes, B-Trees, Creation, Views related to indexes, Index reorganization, Statistics collection on indexes Unit 10: Networking and Remote ConnectionsTNS Topics- Listeners, Listener.ora file, Tnsnames.ora file Unit 11: Views and Materialized views Topics- Types of views, Creation, Database links, Materialized views, Refreshing materialized views, Processes related to materialized views, Problems with materialized views refresh
- 6. Unit 12: Users, Privileges, Roles and Responsibilities Topics- Security and Passwords(10g/11g), User Creation, Creating Roles, Assigning Privileges, Roles and Responsibilities, Dropping users, Revoking privileges, Password file. Remote sys connect Unit 13: Pfile and spfile Topics- Types of parameters(static and dynamic), Managing spfile, Creating pfile from spfile and vice versa, Changing parameters dynamically Unit 14: Control files Topics- Multiplexing, Details stored in controlfiles, Creating, Backing up and Recreating controlfiles, Scenarios when a controlfile needs to be created, Changing the Instance name and Database name Unit 15: Backups Topics- Types of Failures, Types of backups, Logical Backups using ImpDP, ExpDP(Data Pump), Transportable tablespaces, Physical backups, Cold Backups and Hot Backups, Generation of redo during hot backups. Fuzzy blocks
- 7. Unit 16: Recovery Topics- Complete recovery using cold backups, Complete recovery using hot backups, Partial recovery using cold backups, Partial recovery using hot backups, Different scenarios in performing recoveries, UNNAMED datafiles during recovery Unit 17: Cloning Databases Topics- Cold cloning, Hot cloning Unit 18: RMAN(1) Topics- RMAN tool introduction, Catalog mode No-Catalog mode, Configurations of RMAN, Hot backups using RMAN, Backing up Databases, Archivelogs and Controlfiles, Channels and Multiple copies, Tuning RMAN backups process, Retention policies, Incremental backups, Cumulative backups Unit 19: RMAN(2) Topics- Restoration using RMAN, Recovery using RMAN, Cloning databases using RMAN, Migrating databases using RMAN, Restoration from Incremental Backups and Cumulative Backups
- 8. Unit 20: Automatic Storage Management(ASM) Topics- Striping and Mirroring, RAID concepts, ASM concepts and file systems, Background processes used by ASM, CSS daemon, Creating Disk groups and Redundancy, RMAN backups in ASM, Migrating a NON-ASM database to ASM, Rebalancing, ASMCMD command-line tool, md_backup and md_restore Unit 21: Patching and Upgrades Topics- Patches and Patch sets, Upgrading within releases Unit 22: Database Migrations between releases Topics- Migration from 10g to 11g Unit 23: Data Guard Topics- Standby databases, Physical Standby databases and Logical Standby databases, Different modes of Protection and Availability, Creating Standby databases, Managing Databases in a Data Guard Environment, Switchover and Failover, Data Guard Broker
- 9. Unit 24: Performance Tuning Topics- Categories of tuning, Areas of tuning, SQL Tuning, Memory Tuning, Disk I/O tuning, Tools used for tuning, Waits and Contention, Latches and Spins, Locks and Lock Resolution, AWR reports, ADDM reports, Oracle Database Replay Unit 25: Oracle Enterprise Manager and Grid Control Topics- Maintaining everything for OEM, RMAN from OEM, Data Guard from OEM, AWR Reports and ADDM, Tuning from OEM
- 10. We offers You 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions
- 11. For Oracle Online trainings contact us : info@keylabstraining.com India : +91-95506-45679(INDIA) USA : +1-908-366-7933(USA) www.Keylabstraining.com info@keylabstraining.com