Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 24 Minute(s)
Language
English
Taught by
Amarnath Reddy
Rating
Course Overview
Learn how to use SQL Loader Utility to load data from External files into Oracle database tables.
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...
Course Content
- 7 section(s)
- 32 lecture(s)
- Section 1 How to make best use of the program.
- Section 2 SQL Loader Introduction
- Section 3 Modifying the data before Loading...
- Section 4 Other Data Formats
- Section 5 Selectively loading the data...
- Section 6 Loading into Complex Objects...
- Section 7 Direct Path Loads
What You’ll Learn
- Effecitvely use the SQL Loader utility to load the data from external files into Oracle database
Skills covered in this course
Reviews
-
MMarino Bordari
Il corso descrive con precisione molteplici aspetti di utilizzo pratico dell'SQL Loader e l'ho trovato molto interessante e coinvolgente
-
MMurali Mohan
This course is upto the point with related working examples covering practical use cases.
-
YYOGESH VAIDYA
In this course Example he explained not provided source file. Very Lazy guy.
-
MMohit Mathur
Not satisfied,queries asked in Q&A are not answered,many concepts of SQL Loader are missing,exclusive course on sql loader must cover everything in depth.
