Oracle Database Administration: Beginner Oracle 12c
  • 29 Courses | 24h 26m 12s
  • 8 Books | 87h 59m
  • 32 Courses | 28h 22m 51s
  • 8 Books | 80h 34m
Likes 129
Explore all aspects of managing Oracle database software.


Oracle Database Instance Overview
To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.
14 videos | 1h 8m has Assessment available Badge
Managing a Database Instance
Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.
14 videos | 1h 14m has Assessment available Badge
Connecting to & Configuring a Database Instance
One key aspect of administering Oracle Database 12c includes managing client connections to database servers. Discover how to manage Oracle Net Services and server configurations.
8 videos | 40m has Assessment available Badge
Connectivity & Space Management
Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.
15 videos | 1h 18m has Assessment available Badge
Undo Feature Overview
An Oracle Database 12c administrator will, at some point in time, need to roll back changes made to the database. Learn how this is done using the Undo feature in Oracle Database 12c.
5 videos | 25m available Badge
User Security Features & Configuration
Securing an Oracle Database 12c system involves controlling who can access the database and what they can do. Learn how to manage privileges, and use roles, profiles, quotas, and password security to make your databases secure.
13 videos | 1h 6m has Assessment available Badge
Auditing Features & Configuration
Monitoring database access is part of the process involved in securing an Oracle Database 12c system. Discover how to detect and resolve lock conflicts, and how to enable and manage auditing of database activity.
14 videos | 1h has Assessment available Badge
Backing Up & Recovering Data
A key responsibility of an Oracle database administrator is protecting databases from failure. Learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c.
17 videos | 1h 21m has Assessment available Badge
Importing & Exporting Data
An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.
11 videos | 48m has Assessment available Badge
Database Maintenance
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.
11 videos | 40m has Assessment available Badge
Performance Tuning
Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.
15 videos | 1h 6m available Badge
SQL Tuning
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.