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