Database Backup & Recovery: MySQL 5.6 beginner
Technology:
Expertise:
- 1 Book | 13h 29m
- 15 Courses | 10h 59m 7s
- 2 Books | 19h 27m
- 3 Courses | 2h 19m 25s
- 2 Books | 17h 18m
Learn all about the importance of database backup and recovery and how to perform this key administrative role.
COURSES INCLUDED
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
Recovery & Backup
BI administrators need to ensure that stored data is valid and available to the users. Discover how to design and implement strategies for data backup, recovery, and logging in a BI solution.
9 videos |
42m
Assessment
Badge
Backup & Recovery Strategies
From an individual to the largest organization, it is crucial that you always back up your data. Discover SQL Server 2014 backup strategies, how to perform a backup, and how to create and maintain a disaster recovery plan.
8 videos |
48m
Assessment
Badge
Recovery Implementation
Should something go wrong, you can always use your SQL Server backup to recover your data. Explore the SQL Server 2014 recovery process, including restoring from Azure and Azure SQL Database.
6 videos |
48m
Assessment
Badge
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
MySQL Administrator's BibleWith special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators.
13h 29m
By Keith Murphy, Sheeri Cabral
BOOKS INCLUDED
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
RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second EditionOffering a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform, this easy-to-read guide presents Oracle database administrators with task-oriented, ready-made solutions to both common and not-so-common backup and recovery scenarios.
13h 37m
By Arup Nanda, Darl Kuhn, Sam Alapati
BOOKS INCLUDED
Book
Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention TechniquesUsing a tutorial method of teaching, this essential guide explores the many facets behind the principles of backing up and restoring data from your database, and then shows practical application methods for getting the work done quickly and correctly.
2h 48m
By Bradley Beard
Book
Professional SQL Server 2014 AdministrationMicrosoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. This book is your comprehensive guide to working with the new environment.
14h 30m
By Adam Jorgensen, Bradley Ball, Brian Knight, Ross LoForte, Steven Wort