Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached
4.55 (1778 reviews)
9 843
students
9.5 hours
content
May 2024
last update
$84.99
regular price
What you will learn
Use SQL with aggregation operators.
SQL for Analysis and Reporting functions
Group and aggregate data using the ROLLUP and CUBE operators
The GROUPING function
Composite Columns and the concatenated Groupings
RANK & DENSE_RANK
PERCENT_RANK
CUME_DIST (cumulative distribution)
The LAG/LEAD Functions
LISTAGG function
Aggregate functions VS Analytic Part
Aggregate functions & windowing clause In-Depth
Moving Average and running totals
ROWNUM & ROW_NUMBER
Advanced Oracle SQL
And much more
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
Oracle Analytic Functions In-Depth & Advanced Oracle SQL is a valuable resource for professionals seeking to expand their SQL knowledge. The instructor's engaging teaching style, coupled with clear examples, helps demystify advanced analytical and aggregation techniques. However, prepare to supplement the course with independent exercises and additional research for more comprehensive mastery.
What We Liked
- Covers advanced SQL concepts with clear examples
- Instructor explains complex topics in a simple and engaging manner
- Downloadable scripts are helpful for hands-on practice
- Well-prepared instructor, easy to understand despite minor accent
Potential Drawbacks
- Some topics could benefit from deeper exploration
- Occasional repetition of content might slow down learning progress
- Lack of independent exercises and solutions within the course
- Dense presentation style requires careful note-taking during lectures
Related Topics
1757576
udemy ID
20/06/2018
course created date
22/11/2019
course indexed date
Bot
course submited by