50,000+ Free Courses Online to Start Today

Coursesity is supported by learner community. We may earn affiliate commission when you make purchase via links on Coursesity.

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.

Free Trial

Go to Course SAVE

Course Overview
Reviews

Description

In this course, you will :

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.