Contact for queries :
banner1

What you’ll learn

  • Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
  • As a Oracle Database Administrator (Oracle DBA), you would be able 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

Course Curriculum

01 Introduction
001 What is a Database 00:00:00
002 Role of a DBA 00:00:00
003 OLTP vs OLAP Databases 00:00:00
004 What is Oracle 11g 00:00:00
005 What is Oracle 12c 00:00:00
006 Database abcs 00:00:00
007 Undo vs Redo Data 00:00:00
008 Oracle Instance vs Database 00:00:00
02 Oracle Process Architecture
009 Process Architecture 00:00:00
010 Database Writer Process 00:00:00
011 Log writer Process 00:00:00
012 Checkpoint Process 00:00:00
013 SMON Process 00:00:00
014 PMON Process 00:00:00
015 RECO Process 00:00:00
016 Archiver Process 00:00:00
03 Oracle Memory Architecture
017 Memory Architecture 00:00:00
018 Database Buffer Cache 00:00:00
019 Shared Pool 00:00:00
020 REDO log buffer 00:00:00
021 Large Pool 00:00:00
022 Java Pool and Streams Pool 00:00:00
023 Keep Buffer Pool 00:00:00
024 Recycle Buffer Pool 00:00:00
025 nK Buffer Cache 00:00:00
026 Program Global Area (PGA) 00:00:00
027 Dedicated vs Shared Databases 00:00:00
028 PGA in a Shared Envrionment 00:00:00
04 Architecture Recap
029 Architecture Full Picture 00:00:00
05 Software Installation
031 Virtual Machine Installation 00:00:00
032 Linux Installation 00:00:00
033 Oracle Software Installation 00:00:00
034 Oracle Parameter Files 00:00:00
035 Database creation – Manual Method Demo 00:00:00
036 Verify Database creation 00:00:00
037 Database creation using DBCA (Preferred option) 00:00:00
038 Oracle Startup Steps… 00:00:00
039 Oracle Shutdown methods 00:00:00
040 Oracle 12c Upgrade 00:00:00
06 Tablespace Management
041 How data is stored in a Database 00:00:00
042 Tablespace Concepts 00:00:00
043 Online and Offline Tablespaces 00:00:00
044 Lets create a Tablespace… 00:00:00
045 Lets add more space to the Database… 00:00:00
046 Tablespace Demo 1 00:00:00
047 Tablespace Demo 2 00:00:00
048 Tablespaces with different block sizes 00:00:00
049 Temporary Tablespace Management 00:00:00
050 Temporary Tablespace Groups 00:00:00
051 Extent Management (Local vs Dictionary managed) 00:00:00
07 UNDO Management
052 UNDO Concepts 00:00:00
053 Read Consistency 00:00:00
054 ORA-01555 snapshot too old error 00:00:00
055 Automatic Undo Management 00:00:00
056 UNDO Management 00:00:00
057 Configuring Undo Retention Period 00:00:00
058 Retention Guarantee 00:00:00
08 REDO Management
059 REDO Concepts 00:00:00
060 REDO Logfile Management Demo1 00:00:00
061 REDO Logfile Management Demo2 00:00:00
062 Archival Concepts 00:00:00
063 Archival Log Mode Demo 00:00:00
09 User Management
064 User Management Concepts 00:00:00
065 User Management Demo 1 00:00:00
066 User Management Demo 2 00:00:00
067 user-management-3 00:00:00
068 Privileges 00:00:00
069 System Privileges Demo 00:00:00
070 Object Privileges Demo 00:00:00
071 Revoking User Privileges 00:00:00
072 Revoking System Privileges 00:00:00
073 Revoking Object Privileges 00:00:00
074 Lets practice what we learnt so far… 00:00:00
074 Oracle-System-Privileges 00:00:00
075 Role Management Concepts 00:00:00
076 Role Management Demo 00:00:00
077 User Profiles 00:00:00
078 User Profile Demo 00:00:00
079 Managing Passwords using Profiles 00:00:00
10 Oracle Networking
080 Networking Concepts 00:00:00
081 Listener Configuration Demo 00:00:00
082 TNSNAMES Configuration Demo 00:00:00
083 Database Link Concepts 00:00:00
084 Public Database Link 00:00:00
085 Private Database Link 00:00:00
11 Data Dictionary
086 What is Data Dictionary 00:00:00
087 Static Data Dictionary Views 00:00:00
088 Dynamic Data Dictionary Views 00:00:00
089 Miscellaneous Data Dictionary Views 00:00:00
090 Data Dictionary Demo 00:00:00
12 Diagnostic Data
091 What is Diagnostic Data 00:00:00
092 Automatic Diagnostic Repository (ADR) 00:00:00
093 Manually navigating through the Diagnostic Data 00:00:00
094 Automatic Diagnostic Repository Command Interpreter (ADRCI) 00:00:00
095 Using ADRCI to navigate through Diagnostic Data 00:00:00
096 Creating an Incident Package for Oracle Support 00:00:00
13 Backup and Recovery (User Managed)
097 Backup and Recovery Concepts 1 00:00:00
098 Backup and Recovery Concepts 2 00:00:00
099 Backup Types 00:00:00
100 Performing a Cold Backup manually 00:00:00
101 Hot Backup Steps 00:00:00
102 Hot Backup Demo 00:00:00
103 Recover a Control file from media failure 00:00:00
104 Recover a System Data file from media failure 00:00:00
14 Backup and Recovery (RMAN Backup)
105 Recover a non-system data file from media failure 00:00:00
106 RMAN Backup Types 00:00:00
107 Incremental Backup 00:00:00
108 Recovery Manager (RMAN) Terminology 00:00:00
109 Image Copies VS Backup sets 00:00:00
110 Why RMAN 00:00:00
15 Database Objects - Materialized Views
111 RMAN Commands 00:00:00
112 Materialized Views Introduction 00:00:00
113 Materialized Views creation Options 00:00:00
114 Materialized Views with ON COMMIT option 00:00:00
115 Materialized Views with ON DEMAND option 00:00:00
116 Materialized Views with REFRESH FAST option 00:00:00
117 Timing the refresh 00:00:00
118 Query Rewrite functionality 00:00:00
119 Materialized-Views 00:00:00
16 Table Partitioning
120 Table Partitioning Introduction 00:00:00
121 Range Partition based on range of values 00:00:00
122 List Partition based on list of values 00:00:00
123 Hash Partition based on the hash key 00:00:00
124 Composite Partitioning by mixing things up 00:00:00
125 Interval Partition for automatic partition creation 00:00:00
126 Partition-Addition-and-Drop 00:00:00
127 Table-Partitioning 00:00:00
17 Project Work
128 DBA-Project-work 00:00:00
129 Where-to-from-here 00:00:00
TAKE THIS COURSE
  • FREE
  • 10 Days
3 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.