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.

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.

• Course Introduction 16mins
• Ordering, Sampling, and Random Numbers: Part I 18mins
• Ordering, Sampling, and Random Numbers: Part II 21mins
• Extraction and Insertion: Part I 21mins
• Extraction and Insertion: Part II 24mins
• Extraction and Insertion: Part III 24mins
• Extraction and Insertion: Part IV 32mins
• Nested Tables 36mins
• Computing Intersections and Occurrences: Part I 20mins
• Computing Intersections and Occurrences: Part II 22mins
• The MODEL Feature - Part I 21mins
• The MODEL Feature - Part II 18mins
• The MODEL Feature - Part III 20mins
• Course Summary 19mins