Pluralsight - SQL Data Wrangling in Oracle: Table Data
27 Nov 2014 | .MP4, x264, 1024x768 | English, AAC, 2 Ch | 5 hrs 18 mins | 624 MB
Instructor: Scott Hecht | Level: Intermediate
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.
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
Click my nick to see more my articles