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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

CIS 428 Database Administration II

$200.99

Buy Now

Related Courses

All Courses