When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Oracle DBA Mastery: Backup, Recovery & Data Movement

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

Oracle DBA Mastery: Backup, Recovery & Data Movement

Ce cours fait partie de Spécialisation "Oracle DBA 21c: Master Database Administration"

Instructeur : EDUCBA

Inclus avec

4 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

1 semaine à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

4 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

1 semaine à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

Design schema objects, constraints, and sequences.
Manage users, tablespaces, and undo data effectively.
Apply RMAN, SQL*Loader, and Data Pump for backup and recovery.

Compétences que vous acquerrez

Catégorie : Database Architecture and Administration
Catégorie : Data Integrity
Catégorie : Disaster Recovery
Catégorie : Data Import/Export
Catégorie : Performance Tuning
Catégorie : Patch Management
Catégorie : Data Maintenance
Catégorie : Data Migration
Catégorie : Database Management
Catégorie : User Accounts
Catégorie : Database Administration
Catégorie : Database Design

Outils que vous découvrirez

Catégorie : Relational Databases
Catégorie : Oracle SQL Developer
Catégorie : Database Management Systems
Catégorie : Oracle Databases

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

14 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation "Oracle DBA 21c: Master Database Administration"

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 4 modules dans ce cours

By completing this course, learners will be able to design schema objects, enforce constraints, configure sequences, manage undo data, administer users, and implement robust backup and recovery strategies in Oracle. They will also apply advanced RMAN techniques, optimize database performance, and execute secure data movement with SQL*Loader and Data Pump.

This course is designed for aspiring Oracle DBAs, IT professionals, and database developers who want to master critical administration tasks. Learners will gain hands-on skills in user management, tablespace configuration, and recovery techniques, ensuring they can protect and optimize enterprise databases. What makes this course unique is its end-to-end coverage of Oracle DBA essentials, from schema design to advanced recovery scenarios, reinforced with real-world demonstrations. It not only teaches backup strategies and data movement techniques but also equips learners with support and patch management skills to ensure ongoing database stability and security. By the end of the course, learners will be able to analyze, configure, and secure Oracle databases effectively, preparing them for professional DBA roles and advanced certification paths.

Détails du module

Inclus

9 vidéos3 devoirs

9 vidéosTotal 72 minutes

Exploring Schema Objects with Enterprise Manager8 minutes
Creating Tables and Defining Tablespace Associations6 minutes
Defining Constraints and Partitioning in Tables7 minutes
Understanding Oracle Data Types10 minutes
Implementing Primary Key and Integrity Constraints10 minutes
Viewing Column Details in Enterprise Manager6 minutes
Dropping Tables and Managing Table Data6 minutes
Creating and Managing Indexes in Oracle8 minutes
Working with Views, Sequences, and Synonyms12 minutes

3 devoirsTotal 50 minutes

Schema Objects & Constraints30 minutes
Exploring Schema Objects10 minutes
Advanced Table and Index Management10 minutes

Inclus

10 vidéos3 devoirs

10 vidéosTotal 86 minutes

Inserting Rows into Tables (Practical Example – Part 1)10 minutes
Inserting Rows into Tables (Practical Example – Part 2)12 minutes
Creating Sequences with Options and Attributes6 minutes
Advanced Sequence Attributes: Interval, Cache, and Ordering6 minutes
Introduction to Undo Data Management in Oracle10 minutes
Undo Segments and Undo Tablespaces Explained9 minutes
Configuring Undo Retention and Guarantee Options9 minutes
Database Architecture and User Management Basics10 minutes
Predefined Oracle Accounts (SYS, SYSTEM, HR, etc.)6 minutes
Exploring and Querying Database Users7 minutes

3 devoirsTotal 50 minutes

Sequences, Undo & User Management30 minutes
Sequences and Data Insertion10 minutes
Undo and User Accounts10 minutes

Inclus

12 vidéos3 devoirs

12 vidéosTotal 107 minutes

Permanent and Temporary Tablespaces for Users10 minutes
User Privileges and Login Permissions8 minutes
Managing and Viewing Tablespaces in Oracle10 minutes
Assigning Roles to Users (DBA and Custom Roles)4 minutes
Navigating Enterprise Manager for User Administration8 minutes
Locking, Unlocking, and Resetting User Accounts9 minutes
Overview of Predefined Roles (CONNECT, RESOURCE, DBA, etc.)8 minutes
Introduction to Backup and Recovery in Oracle11 minutes
User Process Failures and Abnormal Disconnections11 minutes
Checkpoint Process and Instance Recovery Basics8 minutes
Automatic Instance Recovery in Oracle10 minutes
Using MTTR Advisor for Recovery Settings10 minutes

3 devoirsTotal 50 minutes

Backup & Recovery Essentials30 minutes
User and Role Administration10 minutes
Backup and Recovery Basics10 minutes

Inclus

36 vidéos5 devoirs

36 vidéosTotal 293 minutes

Multiplexing Control Files for Database Protection9 minutes
Archiving Redo Log Files for Recovery6 minutes
Introduction to Database Backup Concepts9 minutes
User-Managed (Manual) Backup in Oracle11 minutes
Performing a Whole Database Backup7 minutes
Image Copy Backups of Data and Log Files7 minutes
Introduction to RMAN (Recovery Manager) Backups10 minutes
Configuring Archive Log Mode for Backups8 minutes
Taking Backups with RMAN in Manual Mode8 minutes
Using RMAN with Enterprise Edition for Backups11 minutes
Configuring Backup Settings and Scheduling Jobs11 minutes
Introduction to Database Recovery and Backup Scenarios8 minutes
Using Data Recovery Advisor in Enterprise Manager9 minutes
Configuring Auto Backup Disk Location and Policies6 minutes
Optimizing Database Backups by Skipping Unchanged Files6 minutes
Backup and Recovery Settings in Enterprise Manager9 minutes
Connecting to RMAN for Database Recovery10 minutes
Recovering from Data File Loss in Archive and No-Archive Modes7 minutes
Automated Diagnostic Workflow with Data Recovery Advisor8 minutes
Introduction to Data Movement in Oracle7 minutes
Data Movement Architecture and DBMS Data Pump12 minutes
Using SQL*Loader to Import Data into Oracle8 minutes
Loading Methods in SQL*Loader: Conventional and Direct Path7 minutes
Populating External Tables with SQL*Loader10 minutes
Benefits and Features of Oracle Data Pump7 minutes
Data Pump Export and Import Utilities Explained9 minutes
Data Pump Export Options and Parameters8 minutes
Performance Tuning for Data Pump Jobs4 minutes
Database Architecture and Installation Overview9 minutes
Using Enterprise Manager Support Workbench9 minutes
Creating Service Requests with Oracle Support8 minutes
Managing Incidents and Problems in Oracle6 minutes
Working with Oracle Support Services8 minutes
Using the Knowledge Tab for Issue Resolution9 minutes
Service Request Workflow and Escalation Process6 minutes
Oracle Software Management and Patch Updates6 minutes

5 devoirsTotal 70 minutes

Advanced Backup, Data Movement & Support30 minutes
Backup Strategies and RMAN10 minutes
Advanced RMAN and Recovery Scenarios10 minutes
Data Movement with SQL*Loader and Data Pump10 minutes
Oracle Support and Patch Management10 minutes

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.