Oracle Database Administration: intermediate Oracle 12c
Expertise:
Technology:
- 29 Courses | 24h 10m 34s
- 8 Books | 87h 59m
- Includes Lab
- 32 Courses | 28h 4m 48s
- 8 Books | 80h 34m
Explore all aspects of managing Oracle database software.
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 7m
Assessment
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 14m
Assessment
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 |
39m
Assessment
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 17m
Assessment
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 |
25m
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 5m
Assessment
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 |
59m
Assessment
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
Assessment
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 |
48m
Assessment
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 |
40m
Assessment
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 5m
Badge
SQL Tuning
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.
10 videos |
53m
Assessment
Badge
Resource Management
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.
8 videos |
45m
Assessment
Badge
Job Scheduling
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.
9 videos |
48m
Assessment
Badge
Assessing Recovery Requirements
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.
6 videos |
23m
Assessment
Badge
Backup & Recovery Options
What makes Oracle Database 12c tick? Explore the Oracle Database Server architecture, process architecture, grid infrastructure, and DBA tools.
7 videos |
41m
Assessment
Badge
Recovery Configuration
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.
16 videos |
1h 9m
Assessment
Badge
Backup Strategies
You can backup, restore and recover Oracle databases using the Oracle Recover Manager (RMAN). Explore backup requirements and different strategies that you can employ.
6 videos |
31m
Badge
Performing & Managing Backups
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.
17 videos |
1h 10m
Badge
Failure & Recovery Concepts
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.
17 videos |
1h 4m
Badge
Recovery & Availability
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.
8 videos |
41m
Badge
Recovery After Loss
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.
10 videos |
49m
Badge
Secure Backup
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.
5 videos |
24m
Assessment
Badge
Configuring Flashback Technologies
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.
9 videos |
41m
Badge
Using Flashback Technologies
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.
12 videos |
50m
Assessment
Badge
Data Transportation
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.
7 videos |
30m
Assessment
Badge
Performing PITR
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.
9 videos |
35m
Badge
Duplicating Databases
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.
9 videos |
44m
Assessment
Badge
Tuning RMAN
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.
12 videos |
41m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Relational Database Concepts
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.
10 videos |
38m
Assessment
Badge
SQL Developer
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.
16 videos |
1h 1m
Assessment
Badge
SQL*Plus Commands
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.
7 videos |
24m
Assessment
Badge
SELECT Statement, Expressions, & Operators
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.
12 videos |
42m
Assessment
Badge
Restricting Output
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.
10 videos |
44m
Badge
Working with Substitution
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.
5 videos |
23m
Badge
Customizing Output
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.
13 videos |
57m
Badge
Data Conversion
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.
13 videos |
52m
Badge
Aggregating Data
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.
12 videos |
45m
Badge
Working with Joins
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.
17 videos |
1h 1m
Badge
Working with Subqueries
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.
11 videos |
38m
Badge
Data Manipulation Language
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
14 videos |
1h 3m
Badge
Database Transactions
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.
10 videos |
45m
Assessment
Badge
Working with SET Operators
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.
8 videos |
26m
Badge
Working with DDL
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.
18 videos |
1h 10m
Badge
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
10 videos |
49m
Assessment
Badge
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
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.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Basic SELECT statements
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.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
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.
13 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
11 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Using the Set Operators
Discover how to write SQL queries by using set operators.
8 videos |
40m
Assessment
Badge
Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
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.
6 videos |
34m
Assessment
Badge
Oracle Database 12c R2 SQL: Managing Schema Objects
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.
13 videos |
1h 11m
Assessment
Badge
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
12 videos |
1h 2m
Assessment
Badge
Oracle Database 12c R2 SQL: SQL*Plus
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.
8 videos |
45m
Assessment
Badge
Oracle Database 12c R2 SQL: Restricting & Sorting Data
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.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
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.
13 videos |
1h 10m
Assessment
Badge
Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
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.
12 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
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.
11 videos |
1h 22m
Assessment
Badge
Oracle Database 12c R2 SQL: Creating Other Schema Objects
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
12 videos |
49m
Assessment
Badge
Oracle Database 12c R2 SQL: Controlling User Access
Discover how to control database access to specific objects and add new users with different levels of access privileges.
11 videos |
37m
Assessment
Badge
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
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.
11 videos |
1h 7m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Pro Oracle Database 12c Administration, Second EditionTaking a results-oriented approach to getting things done, this book gives clear explanations on how to perform critical tasks and weaves in theory where necessary without bogging you down in unneeded detail to lay a foundation upon which to build a senior level of expertise.
13h 28m
By Darl Kuhn
Book
Beginning Oracle Database 12c Administration: From Novice to Professional, Second EditionYour entry point into a successful and satisfying career as an Oracle Database Administrator, this thorough guide will provide you not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills.
5h 50m
By Ignatius Fernandez
Book
Oracle Database 12c Release 2 New FeaturesDescribing the myriad new and enhanced capabilities available in the latest Oracle Database release, this detailed guide provides everything you need to know to get up and running quickly on Oracle Database 12c Release 2.
3h 54m
By Bob Bryla, Robert G. Freeman
Book
Oracle Database 12C Release 2 Testing Tools and Techniques for Performance and ScalabilityUsing step-by-step instruction and best practices, this book clearly explains how to identify, investigate, and resolve performance issues and will help you seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance
4h 27m
By Bert Scalzo, Deiby Gómez, Jim Czuprynski
Book
Oracle Database 12c Release 2 Performance Tuning Tips and TechniquesFilled with real-world case studies and best practices, this essential resource details the latest monitoring, troubleshooting, and optimization methods and includes coverage on testing, reporting, and security enhancements.
19h 18m
By Richard J. Niemiec
Book
Oracle Database 12c Oracle RMAN Backup & RecoveryPresenting the easiest, fastest, and most effective methods of deploying RMAN in Oracle Database environments of any size, this guide explains how to generate reliable archives and carry out successful system restores, and features full details on cloud computing, report generation, performance tuning, and security.
12h 52m
By Matthew Hart, Robert G. Freeman
Book
Oracle Database 12c SecurityAuthored by renowned experts from Oracle's National Security Group, this Oracle Press guide provides proven techniques for designing, implementing, and certifying secure Oracle Database systems in a multitenant architecture.
7h 1m
By David Knox, Scott Gaetjen, William Maroulis
Book
Oracle Database 12c: The Complete ReferenceOffering complete coverage of installation, configuration, tuning, and administration, this authoritative Oracle Press guide demonstrates how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data.
21h 9m
By Bob Bryla, Kevin Loney
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Oracle Database 12c: The Complete ReferenceOffering complete coverage of installation, configuration, tuning, and administration, this authoritative Oracle Press guide demonstrates how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data.
21h 9m
By Bob Bryla, Kevin Loney
Book
Pro Oracle Database 12c Administration, Second EditionTaking a results-oriented approach to getting things done, this book gives clear explanations on how to perform critical tasks and weaves in theory where necessary without bogging you down in unneeded detail to lay a foundation upon which to build a senior level of expertise.
13h 28m
By Darl Kuhn
Book
Oracle DBA Mentor: Succeeding as an Oracle Database AdministratorHelping new Oracle database administrators get off the ground running, this book will assist you with developing the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues.
6h 33m
By Brian Peasland
Book
Oracle Database 12c Release 2 New FeaturesDescribing the myriad new and enhanced capabilities available in the latest Oracle Database release, this detailed guide provides everything you need to know to get up and running quickly on Oracle Database 12c Release 2.
3h 54m
By Bob Bryla, Robert G. Freeman
Book
Oracle Database 12C Release 2 Testing Tools and Techniques for Performance and ScalabilityUsing step-by-step instruction and best practices, this book clearly explains how to identify, investigate, and resolve performance issues and will help you seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance
4h 27m
By Bert Scalzo, Deiby Gómez, Jim Czuprynski
Book
Beginning Oracle Database 12c Administration: From Novice to Professional, Second EditionYour entry point into a successful and satisfying career as an Oracle Database Administrator, this thorough guide will provide you not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills.
5h 50m
By Ignatius Fernandez
Book
OCA: Oracle Database 12c Administrator Certified Associate Study Guide (Exams 1Z0-061 and 1Z0-062)Authored by an industry expert with hands-on Oracle database experience, this comprehensive guide not only helps you prepare for the challenging 1Z0-061 and 1Z0-062 exams, but also prepares you for the day-to-day work world of a database administrator.
18h 42m
By Biju Thomas
Book
Oracle Database 12c: Install, Configure & Maintain Like a ProfessionalFilled with easy-to-follow tutorials, this Oracle Press guide details core database concepts, the role of the administrator, and enterprise database capabilities, and walks you through database configuration, administration, programming, backup and recovery, and high availability.
6h 31m
By Ian Abramson, Michael Abbey, Michael Corey, Michelle Malcher
SHOW MORE
FREE ACCESS
