The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers both Database as a Cloud Service and the on-premises Oracle Database.
Lessons
- Introducing Oracle Database
- Relation Database Models
- Oracle SQL and PL/SQL
- Oracle Database Server Architecture
- Connecting to Oracle Databases
- Oracle Database Tools
- Oracle-Supplied User Accounts
- Querying the Oracle Data Dictionary
Lessons
- Initialization Parameter Files
- Starting Up Oracle Databases
- Shutting Down Oracle Databases
- Opening and Closing PDBs
- Working with the Automatic Diagnostic Repository (ADR)
- Querying Dynamic Performance Views
Lessons
- Methods and Tools to Create PDBs
- Creating PDBs from Seed with SQL*Plus
- Cloning PDBs with SQL*Plus
- Unplugging and Pluggin In PDBs with SQL*Plus
- Dropping PDBs with SQL*Plus
Lessons
- Oracle Net Services
- How Listeners Work
- Configuring Listeners for Dynamic Service Registration
- Configuring Listeners for Static Service Registration
- Configuring Local Naming for Connections
- Testing Oracle Net Connectivity with tnsping
- Configuring Communidation Between Databases
- Dedicated Versus Shared Server Configurations
Lessons
- Creating Users
- Granting Privileges
- Creating and Granting Roles
- Revoking Privileges and Roles
- Creating and Assigning Profiles
- Authenticating Users
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
Lessons
- How Table Data is Stored
- Creating Tablespaces in SQL*Plus
- Altering and Dropping Tablespaces in SQL*Plus
- Viewing Tablespace Information in SQL*Plus
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files in SQL*Plus
Lessons
- Oracle Database Space Management Features
- Block Space Management
- Row Chaining and Migration
- Free Space Management Within Segments
- Types of Segments
- Allocating Extents
- Understanding Deferred Segment Creation
- Space-Saving Features
Lessons
- Undo Data: Overview
- Transactions and Undo Data
- Storing Undo Information
- Comparing Undo Data and Redo Data
- Managing Undo
- Local Undo Mode Versus Shared Undo Mode
- Configuring Undo Retension
- Categories of Undo
Lessons
- Moving Data: General Architecture
- Oracle Data Pump: Overview
- Oracle Data Pump: Benefits
- Data Pump Export and Import Clients
- Data Pump Utility: Interfaces and Modes
- Data Pump Import: Transformations
- SQL*Loader Overview
- Loading Methods
Lessons
- DBA Responsibilities
- Categories of Failure
- Understanding Instance Recovery
- Understanding Types of Backups
- Comparing Complete and Incomplete Recovery
- Oracle Data Protection Solutions
- Flashback Technology
Lessons
- Managing Performance Activities
- Performance Planning Considerations
- Database Maintenance
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor
- Performance Monitoring
- Performance Tuning Methodology
- Database Server Statistics and Metrics
Lessons
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plan Directives
- Adaptive Execution Plans
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer
Lessons
- Oracle Database Resource Manager: Overview
- Resource Manager Elements
- Using Resource Manager to Allocate Resources
- Creating a Simple Resource Plan
- Creating a Complex Resource Plan
- Using the Active Session Pool Feature
- Limiting CPU Utilization at the Database Level
- Limiting CPU Utilization at the Server Level
Lessons
- Controlling the Enterprise Manager Cloud Control Framework
- Starting the Enterprise Manager Cloud Control Framework
- Stopping the Enterprise Manager Cloud Control Framework
Lessons
- Oracle Cloud: Overview
- Database Cloud Service Offerings
- DBCS Architecture
- Features and Tooling
- Additional Database Configuration Options
Lessons
- Automated Database Provisioning
- Creating a Database Deployment
- How SSH Key Pairs are Used
- Creating an SSH Key Pair
- Storage Used for Database Files
Lessons
- Cloud Tooling
- Accessing Tools and Features from the DBCS Console
- Managing the Compute Node Associated With a Database Deployment
- Managing Network Access to DBCS
- Enabling Access to a Compute Node Port
- Scaling a Database Deployment
Lessons
- Backing Up and Recovering Databases on DBCS
- Backup Destination Choices
- Backup Configuration
- Creating an On-Demand Backup
- Customizing the Backup Configuration
- Performing Recovery by Using the Console
- Performing Recovery by Using the dbaascli Utility
Lessons
- Patching DBCS
- Using the DBCS Console to Manage Patches
- Using the dbaascli Utility to Manage Patches
Lessons
- CDB and PDB Master Encryption Keys
- Determining Whether You Need to Create and Activate and Encryption Key for a PDB
- Creating and Activating an Encryption Key
Lessons
- Tablespace Encryption by Default in DBCS
- Transparent Data Encryption (TDE) Overview
- Components of TDE
- Using TDE
- Defining the Keystore Location
- Controlling Tablespace Encryption by Default
- Managing the Software Keystore and Master Encryption Key
- Managing the Keystore in CDBs and PDBs
- Data warehouse Administrator
- Database Administrators
- Database Designers
- Support Engineer
- Technical Adminstrator
Before attending this course, students must have:
- A working knowledge of SQL and PL/SQL packages is very helpful in the course.
- Basic knowledge of Linux operating system
Key Participants Benefit
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
After completing this course, students will be able to:
- Back up, restore, and patch DBCS database deployments
- Describe the DBaaS and on-premises Oracle Database architectures
- Manage database and on-premises Oracle Database architectures
- Manage database instances
- Manage UNDO data
- Move data between databases
- Implement basic backup and recovery procedures
- Monitor and tune database performance
- Tune SQL to improve performance
- Manage resources with Oracle Database Resource Manager
- Create pluggable database (PDBs)
- Configure the Oracle network environment
- Administer user security and implement auditing
- Create and manage tablespaces
- Manage storage space
- Register databases and manage performance with Enterprise Manager Cloud Control
- Create and manage Database as a Cloud Service (DBCs) database deployments
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.
Immediate Feedback on Mastery
Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.
SATV Eligible
Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)
Direct From the Source
MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).
Learn Anywhere Anytime
The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.
Live Hands-on
Labs
Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.
