Oracle Database Administration I (1Z0-082) Certification Training
About Course
The Oracle Database Administration I (1Z0-082) certification validates skills in administering Oracle Database environments. It covers topics such as installation, backup and recovery, security, and performance tuning. Aimed at database administrators, it ensures proficiency in managing Oracle Database efficiently, ensuring data integrity, optimizing performance, and implementing security measures. Certification demonstrates expertise in Oracle Database administration, enhancing career prospects by validating skills in maintaining reliable and secure database systems, supporting organizational data management needs effectively. It prepares professionals for roles focused on database administration, enabling them to deploy and manage Oracle Database solutions to meet business requirements.
What Will You Learn?
- 1. In-Demand Skills
- 2. Career Advancement
- 3. Efficient CRM Management
- 4. Data Security
- 5. Workflow Automation
- 6. Reporting Insights
- 7. Job OpportunitiesHours On Demanded Videos
Course Content
Module 1: Introduction
-
Introduction
-
Course Summary
Module 2: Oracle Database Architecture
-
Introduction to Oracle Db Architecture
-
Oracle Instance
-
Components Overview
Module 3: SGA Data Structures
-
Database Buffer Cache
-
Shared Pool
-
Redo Log Buffer
-
Other SGA Components
-
SGA Recap
Module 4: Process Structures
-
Database Writer (DBWn)
-
State of a Buffer
-
Type of DB Block Buffers
-
Log Writer (LGWR)
-
Process Monitor (PMON)
-
System Monitor (SMON)
-
Check Point (CKPT)
-
Archiver Process (ARCn)
-
Manageability Monitor, Memory Manager & Listener Registration Processes
-
User Process | Server Process | Network Process
-
Connection Vs Session
Module 5: Storage Structures
-
Database Storage Files
-
What happens on queries on a fresh instance
-
Understanding redo log files and archive redo logs
Module 6: Database Management Tools
-
Oracle Universal Installer (oui)
-
Database Configuration Assistant (dbca)
-
Changing from one SID to another: Hands on Lab
-
Other Management Tools
-
Enterprise Manager Express (EM Express): Hands on Lab
Module 7: Managing the Database Instance
-
Introduction
-
What is a Parameter?
-
SPFILE Vs PFILE
-
SPFILE & PFILE Hands on Lab
-
Parameters: Hands on Lab
-
Modifying Parameters: Theory
-
Dynamic parameters: Session level hands on lab
-
Dynamic parameters-system level hands on lab
-
Static parameters: Hands on lab
-
Editing the PFILE
-
Parameters recap
Module 8: Database Startup Process
-
Startup Process
-
Open Modes: Restrict Mode
-
Open Modes: Read Only Mode
-
Open Modes: Suspend Open Mode
-
Open Modes: QUIESCE Open Mode
Module 9: Database Shutdown Options
-
Shutdown modes
-
Recap
Module 10: Trace Files and Alert Log File
-
Alert log file
-
Trace files
-
adrci utility: view alert log file
-
DDL Logging
-
Summary
Module 11: Dynamic Performance Views and Data Dictionary
-
Dynamic Performance Views
-
Data Dictionary
Module 12: Oracle Net
-
Introduction to Oracle Net
-
Naming Methods: Easy Connect
-
Naming Methods: Local Naming
-
Naming Methods: Directory Naming
-
LSNRCTL and NETCA
Module 13: Logical Storage vs Physical Storage
-
Overview
-
System Tablespace
-
Sysaux Tablespace
-
Temp Tablespace
-
Undo and Users Tablespaces
-
Segment Information
-
Extent Information
-
Db block information
-
Datafile Information
-
Hands on Lab: Creating a tablespace using EM Express
-
Extend Allocation: Automatic or Uniform
-
Logging | Nologging | Force Logging Feature
-
Automatic Segment Space Management vs Manual Segment Space Management
-
Oracle Managed Files
-
Moving, Copying and Renaming Datafiles Online
-
Hands on Lab: Simulating table full Error
-
on Lab: Simulating table full Error
Module 14: Database User and Security
-
What is a User Account?
-
Administrative privileges and Accounts
-
User Authentication methods in Oracle
-
Hands on Lab: System Privileges and Object Privileges