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.

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 Overview 1min
• Overview 6mins
• Exporting Data Using SQL Developer 27mins
• Importing Data Using SQL Developer 9mins
• Querying Flat Files Using External Tables 68mins
• Importing Data Using SQL*Loader 71mins
• SQL*Loader - External Table & Direct Path 28mins