Importing and Exporting Oracle Data for Developers

Pluralsight
Course Summary
Moving data between databases and schemas is an important need in today's data-centric world. In this course, you will learn the various tools and methods to get data in and out of Oracle quickly and efficiently in several popular formats.
-
+
Course Description
Today, more then ever, data is central to any organization to provide useful insights and competitive advantages. There is also a growing need to move data around, from one database to another or within schemas of the same database, for better analysis, testing, and review. Data warehouses are crucial for predictive analysis, and the need to have efficient tools to extract, transform, and load data in these environments is extremely important. In this course, you will learn how to get data quickly and efficiently in and out of Oracle using popular formats like Excel, XML, JSON, plain insert scripts, and SQL loader format, among others. We will learn about the flexible SQL*Loader tool and its powerful direct path option which can improve load performance by orders of magnitude. We will explore the powerful External table feature, which allows you to query data in external data files using the power of SQL and PL/SQL. After taking this course, as a database developer you should be well equipped with the skills and knowledge to perform data transfer tasks effectively.
-
+
Course Syllabus
Course Overview- 1m 43s
—Course Overview 1m 43sOverview- 6m 35s
—Module Overview 2m 34s
—Prerequisites & Recommended Courses 1m 22s
—Audience 0m 50s
—Tools 1m 0s
—Summary 0m 47sExporting Data Using SQL Developer- 27m 14sImporting Data Using SQL Developer- 9m 21sQuerying Flat Files Using External Tables- 1h 8mImporting Data Using SQL*Loader- 1h 11mSQL*Loader - External Table & Direct Path- 28m 50s