.jpg){kind=logo}
STY-CIS428.AE1
CIS 428 Database Administration II
Intermediate Self-paced · 1 year access
15 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
10 Interactive Lessons · 30 topics01 Week 1: Maintaining the Database and Managing Performance 3 topics · 3 LiveLab +
- Proactive Database Maintenance
- Managing Performance
- Summary
3 LiveLab in this lesson — see the labs panel →
02 Week 2: Using Backup and Recovery 3 topics · 2 LiveLab +
- Understanding and Configuring Recovery Components
- Performing Backups
- Summary
2 LiveLab in this lesson — see the labs panel →
03 Week 3: Database Failures and Recovery Options 3 topics · 2 LiveLab +
- Understanding Types of Database Failures
- Performing Recovery Operations
- Summary
2 LiveLab in this lesson — see the labs panel →
04 Week 4: Controlling Resources and Jobs 3 topics · 3 LiveLab +
- Resource Management with the Resource Manager
- Task Automation with Oracle Scheduler
- Summary
3 LiveLab in this lesson — see the labs panel →
05 Week 5: Determining the Database Upgrade Method 3 topics +
- Determining the Database Upgrade Method
- Preparing for a Database Upgrade
- Summary
06 Week 6: Upgrading the Database 2 topics +
- Upgrading the Database
- Summary
07 Week 7: Using Grid Infrastructure and Data Movement Tools 3 topics · 2 LiveLab +
- Tools for Moving Data
- Migrating Data Using Data Pump
- Summary
2 LiveLab in this lesson — see the labs panel →
08 Week 8: Loading Data with SQL*Loader 4 topics · 2 LiveLab +
- Loading Data with SQL*Loader
- Populating External Tables
- Introducing Grid Infrastructure
- Summary
2 LiveLab in this lesson — see the labs panel →
09 Week 9: Introduction to DBaaS 3 topics · 1 LiveLab +
- DBaaS Instance and Database Instance
- Generating a Secure Shell (SSH) Public/Private Key Pair
- Summary
1 LiveLab in this lesson — see the labs panel →
10 Week 10: Navigating with My Services Dashboard 3 topics +
- Navigating with My Services Dashboard
- User Authentication and Roles
- Summary
Hands-On Labs Our edge
15 LiveLabs- Disabling the Automatic Space Advisor
- Enabling the Automatic Space Advisor
- Viewing Automatic Memory Management Components
- Adding New Members in a Database
- Exporting the Table of a Database
- Creating Database Repository
- Importing a Table in Database
- Granting the System Privilege
- Revoking the System Privilege
- Creating a Scheduler Job
- Exporting a Table Using SQL Plus
- Setting Up the Dump Location
- Loading External Tables Using Data Pump
- Managing Tablespace Storage
- Generating a SSH Key Pair on Windows Using the PuTTYgen Program
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for CIS 428 Database Administration II
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 15 LiveLab included
- Certificate of completion
No credit card required