DATAPUMP EXPDP/IMPDP REALTIME COURSE FOR ORACLE DBA’S

Expdp and Impdp datapump utility course for oracle database

Objective:

What you’ll learn

  • Learners can be able to get hands on experience on datapump utility.
  • Learners get confidence to use datapump utility in real time scenarios.
  • Learners can apply the techniques in their workplace.
  • Learners can get an advanced understanding of datapump.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Install and Configure Oracle linux Setup –> 6 lectures • 21min.
  • Install Oracle database software –> 2 lectures • 8min.
  • Install Oracle database –> 1 lecture • 5min.
  • Scratching the basics –> 3 lectures • 38min.
  • Clone vm for source database –> 3 lectures • 8min.
  • Rename database using NID utility –> 2 lectures • 12min.
  • Monitor datapump job –> 2 lectures • 16min.
  • Diagnose datapump jobs –> 1 lecture • 14min.
  • PARFILE parameter –> 1 lecture • 5min.
  • Halt,resume,terminate and influence parallel of datapump –> 1 lecture • 19min.
  • Export data across multiple dumpfiles –> 1 lecture • 8min.
  • Estimate the size of the dumpfile before export –> 1 lecture • 11min.
  • Spread dumpfile across multiple disks –> 1 lecture • 14min.
  • Different scenarios of using datapump –> 6 lectures • 52min.
  • Export views in table structure –> 1 lecture • 9min.
  • Issues encountered and how to troubleshooting them while using datapump –> 1 lecture • 11min.
  • Monitor progress for each object type –> 1 lecture • 3min.
  • Load data over network –> 2 lectures • 25min.
  • Analyze master table –> 4 lectures • 14min.
  • Compress data using expdp –> 1 lecture • 9min.
  • Configure NFS mount –> 2 lectures • 8min.
  • Distribute Workers across RAC nodes –> 2 lectures • 7min.

DATAPUMP EXPDP/IMPDP REALTIME COURSE FOR ORACLE DBA'S

Requirements

  • A laptop with good specifications and Internet connection.
  • Basic understanding of oracle database.
  • No prior experience is required.

Objective:

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

 

  • This course is for oracle learners who want to learn datapump utility in oracle for performing different methods of data copy and refresh data
  • In this course, learners will perform hands on tasks as if like 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 application team after completing the course
  • Datapump is the core of this course. So only datapump utility will be explained
  • Hope the learner who applies for this course has a prior understanding of what oracle database is.
  • There are different oracle versions for datapump like 11g,12c and 19c. All these versions will be used and their efficiency will be compared.
  • You will learn how to export a database,schema,table,index,constraint,view and query etc.. and import them to a database using different methods
  • You will learn how to speed  up the export and import with different parameters and different approaches.

 

Prerequisites:

Oracle Database Administration fundamentals

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:

Oracle DBA