-
Book Overview & Buying
-
Table Of Contents
Oracle Database Administration from Zero to Hero
By :
Oracle Database Administration from Zero to Hero
By:
Overview of this book
In this course, we cover a wide range of topics to ensure you have a solid understanding of Oracle database administration. Starting with an introduction to Oracle databases, you will learn how to create databases on both Linux and Windows platforms. We will guide you through fundamental DBA tasks, including managing database files, storage structures, and users.
As you progress, you will delve into more advanced topics such as managing database multitenancy, implementing backup and recovery plans, and applying patches and upgrades. We will also provide in-depth coverage of Oracle’s Automatic Storage Management (ASM) and Oracle Restart configuration, giving you a comprehensive understanding of these critical components.
Practical exercises form an integral part of the course, allowing you to apply your knowledge in real-world scenarios. You will gain hands-on experience with tasks such as creating a tablespace in ASM, installing Oracle database software, and performing database upgrades. Step-by-step instructions and downloadable resources ensure a seamless learning experience.
By the end of this course, you will have the skills to confidently manage Oracle databases, troubleshoot issues, and optimize performance.
Table of Contents (24 chapters)
Introduction
Preparing Course Practice Environment
Introduction to RDBMS
Database Architecture
Installing and Creating Oracle Databases
Oracle Database Basic Administration
Fundamentals of Oracle Database Multitenancy
Managing Oracle Database Components
Managing Database Segments
Managing Database Users and Security
Managing Database Connectivity
Configuring Shared Server
Managing Fast Recovery Area and Redo Log
Taking Backups in Oracle Databases
Database Recovery
Using RMAN in Multitenant Databases
More about Using RMAN
Flashback Database
Using Oracle Database Utilities
Using the Scheduler
Using ADR Command Interpreter
Applying Patches on Oracle Databases
Automatic Storage Management (ASM)