SQL Loader - Learn in 22 Examples
What you'll learn
- Effecitvely use the SQL Loader utility to load the data from external files into Oracle database
Requirements
- SQL Knowledge is a must!!!
Description
SQL Loader is an Oracle Utility that's been around almost as long as the Oracle database itself. It is an efficient and flexible tool that you can use to load large amounts of data into an Oracle database.
In simple terms, SQL Loader reads the data from flat files and inserts the data into one or more database tables.
If you would like to learn about SQL Loader, you have landed in the right course!!! This course explains the concepts using 21+ Examples, what else can you expect?
Students will be learning the below skills:
- Understand the functionality of SQL Loader
- Load data from Fixed Width files, Delimited Data and many other data format types.
- Selectively loading the data
- Transforming the data during Load
- Direct Path Loads
- Loading Large objects
- Loading Objects and Collections
- Performance tips...
Who this course is for:
- This course is meant for students who are planing to invest their career in SQL.
Instructor
![Amarnath Reddy](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 26,736 Reviews
- 115,523 Students
- 9 Courses
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.