Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL Loader - Learn in 22 Examples to your Wishlist.

Add to Wishlist

SQL Loader - Learn in 22 Examples

Learn how to use SQL Loader Utility to load data from External files into Oracle database tables.
4.3 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
198 students enrolled
Created by Amarnath Reddy
Last updated 4/2016
$15 $50 70% off
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 5 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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 is the target audience?
  • This course is meant for students who are planing to invest their career in SQL.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Effecitvely use the SQL Loader utility to load the data from external files into Oracle database
View Curriculum
  • SQL Knowledge is a must!!!
Curriculum For This Course
Expand All 32 Lectures Collapse All 32 Lectures 01:24:52
How to make best use of the program.
1 Lecture 00:38
How to make best use of the program.
SQL Loader Introduction
7 Lectures 24:25

SQL Loader Components

First Example

Example 2 - Loading from File

Loading Options - Insert, Append, Replace and Truncate

Let's check the bad file...

Loading data from multiple files...
Modifying the data before Loading...
4 Lectures 11:44
Example 3 - FILLER keyword

Example 4 - CONSTANT keyword

Example 6 - Sequence values
Other Data Formats
9 Lectures 21:01
Example 7 - Multiple terminators in a single file

Example 8 - Data format with Fixed record length

Example 10 - Stream of bytes

Example 11 - Fixed length Feilds

Example 12 - Formatted report

Example 12 - Trigger to populate the NULL values

Example 13 : Data format with multiple lines

Example 14 : Data format with multiple lines
Selectively loading the data...
4 Lectures 10:18
Example 15 - Selectively loading the data using Filters

Example 16 - Selectively loading the data using Filters

Example 17 - Loading into Multiple tables

Example 18 - Loading into Multiple tables and Filters
Loading into Complex Objects...
4 Lectures 11:58
Example 19 - Loading Objects

Example 20 - Loading Collections (VARRAY)

Example 21 - Loading Large objects (LOB's)

Loading a EBCDIC file
Direct Path Loads
3 Lectures 04:55
Conventional vs Direct path Loads

Example 22 - Direct path Loads

Restrictions when using Direct path Loads...
About the Instructor
4.5 Average rating
1,602 Reviews
14,226 Students
8 Courses
Oracle Architect

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.

Report Abuse