Oracle Database Administration: intermediate Oracle 12c

https://www.skillsoft.com/channel/oracle-database-administration-c3ddc0a0-e197-11e6-91a7-0242c0a80704?expertiselevel=3983462&technologyandversion=3983464 https://www.skillsoft.com/channel/oracle-database-administration-c3ddc0a0-e197-11e6-91a7-0242c0a80704?expertiselevel=3983463&technologyandversion=3983464
  • 29 Courses | 24h 10m 34s
  • 8 Books | 87h 59m
  • Includes Lab
  • 32 Courses | 28h 4m 48s
  • 8 Books | 80h 34m
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
 
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 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 14m 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 | 39m 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 17m 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 | 25m 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 5m 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 | 59m 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 20m 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 | 48m 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 | 40m 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 5m available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 available 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 available 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 available 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 available 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 available 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 has Assessment available 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 available 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 has Assessment available 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 has Assessment available 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 available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 available 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 available 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 available 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 available 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 available 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 available 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 available 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 available 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 has Assessment available 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 available 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 available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available Badge
Oracle Database 12c R2 SQL: Using the Set Operators
Discover how to write SQL queries by using set operators.
8 videos | 40m has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 Edition
Taking 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.
book Duration 13h 28m book Authors By Darl Kuhn

Book

Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition
Your 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.
book Duration 5h 50m book Authors By Ignatius Fernandez

Book

Oracle Database 12c Release 2 New Features
Describing 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.
book Duration 3h 54m book Authors By Bob Bryla, Robert G. Freeman

Book

Oracle Database 12C Release 2 Testing Tools and Techniques for Performance and Scalability
Using 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
book Duration 4h 27m book Authors By Bert Scalzo, Deiby Gómez, Jim Czuprynski

Book

Oracle Database 12c Release 2 Performance Tuning Tips and Techniques
Filled 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.
book Duration 19h 18m book Authors By Richard J. Niemiec

Book

Oracle Database 12c Oracle RMAN Backup & Recovery
Presenting 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.
book Duration 12h 52m book Authors By Matthew Hart, Robert G. Freeman

Book

Oracle Database 12c Security
Authored 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.
book Duration 7h 1m book Authors By David Knox, Scott Gaetjen, William Maroulis

Book

Oracle Database 12c: The Complete Reference
Offering 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.
book Duration 21h 9m book Authors By Bob Bryla, Kevin Loney
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Oracle Database 12c: The Complete Reference
Offering 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.
book Duration 21h 9m book Authors By Bob Bryla, Kevin Loney

Book

Pro Oracle Database 12c Administration, Second Edition
Taking 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.
book Duration 13h 28m book Authors By Darl Kuhn

Book

Oracle DBA Mentor: Succeeding as an Oracle Database Administrator
Helping 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.
book Duration 6h 33m book Authors By Brian Peasland

Book

Oracle Database 12c Release 2 New Features
Describing 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.
book Duration 3h 54m book Authors By Bob Bryla, Robert G. Freeman

Book

Oracle Database 12C Release 2 Testing Tools and Techniques for Performance and Scalability
Using 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
book Duration 4h 27m book Authors By Bert Scalzo, Deiby Gómez, Jim Czuprynski

Book

Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition
Your 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.
book Duration 5h 50m book Authors 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.
book Duration 18h 42m book Authors By Biju Thomas

Book

Oracle Database 12c: Install, Configure & Maintain Like a Professional
Filled 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.
book Duration 6h 31m book Authors By Ian Abramson, Michael Abbey, Michael Corey, Michelle Malcher
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)