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
OpenLearning Ad

Future-Proof Your Career: AI Manager Masterclass

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates


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.