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 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.