Oracle Admin

Module 1: Exploring the Oracle Database Architecture

• Oracle Database Architecture Overview
• Interacting with an Oracle Database
• Process Architecture
• Database Storage Architecture
• Logical and Physical Database Structures
• Tablespaces and Data Files
• SYSTEM and SYSAUX Tablespaces
• Segments, Extents, and Blocks

Module 2: Preparing the Database Environment

• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Optimal Flexible Architecture (OFA)
• Setting Environment Variables
• Oracle Universal Installer (OUI)
• Database Configuration Options
• Advanced Installation Options

Module 3: Creating an Oracle Database

Module 4: Managing the Oracle Instance

• Management Framework
• Oracle Enterprise Manager
• Initialization Parameter
• Database Startup and Shutdown
• Shutdown Modes
• Viewing the Alert History
• Using Trace Files
• Data Dictionary: Overview

Module 5: Configuring the Oracle Network Environment

• Oracle Net Services & Listener
• Establishing Net Connections
• Tools for Configuring and Managing the Oracle Network
• Net Services Administration Pages
• Naming Methods
• Directory Naming
• SGA and PGA
• When Not to Use a Shared Server

Module 6: Managing Database Storage Structures

• Storage Structures
• How Table Data Is Stored
• Anatomy of a Database Block
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Actions with Tablespaces
• Oracle Managed Files (OMF)
• ASM: Concepts

Module 7: Administering User Security

• Database User Accounts
• Predefined Accounts: SYS and SYSTEM
• Administrator Authentication
• Benefits of Roles
• Predefined Roles
• Implementing Password Security Features
• Assigning Quota to Users

Module 8: Managing Schema Objects

• What Is a Schema?
• Accessing Schema Objects
• Specifying Data Types in Tables
• Creating and Modifying Tables
• Understanding Data Integrity
• Indexes & Views
• Sequences
• Temporary Tables

Module 9: Managing Data and Concurrency

• Manipulating Data Through SQL
• PL/SQL
• Administering PL/SQL Objects
• Functions, Procedures, Packages & Triggers
• Data Concurrency
• Enqueue Mechanism
• Resolving Lock Conflicts Using SQL
• Deadlocks

Module 10: Managing Undo Data

• Data Manipulation
• Transactions and Undo Data
• Undo Data Versus Redo Data
• Configuring Undo Retention
• Guaranteeing Undo Retention
• Using the Undo Advisor
• Viewing System Activity

Module 11: Implementing Oracle Database Security

• Industry Security Requirements
• Principle of Least Privilege
• Monitoring for Compliance
• Value-Based Auditing
• Fine-Grained Auditing
• DBA Auditing
• Security Updates
• Applying Security Patches

Module 12: Database Maintenance

• Introducing Terminology
• Optimizer Statistics
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)
• Advisory Framework
• Automated Maintenance Tasks
• Server-Generated Alerts
• Reacting to Alerts

Module 13: Performance Management

• Performance Monitoring
• Managing Memory Components
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Dynamic Performance Statistics
• Troubleshooting and Tuning Views
• Invalid and Unusable Objects

Module 14: Backup and Recovery Concepts

• Statement Failure
• User Error
• Understanding Instance Recovery
• Phases of Instance Recovery
• Using the MTTR Advisor
• Media Failure
• Archive Log Files

Module 15: Performing Database Backups

• Backup Solutions: Overview
• Oracle Secure Backup
• User-Managed Backup
• Terminology
• Recovery Manager (RMAN)
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• Monitoring the Flash Recovery Area

Module 16: Performing Database Recovery

• Opening a Database
• Data Recovery Advisor
• Loss of a Control File
• Loss of a Redo Log File
• Data Recovery Advisor
• Data Failures
• Listing Data Failures
• Data Recovery Advisor Views

Module 17: Moving Data

• Moving Data: General Architecture
• Directory Object: Overview
• SQL*Loader: Overview
• Data Pump: Overview
• Performance Initialization Parameters
• Using Enterprise Manager to Monitor Data Pump Jobs
• Data Dictionary

Module 18: Enhancing Database Capabilities

• Using EM Support Workbench
• Create a Service Request
• Package and upload diagnostic data to Oracle Support
• Track the SR and Implement Repairs
• Incident Packaging Configuration
• Working with Oracle Support
• MetaLink Integration
• Managing Patches

Meet Ananth Tirumanur. Hi there 👋

I work on projects in data science, big data, data engineering, data modeling, software engineering, and system design.

• 👨‍💻 All of my projects are available at https://github.com/akrish1982
• 💬 Ask me about Data engineering, SQL, Databases, Data pipelines, Data infrastructure
• 📄 My work history: https://www.linkedin.com/in/ananthtirumanur/
• ⚡ Fun fact: Marathoner & Casual Birding enthusiast

Connect with me:

• Twitter: @akrish82
• LinkedIn: https://linkedin.com/in/ananthtirumanur/

My Resources:

• LinkedIn Newsletter: Data Engineering with AWS
• Udemy Course: AWS Certified Data Engineer Associate Practice Test
• Python Crash Course: Python Crash Course on Gumroad

Languages and Tools:

AWS, Bash, Docker, Elasticsearch, Git, Grafana, Hadoop, Hive, EMR, Glue, Athena, Lambda, Step Functions, Airflow/MWAA, DynamoDB, Kafka, Kubernetes, Linux, MariaDB, MySQL, Pandas, PostgreSQL, Python, Redis, Scala, SQLite