Mindmajix
Oracle DBA Online Training
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.
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
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
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
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
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
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
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
Our Oracle DBA Online Training batches starts every day. You can attend a DEMO for free
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
Thank you Your feedback is highly important to improve our course material.
For Free Demo Please Contact INDIA: +91-9246333245, US: +1-2013780518, Email id: info@mindmajix.com http://mindmajix.com/