Oracle Database Administration

Explore all aspects of managing Oracle database software.

Technologies: Oracle 12c, Oracle SQL 12c
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.
Discover how to control database access to specific objects and add new users with different levels of access privileges.
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
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.
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.
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.
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.
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.
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
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.
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.
Discover how to write SQL queries by using set operators.
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
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.
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
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.
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.
Because RMAN uses resources, you need to monitor and correct any performance issues that may occur. Learn to use the Oracle Database 12c tools for troubleshooting and tuning RMAN, and best practices for restore and recovery performance.
There may be times when you want to duplicate a database, such as for recovery or testing purposes. Examine various methods for duplicating a database in Oracle Database 12c, including using RMAN.
In Oracle Database 12c, Point-in-Time Recovery lets you recover one or more objects to an earlier time without affecting other objects within the database. Learn how to perform tablespace Point-in-Time recovery and table recovery.
Using Data Transport in Oracle Database 12c, you can transport tablespace to other databases or transport entire databases. Discover how to perform both tablespace and database transports.
The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Examine various Flashback technologies, and how to configure and use them.
In some cases, an Oracle database will lose files when a failure occurs. Discover how to recover from the loss of control, password, and redo log files, and how to restore a database to a new host and perform disaster recovery.
The Data Recovery Advisor is an excellent tool to help protect data in your Oracle databases. Learn how to diagnose and repair failures using Data Recovery Advisor, and how various restores and recoveries are performed.
As an Oracle database administrator, it is vital that you perform regular backups of the databases. Learn how to perform and manage different types of backups, including incremental, full, block media recovery, and encrypted.
The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Discover how to use Flashback Data Archive and Flashback Database as part of your backup and recovery strategy.
You can backup, restore and recover Oracle databases using the Oracle Recover Manager (RMAN). Explore backup requirements and different strategies that you can employ.
The Oracle Recover Manager (RMAN) lets you backup, restore and recover Oracle databases. Learn how to configure Recovery Manager (RMAN), and how to create a recovery catalog for managing database backup, restore, and recovery processes.
What makes Oracle Database 12c tick? Explore the Oracle Database Server architecture, process architecture, grid infrastructure, and DBA tools.
To help recover from a failure, you can use Oracle Secure Backup with Recover Manager (RMAN). Learn about Oracle Secure Backup, and how to install and configure it for use with RMAN to perform backups and restores.
It is crucial that a database can be recovered in the event of a failure. Explore the different backup and recovery solutions available in Oracle Database 12c.
When an Oracle database fails, a restore or recovery operation will be needed. Examine how to perform different types of restore operations, including when the database is in ARCHIVELOG or NOARCHIVELOG mode.
Keep your database performing efficiently by increasing your knowledge of Oracle Database 12c performance tuning, including how to use the Oracle Scheduler to create and schedule jobs.
Ensure efficient database performance by taking advantage of tuning tools available in Oracle Database 12c. Discover how to manage resources to optimize performance, including working with Resource Manager and monitoring statistics.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.
SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.
It's important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.
Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.
Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. Learn about the features and functionality of SQL*Plus, including editing, file, and output commands.
As an administrator or developer, it's important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema.
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.