IIRF Online > Office Productivity > Oracle > Oracle Database > Oracle DBA 11g/12c - Database Administration for Junior DBA
Oracle DBA 11g/12c - Database Administration for Junior DBA by Udemy
Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.
Course Highlights
- Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
- As a Oracle Database Administrator you would understand the Database Architecture, which will help you to perform your DBA duties with better understanding.
- As a Oracle Database Administrator (Oracle DBA), you would be able to Install the necessary Oracle Software/Database
- As a Oracle Database Administrator (Oracle DBA), you would be able to Administer User accounts in the Database
- As a Oracle Database Administrator (Oracle DBA), you would be able to Manage Tablespace's to provide required space for the data
- As a Oracle Database Administrator (Oracle DBA), you would be able perform Backup and Recovery as needed.
- As a Oracle Database Administrator (Oracle DBA), you would be able to diagnose the problems and if required will be able to work with Oracle Support
- As a Oracle Database Administrator (Oracle DBA), you would be able to configure the Listeners for users to communicate
Skills you will learn!
Curriculum
9 Topics
What is a Database?
Role of a DBA!!!
OLTP vs OLAP Databases
What is Oracle 11g?
What is Oracle 12c?
Database abc's
Undo vs Redo Data
Oracle Instance vs Database
Quiz Time!!!
9 Topics
Process Architecture
Database Writer Process
Log writer Process
Checkpoint Process
SMON Process
PMON Process
RECO Process
Archiver Process
Quiz Time!!!
13 Topics
Memory Architecture
Database Buffer Cache
Shared Pool
REDO log buffer
Large Pool
Java Pool and Streams Pool
Keep Buffer Pool
Recycle Buffer Pool
nK Buffer Cache
Program Global Area (PGA)
Dedicated vs Shared Databases
PGA in a Shared Envrionment
Quiz Time!!!
2 Topics
Architecture Full Picture!!!!
Architecture Quiz!!!
11 Topics
Software Download...
Virtual Machine Installation
Linux Installation
Oracle Software Installation
Oracle Parameter Files
Database creation - Manual Method Demo
Verify Database creation
Database creation using DBCA (Preferred option)
Oracle Startup Steps...
Oracle Shutdown methods
Oracle 12c Upgrade
11 Topics
How data is stored in a Database?
Tablespace Concepts
Online and Offline Tablespaces
Let's create a Tablespace...
Let's add more space to the Database...
Tablespace Demo 1
Tablespace Demo 2
Tablespaces with different block sizes
Temporary Tablespace Management
Temporary Tablespace Groups
Extent Management (Local vs Dictionary managed)
7 Topics
UNDO Concepts
Read Consistency
ORA-01555 snapshot too old error
Automatic Undo Management
UNDO Management
Configuring Undo Retention Period
Retention Guarantee!!
5 Topics
REDO Concepts
REDO Logfile Management Demo1
REDO Logfile Management Demo2
Archival Concepts
Archival Log Mode Demo
16 Topics
User Management Concepts
User Management Demo 1
User Management Demo 2
User Creation Exercise
Privileges
System Privileges Demo
Object Privileges Demo
Revoking User Privileges
Revoking System Privileges
Revoking Object Privileges
Let's practice what we learnt so far...
Role Management Concepts
Role Management Demo
User Profiles
User Profile Demo
Managing Passwords using Profiles
6 Topics
Networking Concepts
Listener Configuration Demo
TNSNAMES Configuration Demo
Database Link Concepts
Public Database Link
Private Database Link
5 Topics
What is Data Dictionary?
Static Data Dictionary Views
Dynamic Data Dictionary Views
Miscellaneous Data Dictionary Views
Data Dictionary Demo
6 Topics
What is Diagnostic Data?
Automatic Diagnostic Repository (ADR)
Manually navigating through the Diagnostic Data
Automatic Diagnostic Repository Command Interpreter (ADRCI)
Using ADRCI to navigate through Diagnostic Data
Creating an Incident Package for Oracle Support
9 Topics
Backup and Recovery Concepts 1
Backup and Recovery Concepts 2
Backup Types
Performing a Cold Backup manually
Hot Backup Steps
Hot Backup Demo
Recover a Control file from media failure
Recover a System Data file from media failure
Recover a non-system data file from media failure
6 Topics
RMAN Backup Types
Incremental Backup
Recovery Manager (RMAN) Terminology
Image Copies VS Backup sets
Why RMAN?
RMAN Commands
8 Topics
Materialized Views Introduction
Materialized Views creation Options
Materialized Views with ON COMMIT option
Materialized Views with ON DEMAND option
Materialized Views with REFRESH FAST option
Timing the refresh
Query Rewrite functionality
Materialized Views Recap
8 Topics
Table Partitioning Introduction
Range Partition based on range of values
List Partition based on list of values
Hash Partition based on the hash key
Composite Partitioning by mixing things up!!
Interval Partition for automatic partition creation
Adding/Droping Partitions
Table Partitioning Recap
2 Topics
Project Work!!!
Where to go from here?
Oracle DBA 11g/12c - Database Administration for Junior DBA
Related Oracle Database Courses
Thank You!
Your review has been submitted successfully.