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
November 27, 2014
Duration
5h 18m
Table of contents
Nested Tables
36m 11s
Course Summary
19m 23s
Description
Course info
Rating
(36)
Level
Intermediate
Updated
November 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