Oracle 12c: Database Administration I Part 1

 

Course Description

 

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

 

 

 

Once you have completed Oracle 12c: Database Administration I Part 1 the next course is this series is Oracle 12c: Database Administration I Part 2. The Oracle 12c: Database Administration I Part 2 course will continue to build your knowledge in shared server, database performance monitoring, database maintenance, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 12c: Database Administration I Part 2.

 

In This Course You Will Learn How To:

  • Explain Oracle's architectural components
  • Demonstrate how to use Oracle's universal installer and configuration assistants
  • Identify the different interfaces to an Oracle database
  • Define the differences between Container Databases and Pluggable Databases
  • Define Oracle’s Multitenant environment
  • Describe the different database control and storage structures
  • Explain how to use schema and user management tools
  • Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database
  • Describe PL/SQL declarations, code and exceptions
  • Discuss Oracle's password security and database auditing features
  • Configure Oracle's default user account features
  • Configure and tune Oracle's Listener and Net Services features
  • Learn how to establish, tune and monitor Oracle's Shared Server configuration
  • Explain how to manually and automatically monitor the performance of an Oracle database
  • Describe how to use Oracle's advisors to help tune and monitor database performance
  • Show how to tune and administer Oracle's database undo management
  • Discover how Oracle detects and resolves locking conflicts
  • Learn the roles of control files, data files and redo log files in database backup and recovery
  • Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery

 

Prerequisites

 

In order to successfully complete Oracle 12c Database Administration 1 Part 1 you will need to have equivalent experience in or have taken:

  • Oracle 10g/11g: Introduction to SQL
  • Oracle 10g/11g: Advanced SQL
  • Oracle 11g PL/SQL Programming Part 1
  • Oracle 11g PL/SQL Programming Part 2

 

Outline

 

Module 00: Course Introduction - Oracle 12c: Database Administration I Part 1

 

 

 

Module 01: Database Architecture

  • Oracle Architecture
  • Memory Components
  • Background Processes
  • Quiz: Database Architecture

 

 

Module 02: Oracle Physical and Logical Structures

  • Oracle Logical Storage Structures
  • Oracle Physical Storage Structures

 

Module 03: Oracle and ASM

  • ASM Instance
  • ASM parameters
  • ASM Components
  • Quiz: Oracle and ASM

 

Module 04: Container Databases and Pluggable Databases

  • Define Container databases
  • Define Pluggable databases

 

Module 05: Oracle 12c Installing ASM

  • Define ASM
  • Install ASM
  • Lab Exercise: Create and Install ASM
  • Lab Exercise Solution: Create and Install ASM Demo

 

Module 06: Installing the Database Software

  • Define database software requirements
  • Install Oracle database Software
  • Lab Exercise: Installing the Database Software
  • Lab Exercise Solution: Installing the Database Software Demo

 

Module 07: Creating a Container Database

  • Define Database Requirements
  • Create a Container Database using DBCA

 

Module 08: Creating a Traditional Database

  • Define Database Requirements
  • Create a Traditional Database using DBCA
  • Lab Exercise: Create a Database
  • Lab Exercise Solution: Create a Database Demo

 

Module 09: Oracle 12c Database Tools

  • Define SQLPLUS
  • Use Enterprise Manager Express
  • Demo: Use Enterprise Manager Express

 

Module 10: Manage your Database with SQL Developer

  • Manage Database with SQL Developer
  • Understanding SQL Developer
  • Demo: Use SQL Developer

 

Module 11: Manage your Database with Cloud Control

  • Manage your database with Cloud Control
  • Cloud Control Architecture
  • Demo: Use Cloud Control

 

Module 12: Managing the Database Instance

  • Define the components of the SGA
  • Identify initialization parameters

 

Module 13: Start/Stop the Database

  • Start/Stop the database
  • Identify the Location of the Alert.log file
  • Use Dynamic Performance Views
  • Quiz: Managing the Database Instance

 

Module 14: Maintaining Data Files

  • Create tablespaces
  • Create Container Databases
  • Create Pluggable databases
  • Lab Exercise: Create Container Databases, Pluggable Database and Tablespaces

 

Module 15: Container Database Architecture

  • Identify CDB_* views
  • Utilize CDB security

 

Module 16: Database Security

  • Identify Oracle Default accounts
  • Create Database Users
  • Create database Roles
  • Assign database privileges
  • Lab Exercise: Create DB Users

 

Module 17: Database Profiles

  • Identify Database Profiles
  • Uses for Database Profiles
  • Create Database Profiles

 

Module 18: Database Undo Components

  • Identify Oracle's Undo Segments
  • Identify Undo Parameters
  • How Undo and Flashback Query Work Together
  • Quiz: Database Undo Components

 

Module 19: Database Networking Components Part 1

  • Identify the networking components
  • Set up a Listener

 

Module 20: Database Networking Components Part 2

  • Create a tnsnames files
  • Use Oracle's EZ Connect

 

Module 21: Oracle Database Concurrency

  • Identify Oracle's Locking Mechanism
  • Monitor Row Locks
  • Resolve Row Locks