Save for later
Importing and Exporting Oracle Data for Developers
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.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 3.6 hours |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pankaj Jain |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | Data Science |
Tags | Software Development Oracle Database |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Event Specialist and Data Collection Specialist $40k
Data Steward/Analyst $52k
Sn Data Analyst $75k
LAN/WAN Data Analyst $84k
Mobile Data Analyst $92k
Analyst, Fixed Income Data Management Consultant $101k
Assistant Research and Data Analyst Consultant $104k
Vice Assistant President Data Scientist Development Program $106k
Deputy Data Management Specialist $127k
Big Data Analytics Platform Architect and Business Intelligence Leader $143k
Data warehouse & BI professional $175k
Data Warehouse Solutions Architect $192k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 3.6 hours |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pankaj Jain |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | Data Science |
Tags | Software Development Oracle Database |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course