Expdp and Impdp datapump utility course for oracle database
Learners can be able to get hands on experience on datapump utility
Learners get confidence to use datapump utility in real scenarios
Learners can apply the techniques in their workplace
Learners can get an advanced understanding of datapump
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 perfog different hands on lab scenarios with this course
This course is for oracle learners who want to learn datapump utility in oracle for perfog different methods of data copy and refresh data
In this course, learners will perform hands on tasks as if like a real 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
Oracle DBA
Oracle developers
Oracle apps DBA
