Oracle Database 12c Administrator Certified Associate: 1Z0-071: Oracle Database 12c SQL
  • 14 Courses | 14h 8m 57s
  • 5 Books | 64h 9m
  • Includes Lab
  • 17 Courses | 17h 54m 27s
  • Includes Test Prep
Likes 89 Likes 89
Discover essential database management skills as you prepare for the Oracle Database 12c Administrator Certified Associate certification.


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 14m 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 20m 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 | 43m 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 24m 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 | 26m 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 11m 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 4m 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 20m 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.