+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Free Oracle APEX Tutorials

    • Home
    • All courses
    • Free Oracle APEX Tutorials
    • Advanced Oracle SQL Aggregations for Data Warehouse – Free Tutorial

    Advanced Oracle SQL Aggregations for Data Warehouse – Free Tutorial
    Duration: 50 hours

    John Watson
    Free Oracle APEX Tutorials, Free Oracle DBA Tutorials, Free Oracle Developer Tutorials

    No reviews yet.
    Free
    • Description
    • Lessons
    • Topic Summary
    • Instructors
    • Reviews

    How to Query an Oracle Data Warehouse with Advanced Aggregations (LISTAGG, FIRST, LAST, ROLLUP, Cube and more).

    The original SQL language focused on providing standard selection, projection, and sorting of data. Enhancements over the years allow SQL to deliver much more robust analysis of data. This webinar investigates how LISTAGG, FIRST, LAST, Rollup, Cube, Grouping Functions, and Grouping Sets provide these capabilities, typically used in Data Warehouse environments.

    After a brief review, we will show how these features allow you to concatenate values of a measure column into a single output column for a GROUP, add subtotals and grand totals to a report of summary data, extend the generation of subtotals across multiple dimensions, provide meaningful labels for subtotals and grand total rows, and limit subtotals to only those that you need for your reporting. These features are particularly useful to generate reports (from a data warehouse) tailored to specific user needs without having to use inefficient workarounds.

    Audience: Oracle and APEX developers who want to improve their SQL skills. A basic foundation in SQL is required.

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

  • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.
    • Share:
    • Tutorial Lessons 0/7

      • Lecture1.1
        Agenda
        0m
      • Lecture1.2
        Introduction to Oracle LISTAGG Function
        Preview
        4m
      • Lecture1.3
        Oracle LISTAGG Examples and Demonstration
        9m
      • Lecture1.4
        How to Code FIRST and LAST Aggregate Functions
        7m
      • Lecture1.5
        How to use ROLLUP and CUBE
        6m
      • Lecture1.6
        Using the GROUPING Function
        6m
      • Lecture1.7
        Using GROUPING SETS
        2m
    John Watson
    https://skillbuilders.com/our_team/john-watson/

    Please take this tutorial in order to review.

    No reviews yet.

    • Description
    • Curriculum
    • Topic Summary
    • Instructors
    • Reviews
    Free

    Recommended Courses

    • Advanced SQL Queries for Oracle Databases
       4.7/5 (144)
      Geoffrey Wiland
    • Introduction to Oracle Database and SQL
       4.7/5 (28)
      Geoffrey Wiland
    • When to use Oracle Bitmap Indexes, Tips for Data Warehouse – Free Tutorial
      No reviews yet.
      John Watson

    Featured Courses

    Backup and Recovery with Oracle RMAN

    January 25, 2021
    $2,700.00

    Oracle PL/SQL Programming Workshop

    January 25, 2021
    $2,700.00

    Intermediate Oracle Application Express (APEX) Training

    January 25, 2021
    $2,700.00

    Oracle Database: Managing Multitenant Architecture

    February 1, 2021
    $2,100.00

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.

    Register for this Class
    • Please enter a number from 2 to 5000.