SQL Data Wrangling in Oracle: Table Data

This course describes Oracle functionality useful to the SQL-savvy data analyst, and features topics such as CROSS and OUTER APPLY, using the MODEL feature, using Nested Tables, computing occurrences, generating random numbers, and much, much more.
Course info
Rating
(36)
Level
Intermediate
Updated
Nov 27, 2014
Duration
5h 18m
Table of contents
Course Introduction
Ordering, Sampling, and Random Numbers: Part I
Ordering, Sampling, and Random Numbers: Part II
Extraction and Insertion: Part I
Extraction and Insertion: Part II
Extraction and Insertion: Part III
Extraction and Insertion: Part IV
Nested Tables
Computing Intersections and Occurrences: Part I
Computing Intersections and Occurrences: Part II
The MODEL Feature - Part I
The MODEL Feature - Part II
The MODEL Feature - Part III
Course Summary
Description
Course info
Rating
(36)
Level
Intermediate
Updated
Nov 27, 2014
Duration
5h 18m
Description

This course describes Oracle functionality useful to the SQL-savvy data analyst, and features topics such as ordering your data with NULLs appearing first or last, using FETCH to subset your data, using SAMPLE to randomly sample from a table, using CROSS APPLY and OUTER APPLY, how to use the MODEL feature to access the rows and columns of a database table like a spreadsheet, generating random numbers, computing occurrences, using nested tables, and much, more.

About the author
About the author

Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!

More from the author
Optimizing SQL Queries in Oracle
Intermediate
3h 46m
15 Apr 2014
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
14 Jan 2014
Section Introduction Transcripts
Section Introduction Transcripts

Course Introduction
Hello, and welcome to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this course I'll be discussing useful Oracle functionality that SQL savvy data analysts, as well as SQL programmers will appreciate. We'll cover everything from the simple, such as ordering your data with a NULLS either first or last, how to compute occurrences in your data, as well as generating random numbers to the much more complex, like the MODEL feature, which allows you to work with the database table as if it were a spreadsheet, how to use nested tables, how to use SQL Loader, and much, much more. So let's get started.

Ordering, Sampling, and Random Numbers: Part I
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module, I'll be discussing Oracle functionality which allows you to order your data with the NULLs appearing at the top, or the bottom of your query results, and how to use FETCH and OFFSET to subset your data. So let's get started.

Ordering, Sampling, and Random Numbers: Part II
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module, the second of two on Ordering, Sampling, and Random Numbers, I'll be discussing how to randomly sample your data using the SAMPLE keyword, and the ORA_HASH function, as well as how to generate random numbers using the DBMS_RANDOM package. So, let's get started.

Extraction and Insertion: Part I
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing Oracle functionality which allows efficient extraction of data from, and addition of data to database tables. Specifically, we'll concentrate on Oracle's extension to the IN condition, as well as multi-table INSERTs. So, let's get started.

Extraction and Insertion: Part II
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing CROSS APPLY, OUTER APPLY, and for my SAS programmers out there, and I know you're out there, we'll talk briefly about how to efficiently pull data from, and insert data into Oracle using SAS/ACCESS. So, let's get started.

Extraction and Insertion: Part III
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing how to use Oracle SQL*Loader functionality, which allows you to efficiently load data into a database table. So, let's get started.

Extraction and Insertion: Part IV
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module we continue our discussion of Oracle SQL Loader, and look into each control file section in detail. So, let's get started.

Nested Tables
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing Nested Tables, and how to work with them. Although this is a very esoteric topic, nested table data types are used with the procedures in the DBMS_FREQUENT_ITEMSET package, which we'll see later on in the module on computing occurrences. So, let's get started.

Computing Intersections and Occurrences: Part I
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing how to compute intersections for things like Venn diagrams using two different, but equivalent methods. So, let's get started.

Computing Intersections and Occurrences: Part II
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module I'll be discussing how to compute occurrences using the procedures available in the DBMS_FREQUENT_ITEMSET package, so let's get started.

The MODEL Feature - Part I
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module, I'll be discussing the MODEL feature, which allows you to treat a database table like an Excel spreadsheet, all from SQL code. This is module one of three, so let's get started.

The MODEL Feature - Part II
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module we continue our discussion of the MODEL feature by looking into some intermediate features of the MODEL clause. So, let's get started.

The MODEL Feature - Part III
Hello, and welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and in this module, we'll conclude our discussion of the MODEL feature by showing some of the more advanced features. So, let's get started.

Course Summary
Welcome back to the Pluralsight course, SQL Data Wrangling in Oracle: Table Data. My name is Scott Hecht, and if you've made it this far without your eyes bleeding, you are to be congratulated! In this module we'll briefly summarize the entire course, so let's get started.