Description: Proper monitoring and tuning of databases significantly improves system performance. In this course, you'll learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c. You'll also learn how to manage resources to optimize performance and how to use the Oracle Scheduler to create and schedule jobs. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Duration: 02:39
Description: Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. In this course, you'll learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c. You'll also learn how to monitor and tune both database and memory performance in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Duration: 01:58
Description: A key responsibility of an Oracle database administrator is protecting databases from failure. It's also important to be able to import and export data in various ways. In this course, you'll 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. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Duration: 02:16
Description: Protecting the security of an Oracle Database 12c system involves controlling and monitoring database access. In this course, you'll learn how to manage privileges and use roles, profiles, quotas, and password security in Oracle Database 12c. You'll learn how to detect and resolve lock conflicts, and you'll learn how to enable and manage auditing of database activity. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Duration: 02:16
Description: Key aspects of administering Oracle Database 12c include managing client connections to database servers and optimizing the ways data is stored to conserve space and improve system performance. In this course, you'll learn how to manage Oracle Net Services. You'll also learn how to work with tablespaces and data files, and how to manage the space used by the core storage structures, data blocks and segments. Finally, you'll learn about the Undo feature in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Duration: 02:36
Description: An understanding of the memory, process, and storage architecture – along with the new multitenant architecture – in Oracle Database 12c is a good foundation for working with Oracle database instances. In this course, you'll learn about all the key architectural structures in Oracle Database 12c and how they work together. You'll learn about the main tools for managing Oracle database instances. You'll then learn how to get started, configuring initialization parameters, starting up a database instance, working with log files, and using the various database views in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).
Target Audience: Data warehouse administrators; database administrators; database designers; support engineers; technical administrators
Duration: 02:33