SQL Data Wrangling in Oracle: Table Data

Pluralsight

Course Features

Duration

5.27 hours

Delivery Method

Online

Available on

Downloadable Courses

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Effort

5 hours per week

Teaching Type

Self Paced

Video Content

5.27 hours

Course Description

This course explains Oracle functionality that is useful for the SQL-savvy data analyst. It also features topics like ordering your data with NULLs appearing last or first, using FETCH and SAMPLE to randomly select from a table, using Cross APPLY and Outer APPLY, how you can use MODEL to access rows and columns in a database table just like a spreadsheet, how to generate random numbers, computing occurrences and using nested table.

Course Overview

International Faculty

Case Based Learning

Post Course Interactions

Case Studies,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Ordering, Sampling, and Random Numbers

Extraction and Insertion

Nested Tables

Computing Intersections and Occurrences

The MODEL Feature

Course Content

Expand all sections

Module 1: Ordering, Sampling, and Random Numbers: Part I

1. Introduction

2. moduleContents

3. ORDER BY and NULLS

4. DEMO #1

5. FETCH and OFFSET Introduction

6. Limiting Rows With FETCH

7. DEMO #2

8. FETCH and the WITH TIES Keyword

9. Skipping Rows With OFFSET

10. Useful SQLPlus Commands

11. Summary

Module 2: Ordering, Sampling, and Random Numbers: Part II

Module 3: Extraction and Insertion: Part I

Module 4: Extraction and Insertion: Part II

Course Instructors

Scott Hecht

Instructor

Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, she...