Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

Oracle database utilities - Perform data export / Import (Udemy.com)

Learn Oracle utilities to move data from one database to another

4.5
885 reviews

Created by: Arun Kumar

Last updated December 2017

icon
What you will learn

  • Learn how to import csv data into oracle database using SQL Loader
  • Perform table. schema level exports using traditional Export Import utility
  • Perform table, schema level imports using traditional Export Import utility
  • Perform import export of tables and schema using Oracle Data Pump

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.5 out of 5higher than 48% of them
  • Reviews885#158 of 389 by number of reviews
  • Length1.5 hoursshorter than 91% of them
  • Last updatedDecember 2017earlier than 82% of them

icon
Course Description

Master oracle utilities with very simple practice exercise which helps you to move data between two oracle databases. Learn how to use oracle utilities to perform data import export into different databases.

Perform entire database, single table or schema level export and import into another Oracle database

  • Perform table, schema, row level export using traditional Export Import utility
  • Perform table, schema,row level import using traditional Export Import utility
  • Perform CSV file import into Oracle database using SLQ * Loader
  • Perform table, schema, row level export using Oracle Data Pump Export utility
  • Perform table, schema, row level import using Oracle Data Pump Import utility
  • Create Oracle Data Pump directory to perform Export and Import

Oracle Data Pump enables very high speed data movement from one database to another

In general, DBA has to perform data Export and Import in real-time environment in order duplicate table or schema from one database to another. Oracle provides utilities in order to easily move data between two oracle databases.

With over 9 lectures, 6 hands on lab activities and 1.5 hrs of video content, you will learn:

  • How to invoke oracle utilities
  • How to get help for any type of oracle utilities
  • How to import a CSV format file inside Oracle database table
  • How to create SQL * Loader Control File for CSV import
  • How to perform a small table, schema or specific row export using Export Import utility
  • How to perform import of same using Export Import utility
  • How to create Data Pump directory both at OS level and Database level
  • How to perform data Export and Import using high performance Data pump utility

By completing Lab Activities, you will be able to work along with the author and learn Oracle Utilities. You can even download lab activities files and practice on your test machine at home.
Read More Intermediate Intermediate Level product length iconTime: 1.5h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Arun Kumar

  Having more than 11+ years of Oracle Architect experience, I am passionate to teach people "Oracle Database Administration" on various versions like 10g, 11g & 12c. My experience goes below: 

  1. Experience in cloning using cold backup, hot backup, RMAN and DBCA for Small to Large Databases. 

  2. Experience in Dataguard implementation and maintenance: Both Physical & Logical standby. 

  3. Experience in applying database patches using OPatch 

  4. Performed several database upgrades & migrations 

  5. Monitoring and Tuning database performance using Enterprise Manager, Scripts 

  6. Proficient in DBA utilities like RMAN, OEM, SQL* Loader, Export/Import, Data pump, Backup and Recovery. 

  7. Experience in creating, managing databases, tablespace, users, profile and schema. 

  8. Oracle database 10g, 11g, 12c Installation on Unix/Linux/Windows environment 

  9. Database creation and management of database objects and schemas. 

  10. Good experience in managing Oracle 10g & 11g RAC environments. 

Read More

icon
More courses by Arun Kumar

$59.99

$49.99

$74.99

$64.99

All courses by Arun Kumar

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.5

885 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Harsh Malviya on 4/29/2025

very intresting to learn this coures thanks to Arun Kumar sir to give this oppourunity to us

By Anonymized User on 6/24/2024

Amazing quick course to brush up the skills and Interesting Lab practice. Highly recommended.

By Anonymized User on 4/23/2024

Thank you, very useful knowledge, examples of cases that are simple and easy to understand. Thank you very much

By Jonathan Lehman on 3/29/2024

Great short course that covers a few common methods of moving data from one Oracle Instance to another. SQL*Loader, which can read from CSV or other text files, the original exp and imp utilities, and Data Pump (expdp and impdp). Good demonstration videos as well, covering several helpful parameters and options for each utility.

By Vijay Shriram Gite on 10/25/2023

Could be better if you added few more options of Datapump utility i. e. Flashback, Timestamp,include,exclude, etc.

By Onur Halavurta on 9/21/2020

The course is generally good but in some points could be an explanation reason why.

By Marcus Albert on 12/1/2019

Habe schon Erfahrung mit dem SQL Loader, daher nichts neues. Für den Einstieg allerdings gut .

By WILLIAM ORLANDO PEREZ ROSADO on 6/20/2019

It is a good course for beginners, the description mentioned that it is for an intermediate level but we have some topics missing like share how to monitor datapump progress, the use of par file and stuff like this. Howeaver this is a good course hope the instructor add more material.

By Claude Aluka on 1/9/2018

The instructor clearly delivers the lecture. One thing I am happy about is the fact that he repeats twice or more times a concept to emphasize his point and to allow students who did not get the point earlier to catch up. Well done.

By Govindaa on 12/31/2017

Very good course to learn Oracle Database Utilties. Explained in simple and crisp manner.

Showing all 10 reviews on CourseDuck

Read all 885 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

Oracle database utilities - Perform data export / Import
Visit course on Udemy Write a review
  • Video Duration: icon 1.5h
  • Price: $54.99
  • Provider: icon Udemy
  • Updated: icon December 2017
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com