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 |
3 STUDENTS ENROLLED