雷火电竞外围平台

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 47s
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

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

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.

13h 28m 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.

5h 50m 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.

3h 54m 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

4h 27m 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.

19h 18m 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.

12h 52m 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.

7h 1m 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.

21h 9m By Bob Bryla, Kevin Loney

FREE ACCESS

BOOKS INCLUDED

Book

Oracle Database 12c: The Complete Reference

21h 9m By Bob Bryla, Kevin Loney

Book

Pro Oracle Database 12c Administration, Second Edition

13h 28m 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.

6h 33m By Brian Peasland

Book

Oracle Database 12c Release 2 New Features

3h 54m By Bob Bryla, Robert G. Freeman

Book

Oracle Database 12C Release 2 Testing Tools and Techniques for Performance and Scalability

4h 27m By Bert Scalzo, Deiby Gómez, Jim Czuprynski

Book

Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition

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 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.

6h 31m By Ian Abramson, Michael Abbey, Michael Corey, Michelle Malcher

FREE ACCESS

COURSE Database Fundamentals: Database Administration Basics

BOOK Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization's Data, Third Edition

CHANNEL Oracle Database 12c: RAC and Grid Infrastructure Administration

Try Skillsoft for Free!

Get Started

Sharpen your skills. Upgrade your career. Find the right learning path for you, based on your role and skills. Take part in hands-on practice, study for a certification, and much more - all personalized for you.

* Content items for Compliance and Leadership are not included in this subscription.

Your content + our content + our platform = a path to learning success

Using our learning experience platform, Percipio, your learners can engage in custom learning paths that can feature curated content from all sources.

Learn More

Aspire to something bigger

Aspire Journeys are guided learning paths that set you in motion for career success.

Browse Aspire Journeys

Explore a world of live learning with Global Knowledge

Choose from convenient delivery formats to get the training you and your team need - where, when and how you want it.

Browse Live Learning

雷火电竞外围平台

COURSES INCLUDED

COURSES INCLUDED

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

BOOKS INCLUDED

BOOKS INCLUDED

YOU MIGHT ALSO LIKE