Oracle DBA

1
(No Transcript)
2
(No Transcript)
3
Course Curriculum

• Session 1 2 HoursIntroduction to DBA   
  Learning objectives In this module, you will
  learn database systems and introduction to
  Structured Query Language(sql).               
              Topics Relational Database Systems,
  Integrity Constraints, Structured Query
  Language(sql),Tasks of an Oracle Database
  Administrator    Session 2 5 Hours       
  Installation of Oracle Database Software       
           Includes linux installation   
  Learning objectives In this module, you will
  learn Optimal Flexible Architecture (OFA),Oracle
  Universal Installer and Configuration
  AssistantsTopics Optimal Flexible Architecture
  (OFA), Oracle Universal Installer, Prerequisite
  Checks, Installation, Configuration Assistants   
         

4
Session 3 4 HoursCreating an Oracle
DatabaseLearning objectives In this module, you
will learn Database Architecture, overview of
Database Configuration Assistant (DBCA) and you
will also learn how to create data base,
Initialization Parameters and Other Actions with
DBCA.                            Topics
Database Architecture, Exploring the Storage
Structure, Control Files, Redo Log
Files,Tablespaces and Datafiles, Segments,
Extents, and Blocks, Oracle Instance Management,
Oracle Memory Structures, Oracle Processes, Data
Dictionary, Database Control, Grid Control,
Database Configuration Assistant (DBCA) Overview,
Creating a Database, Passwords and Storage, File
Locations and Backup Recovery, Content and
Initialization Parameters, Other Actions with
DBCA .           Session 4 2 HoursManaging
the DatabaseLearning objectives In this module,
you will learn Starting and Stopping iSQLPlus,
Starting and Stopping Database Control , how to
access database control and you will also learn
NOMOUNT MOUNT OPEN States, and SHUTDOWN
Options.                Topics Starting and
Stopping iSQLPlus, Starting and Stopping
Database Control, Accessing Database Control,
SYSOPER and SYSDBA, Database Home Page, Changing
the Listener Status, NOMOUNT MOUNT OPEN States,
SHUTDOWN Options, Initialization Parameter Files,
Viewing the Alert Log. 
5
Session 5 2 HoursNet Services               
                        Learning objectives In
this module ,you will  learn oracle net services,
Oracle Net Listener, Monitoring the Listener,
Listening Addresses, Static Database
Registration, Listener Control Utility and you
will also learn how to configure Service Aliases
with Net Manager.Topics Oracle Net Services,
Oracle Net Listener, Monitoring the Listener,
Listening Addresses, Static Database
Registration, Listener Control Utility, Oracle
Net Connections, Directory Naming, Advanced
Connections, Oracle Net Manager, Configuring
Service Aliases with Net Manager.           
Session 6 3 HoursManaging Schema
ObjectsLearning objectives In this module, you
will learn Schemas, Accessing Schema Objects,
Schema Object Namespaces and how to specify data
types in tables. you will also learn how to
create indexes and views by using a sequence.   
                    Topics Schemas, Accessing
Schema Objects, Schema Object Namespaces,
Specifying Data Types in Tables, Other Data
Types, Creating and Modifying Tables,
Understanding Data Integrity, Defining
Constraints, Viewing the Attributes of a Table,
Viewing the Contents of a Table, Creating
Indexes, Creating Views, Using a Sequence.
6
Session 7 3 HoursStorage StructuresLearning
objectives In this module ,you will learn
Tablespaces and Data Files, Space Management in
Tablespaces, Altering a Tablespace Dropping
Tablespaces and Viewing Tablespace Information   
        Topics Tablespaces and Data Files,
Space Management in Tablespaces, Storage for
Locally Managed Tablespaces, Altering a
Tablespace, Actions with Tablespaces, Dropping
Tablespaces, Viewing Tablespace Information.   
        Session 8 3 HoursAdministering
UsersLearning objectives In this module ,you
will learn Database User Accounts, Creating a
User, Profiles and  Users, Assigning Quota to
Users and Assigning Roles to UsersTopics
Database User Accounts, Creating a User, Profiles
and Users, Authenticating Users, Database Users
and Schemas, Privileges System and Object,
Roles, Assigning Quota to Users, Assigning Roles
to Users.
7
Session 9 3 HoursManaging Data   Learning
objectives In this module,you will learn how to
manipulate data through SQL, INSERT Command, The
UPDATE Command, The DELETE Command, The COMMIT
and ROLLBACK Command and you will also learn Undo
Management, Undo Data, Transactions and Undo
Data.                            Topics
Objectives, Manipulating Data Through SQL, The
INSERT Command, The UPDATE Command, The DELETE
Command, The COMMIT and ROLLBACK Commands,
Integrity Constraints and DML, Data Pump Export,
Data Pump Import, SQLLoader, The SQLLoader
Control File, Control File Syntax Considerations,
Input Data and Data Files, Loading Methods,
Comparing Direct and Conventional Path Loads,
Loading Data with SQLLoader, External Tables,
Transportable tablespace, Undo Management, Undo
Data, Transactions and Undo Data, Storing Undo
Information, Monitoring Undo, Administering
Undo    , Configuring Undo Retention,
Guaranteeing Undo Retention, Sizing the Undo
Tablespace 
8
Session 10 3 HoursBackup and Recovery
Concepts    Learning objectives In this
module,you will learn Backup and Recovery
Issues    , Categories of Failures, Instance
Recovery, Phases of Instance Recovery, Tuning
Instance Recovery, Using the MTTR Advisor and you
will  also learn Oracle Recovery Manager, Oracle
Recovery Catalog maintenance, Backups using
Oracle Recovery Manager and Recovery using Oracle
recovery manager.                       
Topics Backup and Recovery Issues    ,
Categories of Failures, Instance Recovery, Phases
of Instance Recovery, Tuning Instance Recovery,
Using the MTTR Advisor, Configuring for
Recoverability, ARCHIVELOG Mode, Configuring
Backup Strategy, Scheduling Backups Review    ,
Backup Control File to Trace, Manage Backups,
Database Recovery, Opening a Database, Changing
Instance Status, Keeping a Database Open,
Scenarios, Loss of a Control File, Loss of a
Redo Log File, Loss of a Data File in
NOARCHIVELOG Mode, Loss of a Noncritical Data
File in ARCHIVELOG Mode, Loss of a
System-Critical Data File in ARCHIVELOG Mode,
Oracle Recovery Manager, Oracle Recovery Catalog
maintenance, Backups using Oracle Recovery
Manager, Recovery using Oracle recovery manager,
Database Cloning using RMAN, Tablespace Point in
time recovery, Incomplete recovery.
9
Session 11 1 HoursMonitoring and Resolving
Lock Conflicts                        Learning
objectives In this module, you will learn Locks,
Locking Mechanism, DML Locks, Deadlocks, Database
and Instance Metrics, Data Dictionary Metrics
and  Optimizer StatisticsTopics Locks, Locking
Mechanism, Data Concurrency, DML Locks, Enqueue
Mechanism, Lock Conflicts, Possible Causes of
Lock Conflicts, Detecting Lock Conflicts,
Resolving Lock Conflicts, Deadlocks, Performance
Monitoring, Performance Monitoring, Monitoring
Methodologies, Database and Instance Metrics,
Data Dictionary Metrics, Optimizer Statistics,
Schedule Optimizer Statistics Collection, Dynamic
Performance Views, Viewing Metric Information,
Reacting to Performance Issues, Reacting to
Performance Issues            Session 12 2
HoursProactive Maintenance    Learning
objectives In this module, you will learn Server
Generated Alerts, Thresholds,  Memory Advisors,
Segment Advisor Automatic Workload Repository
(AWR), Managing the AWR and  Automatic Database
Diagnostic Monitor (ADDM).    Topics Server
Generated Alerts, Thresholds, Setting Thresholds,
Baseline Measurements, Tuning and Diagnostic
Advisors, SQL Tuning and Access Advisors, Memory
Advisors, Segment Advisor Automatic Workload
Repository (AWR), Managing the AWR, Automatic
Database Diagnostic Monitor (ADDM).
10
Register Now