Data movement course

person icon Kishan M

3.9 ★★★ ★ ★

Buy Now

Data movement course

Name: undefined
Rating: 3.9 (362 reviews)
Author: Kishan m

updated on icon Updated on May, 2024

language icon Language - English

person icon Kishan M

English [CC]

category icon Development,Database Management

Lectures -65

Resources -11

Duration -7.5 hours

3.9 ★★★ ★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Practice makes perfect! Master data pump utility by performing different hands-on lab scenarios with this course

Oracle data pump tool boosts the migration of data and metadata from the source database to the destination database. It is also the most widely used utility in oracle database for data copy, refresh, etc, and also used in cloud migrations. So learning this tool help you in your career.

Goals

What will you learn in this course:

This course is for oracle learners who want to learn data pump utility in oracle for performing different methods of data copy and refreshing data
In this course, learners will perform hands-on tasks as if in a real-time scenario with different situation-based tasks
All the parameters will be used in the practical box for different oracle versions
Oracle machine is built in virtual box for simulation of the tasks
Learners can be able to confidently face a request from the application team after completing the course
Datapump is the core of this course. So only the data pump utility will be explained

Prerequisites

What are the prerequisites for this course?

Linux operating system basics
PC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit
CPU core(minimum) - 2
Student category: Linux

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
1 Lectures

Course Introduction 02:13 02:13

Install OEL 7.8
5 Lectures

Configure Oracle prerequisites
3 Lectures

Install Oracle database 12c
1 Lectures

Basics
3 Lectures

VM clone for setup
5 Lectures

Monitor Datapump
2 Lectures

Trace datapump jobs
1 Lectures

Parfile for datapump command standards
1 Lectures

Start,Stop,Resume and Kill datapump jobs
1 Lectures

Export Data across multiple dumpfiles
1 Lectures

Estimate dumpfile size
1 Lectures

Spread dumpfiles across disks
1 Lectures

Datapump Scenarios
7 Lectures

Locking issues during export/import
1 Lectures

Monitor progress for each object type
2 Lectures

Load data through network
2 Lectures

Master table analysis
4 Lectures

Compression levels
1 Lectures

Configure NFS mount
1 Lectures

Datapump parameters in RAC
3 Lectures

Consistent backup
1 Lectures

Logfile exclude
1 Lectures

Access methods
1 Lectures

User definition backup
2 Lectures

Objects definitions in a SQL file
4 Lectures

Export Samples of data
1 Lectures

Query filter using expdp
1 Lectures

Data Obfuscation
1 Lectures

Archivelog disable during import
1 Lectures

Optimize datapump
3 Lectures

Limit parallel worker at database level
2 Lectures

Instructor Details

Kishan m

Course Certificate

Use your certificate to make a career change or to advance in your current career.