Oracle Database 12c Administrator Certified Associate: 1Z0-071: Oracle Database 12c SQL

https://www.skillsoft.com/channel/oracle-database-12c-administrator-certified-associate-59ced4c0-2c37-11e7-83d1-dba0327abefc?certificationexam=110495 https://www.skillsoft.com/channel/oracle-database-12c-administrator-certified-associate-59ced4c0-2c37-11e7-83d1-dba0327abefc?certificationexam=110496
  • 14 Courses | 14h 21m 27s
  • 5 Books | 64h 9m
  • 17 Courses | 17h 54m 27s
Likes 82 Likes 82
 
Discover essential database management skills as you prepare for the Oracle Database 12c Administrator Certified Associate certification.

COURSES INCLUDED

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 28m
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 | 52m
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 | 44m
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 10m
available Badge