Learn Oracle Database Administration From Scratch

Master Oracle Database Administration: From Installation to Advanced Backup and Recovery Techniques

What you'll learn

Database basics: data and database definitions, functions

Oracle 11g architecture and components

Installation and configuration of Oracle 11g

Basic database administration tasks

User and tablespace management

Oracle networking and utilities

Backup and recovery techniques

Requirements

Basic Linux and Oracle SQL Knowledge

Description

Unlock the power of Oracle databases with our comprehensive course! Designed for beginners and aspiring database administrators, this course will guide you through the essential concepts and advanced techniques needed to manage Oracle databases effectively.The course is designed to provide a strong foundation while also preparing you for real-world challenges. With a blend of theoretical knowledge and practical application, you'll be well-equipped to handle the responsibilities of a database administrator and advance your career in the IT industry.Practical exercises and real-world scenarios to reinforce your understandingDetailed exploration of Oracle 11g architecture and its componentsIn-depth coverage of essential database administration tasks and advanced techniquesUtilize Oracle utilities like SQL * Loader and Data Pump for data import and exportLearn from industry experts with extensive experience in Oracle database administrationBy the end of this course, you will not only understand the technical aspects of Oracle Database Administration but also develop a strategic mindset to manage and optimize databases for maximum performance and reliability. Whether you're looking to kickstart your career or enhance your existing skills, this course is the perfect gateway to becoming a proficient Oracle Database Administrator.Join us and embark on a journey to become a proficient Oracle Database Administrator. With our course, you'll gain the knowledge and skills needed to manage Oracle databases efficiently and effectively. Enroll now and take the first step towards mastering Oracle Database Administration!

Overview

Section 1: Introduction to Database

Lecture 1 What is Data?

Lecture 2 What is a Database?

Lecture 3 How a Database Function

Section 2: Oracle 11g Architecture

Lecture 4 User Connectivity in Oracle

Lecture 5 Phases of SQL Execution

Lecture 6 Select Statement Processing

Lecture 7 DML / DDL Statement Processing

Lecture 8 Oracle Architecture Components

Lecture 9 Oracle Background Processes

Lecture 10 Oracle Files

Section 3: Oracle 11g Software Installation

Lecture 11 Download Oracle 11g

Lecture 12 Installation Prerequisites

Lecture 13 Pre Install Tasks

Lecture 14 Install Oracle 11g

Lecture 15 Post Install Tasks

Section 4: Oracle 11g Database Creation

Lecture 16 Set Environment Variables

Lecture 17 DBCA Create Database

Lecture 18 Connect Database

Lecture 19 Manual DB Creation

Lecture 20 DBCA Delete Database

Section 5: Navigating Oracle Database

Lecture 21 Database Metadata

Lecture 22 Basic Views You Must Know

Lecture 23 Key Database Files

Lecture 24 Database Storage Structures

Lecture 25 Datafiles Metadata

Lecture 26 Tablespace Metadata

Section 6: Basic Database Administration

Lecture 27 Database Operating Modes

Lecture 28 DB Startup & Shutdown

Lecture 29 Multiplexing of Database Files

Lecture 30 Multiplexing Control Files

Lecture 31 Multiplexing Redolog Files

Lecture 32 Database Archivelog Mode

Section 7: Tablespace Administration

Lecture 33 Tablespace Utilization

Lecture 34 Create New Tablespace

Lecture 35 Capacity Planning

Section 8: User Administration

Lecture 36 Users in Oracle

Lecture 37 User Management

Lecture 38 User Role Management

Lecture 39 User Permission Management

Lecture 40 Profile Management

Lecture 41 Create User Profile

Section 9: Oracle Networking

Lecture 42 Install Oracle 11g Client

Lecture 43 Configuring Listener

Lecture 44 Configuring TNS Entries

Lecture 45 Oracle DB Links

Section 10: Oracle Utilities

Lecture 46 SQL * Loader

Lecture 47 Import csv into Table

Lecture 48 Oracle Export Import

Lecture 49 Performing Export

Lecture 50 Performing Import

Lecture 51 Oracle Data Pump

Lecture 52 Data Pump Directory

Lecture 53 Data Pump Export

Lecture 54 Data Pump Import

Section 11: Database Backup & Recovery

Lecture 55 Why Backup & Recovery?

Lecture 56 Backup & Recovery Solutions

Section 12: Oracle User Managed Backups

Lecture 57 Cold DB Backup and Recovery

Lecture 58 Hot Database Backups

Lecture 59 Find DB Files Location

Lecture 60 Taking Hot DB Backup

Lecture 61 Hot Backup Queries

Lecture 62 RESTORE vs RECOVER

Section 13: Oracle User Managed Recovery

Lecture 63 Parameter File Recovery

Lecture 64 Control File Recovery

Lecture 65 Entire Database Recovery

Section 14: Introduction to RMAN

Lecture 66 What is RMAN - Recovery manager

Lecture 67 How to Connect RMAN Utility

Fresher DBAs who are curious about Oracle Database Administration