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 (11 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.
162 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 32
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

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

What are the requirements?

  • SQL Knowledge is a must!!!

What am I going to get from this course?

  • Effecitvely use the SQL Loader utility to load the data from external files into Oracle database

What is the target audience?

  • This course is meant for students who are planing to invest their career in SQL.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

How to make best use of the program.
Article
Section 1: SQL Loader Introduction
What is SQL Loader?
Preview
04:20
SQL Loader Components
03:41
First Example
05:14
Example 2 - Loading from File
02:47
Loading Options - Insert, Append, Replace and Truncate
04:35
Let's check the bad file...
03:21
Loading data from multiple files...
Article
Section 2: Modifying the data before Loading...
Example 3 - FILLER keyword
01:34
Example 4 - CONSTANT keyword
01:39
Example 5 - Using SQL Functions
Preview
03:21
Example 6 - Sequence values
05:10
Section 3: Other Data Formats
Example 7 - Multiple terminators in a single file
02:17
Example 8 - Data format with Fixed record length
02:20
Example 9 - Data format with Variable record length
Preview
02:51
Example 10 - Stream of bytes
01:53
Example 11 - Fixed length Feilds
02:06
Example 12 - Formatted report
03:45
Example 12 - Trigger to populate the NULL values
Article
Example 13 : Data format with multiple lines
02:43
Example 14 : Data format with multiple lines
02:06
Section 4: Selectively loading the data...
Example 15 - Selectively loading the data using Filters
03:02
Example 16 - Selectively loading the data using Filters
02:38
Example 17 - Loading into Multiple tables
02:30
Example 18 - Loading into Multiple tables and Filters
02:08
Section 5: Loading into Complex Objects...
Example 19 - Loading Objects
03:11
Example 20 - Loading Collections (VARRAY)
04:52
Example 21 - Loading Large objects (LOB's)
03:33
Loading a EBCDIC file
Article
Section 6: Direct Path Loads
Conventional vs Direct path Loads
02:42
Example 22 - Direct path Loads
01:51
Restrictions when using Direct path Loads...
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Amarnath Reddy, 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.

Ready to start learning?
Take This Course