Course Title 1:
Using Structured Query Language (SQL)
Course Description:
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
Course Title 43:
SQL Tuning, Resource Management, and Job Scheduling in Oracle Database 12c
Course 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).
Course Title 42:
Database Maintenance and Performance Tuning in Oracle Database 12c
Course 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).
Course Title 41:
Backing Up, Recovering, Importing, and Exporting Data in Oracle Database 12c
Course 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).
Course Title 40:
User Security and Auditing in Oracle Database 12c
Course 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).
Course Title 39:
Connectivity and Space Management in Oracle Database 12c
Course 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...
Course Title 38:
Managing an Oracle Database 12c Instance
Course 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...
Course Title 37:
Upgrading
Course Description:
As a DBA one of the tasks you performed is upgrading or migrating a database to the newest release when it is available. Upgrading a database enables DBAs to take advantage of the newest technologies that are being offered by the provider. Oracle Database 12c provides the latest in efficient, reliable, secure data management for OLTP and cloud applications. This course discusses upgrade and migration methods, how to prepare for and perform an upgrade, as well as how to perform post-upgrade tasks. It also covers how to...
Course Title 36:
Installation
Course Description:
The installation of the Oracle software, Oracle databases and ensuring the correct environment are in place are important tasks for a DBA to complete properly. If these tasks are not done issues may occur to the Oracle system. This course covers how to plan for the Oracle software installation and the Grid Infrastructure. It also discusses how to install the Oracle Database 12c databases and post-installation tasks. This course is one of a series in two SkillSoft learning paths that cover the objectives for the 1Z0-062: Oracle...
Course Title 35:
Database Architecture
Course Description:
To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g Release 2, explains memory structures, describes background processes, and explores the logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course is one of a series in the SkillSoft learning path that covers...
Course Title 34:
TestPrep 1Z0-060 Upgrade to Oracle Database 12c
Course Description:
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Course Title 33:
Transporting Databases and Managing Data
Course Description:
Oracle Database 12c offers new and enhanced features providing better importing and exporting of databases and data. These features include support for CDB and PDBs and better handing of the data being moved. Also provided are better features to allow DBAs to create and manage partitioned tables and indexes and stored large amounts of data within a column. This course will discuss the new and enhanced features of Oracle Data Pump, SQL*Loader and external tables. It will also demonstrate how to use the new...
Course Title 32:
Resource Manager, Online Operations, and ADR
Course Description:
Oracle Database 12c introduces several Resource Manager enhancements to handle resources within CDBs and PDBs. There's a new multiprocess multithreaded Oracle architecture and enhancements to the Database Smart Flash Cache and undo segments. And there are new features for tables and indexes to help to diagnose database data and improve network traffic. This course will discuss and show how to use these new and enhanced features. This course is one in a series in the SkillSoft learning path that...
Course Title 31:
Tuning SQL and Using ADDM
Course Description:
Oracle Database 12c provides many new features, like SQL Plan Directives, to make tuning and monitoring SQL easier. Other improvements include enhancements to the Automatic Database Diagnostic Monitor (ADDM) which now includes Emergency Monitor, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH). This course discusses how to use these new and improved features in Oracle Database 12c to monitor and tune SQL and the database. This course is one in a series in the SkillSoft learning...
Course Title 30:
High Availability and Database Management
Course Description:
An important part of managing an Oracle Database instance is ensuring high availability and manageability. In Oracle Database 12c new features and enhancements have been added to the RMAN client utility to ensure for better back up and recovery of databases. It has also added the Real-Time Database Operation monitoring to allow administrators to monitor database operations. Oracle has also provided the Oracle Enterprise Manager 12c Database Lifecycle Management pack which allows for processes to be automated to...
Course Title 29:
Managing Security
Course Description:
Oracle Database 12c has provided some new security features to better enable security within a database instance. This includes unified auditing to consolidate all audit trails and to improve auditing performance, new administrative privileges and the ability to analyze privileges on users. It also provide a feature called Oracle Data Redaction, which enables sensitive data to be shielded from applications and users on-the-fly before results are sent to the end-user or application. This course will discuss and explain how to use...
Course Title 28:
Using Automatic Data Optimization, Storage, and Archiving
Course Description:
Oracle Database 12c offers multiple features to enable customers to implement an ILM strategy. These features include Heat Map and Automatic Data Optimization to create policies, as well as In-Database Archiving and Temporal Validity to archive data. This course describes how to use Heat Map and ADO to implement an ILM strategy along with partitioning and compression. It also describes how to use the Online Move data file, Online Move partition, In-Database Archiving, and Temporal Validity features to manage...
Course Title 27:
Managing CDB and PDB, and Data Optimization
Course Description:
Oracle database contains the Oracle Multitenant feature, which enables Oracle database to contain a portable set of schemas, objects, and related structures that appear logically to an application as a separate database, called a Container Database or CDB. CDB contains pluggable databases or PDBs. Database administrators need to understand how to manage this new option. This course will demonstrate how to connect to, start and shut these databases down, as well has how to manage their tablespaces and users. It...
Course Title 26:
Enterprise Manager Cloud Control and Creating CDB and PDB
Course Description:
Oracle Database 12c has introduced a number of new features to their management system to maintain the lead in the industry new trend-setting products. Two of these are the Enterprise Manager Cloud Control and Multitenant Container Databases. Enterprise Manager Cloud Control is designed for cloud computing allowing the Oracle Database 12c to be managed through a complete, pre-integrated, off the shelf private cloud solution. Oracle Multitenant allows Oracle to contain a set of portable schemas, objects...
Course Title 25:
SQL Fundamentals
Course Description:
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Course Title 24:
Working with SET Operators and DDL
Course Description:
A key component of a Relational Database is the objects that are created, modified and deleted within the database. This course covers two topics. In the first topic, the course will teach you how to use SET operators in a SQL statement. In the second topic, you will learn how to create a table and work with the various constraints associated with a table. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of...
Course Title 23:
Data Manipulation Language
Course Description:
Once an Oracle 12c relational database has been created with objects, the data in these objects need to be managed. In this course you will learn how to insert, update, delete, and truncate rows. The course will teach the concepts of database transaction control using COMMIT, ROLLBACK, and SAVEPOINT. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.
Course Title 22:
Working with Joins and Subqueries
Course Description:
Database normalization is good practice when building a relational database to minimize data redundancy. In this course, you will learn how to join tables together to view information across multiple tables, how to write subqueries, as well as the more advanced features of the SELECT statements used to obtain values based on an unknown conditional value. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is...
Course Title 21:
Data Conversion and Aggregating Data
Course Description:
Frequently when retrieving data stored in the Oracle database it needs to be converted, manipulated, or aggregated. In this course you will learn about the Oracle conversion functions, conditional expressions, and how to report aggregated data using group functions. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.
Course Title 20:
SQL*Plus and SELECT Statement
Course Description:
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. This course will teach you the features and functionality of SQL*Plus. You will learn to retrieve data using the SQL select statement including arithmetic expressions, Null values, column aliases, literal strings. You will also learn how to deal with duplicate rows. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is...
Course Title 19:
Relational Database and SQL Developer
Course Description:
Since Oracle Database 12c is an object-relational database management system, an in-depth understanding of the theoretical and physical aspects of a relational database is a fundamental requirement for a skilled database administrator and developer. This course will teach you about data models, the Entity Relationship Model, the Oracle (HR) sample schema, and the features of SQL Developer – Oracle's free integration development environment. This course is one of a series in the SkillSoft learning path that cover...
Course Title 18:
TestPrep 1Z0-071 Oracle Database SQL
Course Description:
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Course Title 17:
Manipulating Data Using Advanced Queries
Course Description:
Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.
Course Title 16:
Controlling User Access
Course Description:
Discover how to control database access to specific objects and add new users with different levels of access privileges.
Course Title 15:
Creating Other Schema Objects
Course Description:
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
Course Title 14:
Using Subqueries to Solve Queries
Course Description:
Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.
Course Title 13:
Reporting Aggregated Data Using the Group Functions
Course Description:
Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.
Course Title 12:
Using Single-Row Functions to Customize Output
Course Description:
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.
Course Title 11:
Restricting and Sorting Data
Course Description:
Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.
Course Title 10:
SQL*Plus
Course Description:
SQL*Plus is an interactive and batch query tool that is installed with every Oracle server and client installation. This course will teach you the features and functionality of SQL*Plus.
Course Title 9:
Data Definition Language (DDL)
Course Description:
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
Course Title 8:
Managing Schema Objects
Course Description:
Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.
Course Title 7:
Managing Objects with Data Dictionary Views
Course Description:
Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.
Course Title 6:
Using the Set Operators
Course Description:
Discover how to write SQL queries by using set operators.
Course Title 5:
Displaying Data from Multiple Tables
Course Description:
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
Course Title 4:
Conversion Functions and Conditional Expressions
Course Description:
Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.
Course Title 3:
Using Basic SELECT statements
Course Description:
Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.
Course Title 2:
Data Manipulation Language and Transaction Control Language
Course Description:
Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.