MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Data Wrangling in Oracle: Table Data

Course Summary

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.


  • +

    Course Syllabus

    Course Introduction
    - 16m 48s

    —Introduction 0m 37s
    —Course Overview 1m 9s
    —Course Contents 4m 41s
    —Module Contents 0m 35s
    —Who Will Benefit? 0m 36s
    —Database Version 1m 1s
    —Data Used in Course 5m 23s
    —Reminders of GREAT Resources 1m 58s
    —Summary 0m 43s
    Ordering, Sampling, and Random Numbers: Part I
    - 18m 26s

    —Introduction 0m 23s
    —Module Contents 0m 51s
    —ORDER BY and NULLS 2m 36s
    —DEMO #1 2m 1s
    —FETCH and OFFSET Introduction 2m 24s
    —Limiting Rows With FETCH 1m 48s
    —DEMO #2 1m 14s
    —FETCH and the WITH TIES Keyword 1m 34s
    —Skipping Rows With OFFSET 2m 39s
    —Useful SQL*Plus Commands 1m 38s
    —Summary 1m 12s
    Ordering, Sampling, and Random Numbers: Part II
    - 21m 5s
    Extraction and Insertion: Part I
    - 21m 48s
    Extraction and Insertion: Part II
    - 24m 31s
    Extraction and Insertion: Part III
    - 24m 46s
    Extraction and Insertion: Part IV
    - 32m 35s
    Nested Tables
    - 36m 11s
    Computing Intersections and Occurrences: Part I
    - 20m 7s
    Computing Intersections and Occurrences: Part II
    - 22m 8s
    The MODEL Feature - Part I
    - 21m 34s
    The MODEL Feature - Part II
    - 18m 30s
    The MODEL Feature - Part III
    - 20m 12s
    Course Summary
    - 19m 23s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top