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