Importing and Exporting Oracle Data for Developers

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 info
Level
Beginner
Updated
May 27, 2016
Duration
3h 34m
Table of contents
Course Overview
Overview
Exporting Data Using SQL Developer
Importing Data Using SQL Developer
Querying Flat Files Using External Tables
Importing Data Using SQL*Loader
SQL*Loader - External Table & Direct Path
Description
Course info
Level
Beginner
Updated
May 27, 2016
Duration
3h 34m
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.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 54m
Apr 20, 2017
More courses by Pankaj Jain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello, welcome to Pluralsight. My name is Pankaj Jain, and I'm very excited to present to you this course on Importing and Exporting Oracle Data for Developers. As a developer, working with multiple databases, you would often have a need to move data between databases, export data out from an Oracle database in formats like Excel, this can be passed to business users, or other popular formats like JSON, XML, etc. In this course, we will explore how to export and import data in various formats quickly and effectively using Oracle SQL Developer, which is a free and very powerful IDE provided by Oracle. We will then take a deep dive into external tables, which is a very cool feature of Oracle. It allows you to point at an external data file in the file system, and query it just as if it were a regular table using all the power of SQL and PL/SQL at your disposal, without actually loading the data in the database. We will then look at SQL Loader, a very widely used data loading tool, which is feature rich and extremely flexible in accepting several data formats. All you need to follow along is a very basic understanding of SQL and Oracle programming. I invite you to join me on this exciting journey, at the end of which you would find yourself well equipped with several useful tools and methods to do those data transfer tasks easily and effectively.