Oracle

IS 325 Advanced Database

(DN-IS325.AE1.E1)
Lessons
Lab (Add-on)
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introducing Oracle Database 12c Components and Architecture

  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
  • Exam Essentials
2

Creating and Operating Oracle Database 12c

  • Oracle Database 12c Software Installation
  • Using DBCA to Create an Oracle 12c Database
  • Working with Oracle Database Metadata
  • Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
  • Exam Essentials
3

Understanding Storage and Space Management

  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
  • Exam Essentials
4

Managing Data Concurrency and Undo

  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
  • Exam Essentials
5

Understanding Oracle Network Architecture

  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • An Overview of Oracle Shared Server
  • Understanding Database Resident Connection Pooling
  • Communicating Between Databases
  • Summary
  • Exam Essentials
6

Implementing Security and Auditing

  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
7

Maintaining the Database and Managing Performance

  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
8

Using Backup and Recovery

  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
9

Controlling Resources and Jobs

  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
  • Exam Essentials
10

Upgrading to Oracle Database 12c

  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Upgrading the Database
  • Summary
  • Exam Essentials
11

Using Grid Infrastructure and Data Movement Tools

  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
  • Exam Essentials
12

Introduction to DBaaS

  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary
13

Video Tutorials

  • Introduction
  • Database Concepts And Tools
  • DML Atomicity
  • DML Statements
  • Data Concurrency
  • Backup
  • Installation
  • Memory Structure
  • Tables
  • Indexes
  • Constraints And Triggers
  • Implementing Security
  • Storage Structures
  • Internal Memory Structures
  • Background Processes
  • Starting And Stopping Database
  • Critical Storage Files

1

Introducing Oracle Database 12c Components and Architecture

  • Displaying the Connection Name
  • Displaying Information About the Active Services in the Database
  • Unlocking the Pluggable Database
  • Altering the Session of the Database Container and the Pluggable Database
  • Unlocking and Connecting to the User Account
  • Understanding SGA
  • Creating a Cluster
  • Creating a Cluster Index
  • Removing a Cluster
2

Creating and Operating Oracle Database 12c

  • Creating a New Pluggable Database
  • Viewing the User Details
  • Creating a New User Using SQL Plus
  • Creating a Group Using SQL Plus
  • Dropping a User Using SQL Plus
  • Modifying the Current Database Parameters
  • Managing Initialization-Parameter Files
  • Monitoring the Database Alert Log
3

Understanding Storage and Space Management

  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression
4

Managing Data Concurrency and Undo

  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table
5

Understanding Oracle Network Architecture

  • Creating a Local Connection using the SQL Developer
  • Creating a Listener
  • Configuring the Local Naming Method
  • Using the V$SESSION View
  • Configuring DBMS_CONNECTION_POOL
  • Creating Database Links
6

Implementing Security and Auditing

  • Creating a Database User and Granting Privileges to a User
  • Creating and Granting Roles to a User
  • Revoking Privileges and Dropping a Role
  • Creating a Table using a Primary Key
  • Working with DML Triggers
  • Working with DDL Triggers
  • Working with System Event Triggers
  • Using the Instead-of Triggers
  • Using Constraints in the Table
  • Creating a View
  • Updating a View
  • Dropping a View
  • Creating a Procedure in SQL Plus
  • Dropping a Procedure in SQL Plus
  • Creating and Executing a Function in SQL Plus
  • Dropping a Function in SQL Plus
  • Creating a Profile
  • Enabling Privilege Auditing in SQL Plus
7

Maintaining the Database and Managing Performance

  • Disabling the Automatic Space Advisor
  • Enabling the Automatic Space Advisor
  • Viewing Automatic Memory Management Components
8

Using Backup and Recovery

  • Adding New Members in a Database
  • Exporting the Table of a Database
  • Creating Database Repository
  • Importing a Table in Database
9

Controlling Resources and Jobs

  • Granting the System Privilege
  • Revoking the System Privilege
  • Creating a Scheduler Job
10

Using Grid Infrastructure and Data Movement Tools

  • Exporting a Table Using SQL Plus
  • Setting Up the Dump Location
  • Loading External Tables Using Data Pump
  • Managing Tablespace Storage

Related Courses

All Courses