Oracle

CIS 428 Database Administration II

(STY-CIS428.AE1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Week 1: Maintaining the Database and Managing Performance

  • Proactive Database Maintenance
  • Managing Performance
  • Summary
2

Week 2: Using Backup and Recovery

  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Summary
3

Week 3: Database Failures and Recovery Options

  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
4

Week 4: Controlling Resources and Jobs

  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
5

Week 5: Determining the Database Upgrade Method

  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Summary
6

Week 6: Upgrading the Database

  • Upgrading the Database
  • Summary
7

Week 7: Using Grid Infrastructure and Data Movement Tools

  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Summary
8

Week 8: Loading Data with SQL*Loader

  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
9

Week 9: Introduction to DBaaS

  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Summary
10

Week 10: Navigating with My Services Dashboard

  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary

1

Week 1: Maintaining the Database and Managing Performance

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

Week 2: Using Backup and Recovery

  • Adding New Members in a Database
  • Exporting the Table of a Database
3

Week 3: Database Failures and Recovery Options

  • Creating Database Repository
  • Importing a Table in Database
4

Week 4: Controlling Resources and Jobs

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

Week 7: Using Grid Infrastructure and Data Movement Tools

  • Exporting a Table Using SQL Plus
  • Setting Up the Dump Location
6

Week 8: Loading Data with SQL*Loader

  • Loading External Tables Using Data Pump
  • Managing Tablespace Storage
7

Week 9: Introduction to DBaaS

  • Generating a SSH Key Pair on Windows Using the PuTTYgen Program

Related Courses

All Courses