Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Data Wrangling in Oracle: Table Data

via Pluralsight

Write review
Great Learning Ad

Foundations of Data Visualization - Self Paced Online

Learn More → Corporate Finance Institute Ad

Finance Certifications Goldman Sachs & Amazon Teams Trust

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access


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.

Syllabus

  • 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

Taught by

Scott Hecht

Reviews

4.4 rating at Pluralsight based on 47 ratings

Start your review of SQL Data Wrangling in Oracle: Table Data

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.