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 Requirements A laptop with good specifications and Internet connection Basic understanding of oracle database No prior experience is required Description 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 Who this course is for Oracle DBA Oracle developers Oracle apps DBA Homepage