In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.
Step by Step methodology followed is…
- Learn the fundamentals of database to set the stage for Oracle Architecture
- Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
- Install Oracle Database 11g & 12c (Manual method and using DBCA)
- Tablespace management to manage space to store the data.
- UNDO Tablespace management to manage undo space.
- REDO Log file management to manage redo space.
- Manage users and security
- Networking (Configuring Listeners and TNS entries)
- Understand various Data dictionary tables/views
- Diagnose issues using Diagnose data and generate packages for Oracle Support.
- Backup and Recovery (User Managed)
- Backup and Recovery (RMAN)
- Materialized Views
- Table Partitioning
- Project Work
Let’s start and I will take you step by step to lead your journey into the DBA world!!!
MODULE-1
MODULE-2
-
6Lesson 01 - Oracle Database Software Installation
-
7Lesson 02 - Oracle Database Creation
-
8Lesson 03 - Instance and Database Information Exploring part1
-
9Lesson 04 - Instance and Database Information Exploring part2
-
10Lesson 05 - Instance and Database Information Exploring part3
-
11Lesson 06 - Instance and Database Information Exploring part4
MODULE-3
-
12Lesson 01 - Oracle initialization Parameters
-
13Lesson 02 - Oracle Memory Structure
-
14Lesson 03 - Oracle Processes
-
15Lesson 04 - Oracle Data Files
-
16Lesson 05 - Control Files
-
17Lesson 06 - Online Redo Log Files
-
18Lesson 07 - Oracle Data Block
-
19Lesson 08 - Oracle Extents
-
20Lesson 09 - Oracle Segments
-
21Lesson 10 - Oracle Tablespaces
-
22Lesson 11 - Oracle Net Architecture
MODULE-4
MODULE-5
MODULE-6
MODULE-7
-
36Lesson 01 - Oracle Tables
-
37Lesson 02 - Creating and Managing Tables
-
38Lesson 03 - Managing Table Constraints
-
39Lesson 04 - Managing Tables lab1
-
40Lesson 05 - Oracle Index Overview
-
41Lesson 06 - Handling Oracle Index
-
42Lesson 07 - Handling Oracle Index part2
-
43Lesson 08 - Index Considerations
MODULE-8
MODULE-9
Be the first to add a review.
Please, login to leave a review