Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Oracle Analytic Functions In-Depth & Advanced Oracle SQL, available at $94.99, has an average rating of 4.45, with 86 lectures, based on 1635 reviews, and has 9196 subscribers.
You will learn about 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 This course is ideal for individuals who are Students who already know Oracle SQL and they need to move to the next level in advance SQL or Fresh and junior Oracle programmers who need to move to data warehouse path or Oracle programmers who need to learn Oracle Analytic Functions In-Depth It is particularly useful for Students who already know Oracle SQL and they need to move to the next level in advance SQL or Fresh and junior Oracle programmers who need to move to data warehouse path or Oracle programmers who need to learn Oracle Analytic Functions In-Depth.
Enroll now: Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Summary
Title: Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Price: $94.99
Average Rating: 4.45
Number of Lectures: 86
Number of Published Lectures: 86
Number of Curriculum Items: 86
Number of Published Curriculum Objects: 86
Original Price: $199.99
Quality Status: approved
Status: Live
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
Who Should Attend
- Students who already know Oracle SQL and they need to move to the next level in advance SQL
- Fresh and junior Oracle programmers who need to move to data warehouse path
- Oracle programmers who need to learn Oracle Analytic Functions In-Depth
Target Audiences
- Students who already know Oracle SQL and they need to move to the next level in advance SQL
- Fresh and junior Oracle programmers who need to move to data warehouse path
- Oracle programmers who need to learn Oracle Analytic Functions In-Depth
This course is very important for all oracle database programmers especially for programmer who need to move to data warehouse path.
In this course you will learn many advance SQL and you will master Oracle Analytic Functions In-Depth.
This course will make you expert in Reporting and SQL Analytic Functions.
This course is one of the most amazing courses in Oracle SQL.
Be sure that you will learn a unique knowledge in this subject.
The course is 100% practical and full of examples of exercises
Course Curriculum
Chapter 1: Course Preparation
Lecture 1: Chapter Summary
Lecture 2: Oracle 12c /18c Architecture
Lecture 3: Review some Basic commands in 12c / 18c
Lecture 4: Create new pluggable database
Lecture 5: Create the HR Schema
Lecture 6: Navigate the HR Schema
Chapter 2: Grouping and Aggregating Data Using SQL
Lecture 1: Chapter Summary
Lecture 2: Introduction
Lecture 3: Group Functions and Group by part 1
Lecture 4: Group Functions and Group by part 2
Lecture 5: Group Functions and NULLS
Lecture 6: Rollup Part 1
Lecture 7: Rollup Part 2
Lecture 8: Rollup Part 3
Lecture 9: Rollup Part 4
Lecture 10: Cube Part 1
Lecture 11: Cube Part 2
Lecture 12: Cube Part 3
Lecture 13: GROUPING Function Part 1
Lecture 14: GROUPING Function Part 2
Lecture 15: GROUPING Function Part 3
Lecture 16: GROUPING Function Part 4
Lecture 17: The GROUPING_ID function
Lecture 18: GROUPING SETS Part 1
Lecture 19: GROUPING SETS Part 2
Lecture 20: Composite Columns
Lecture 21: Concatenated Groupings
Lecture 22: Solving one task in 4 methods
Chapter 3: Analyzing and Reporting Data Using SQL
Lecture 1: RANK & DENSE_RANK Part 1
Lecture 2: RANK & DENSE_RANK Part 2
Lecture 3: RANK & DENSE_RANK Part 3
Lecture 4: RANK & DENSE_RANK Part 4
Lecture 5: RANK & DENSE_RANK ( Aggregate Syntax )
Lecture 6: PERCENT_RANK Part 1
Lecture 7: PERCENT_RANK Part 2
Lecture 8: PERCENT_RANK Part 3 ( Aggregate Syntax )
Lecture 9: CUME_DIST (cumulative distribution) Part 1
Lecture 10: CUME_DIST (cumulative distribution) Part 2
Lecture 11: LISTAGG function Part 1
Lecture 12: LISTAGG function Part 2
Lecture 13: NTILE function
Lecture 14: ROWNUM & ROW_NUMBER Part 1
Lecture 15: ROWNUM & ROW_NUMBER Part 2
Lecture 16: ROWNUM & ROW_NUMBER Part 3
Lecture 17: LAG & LEAD Functions Part 1
Lecture 18: LAG & LEAD Functions Part 2
Lecture 19: Aggregate functions VS Analytic Part 1 ( Very Important)
Lecture 20: Aggregate functions VS Analytic Part 2 ( Very Important)
Lecture 21: Aggregate functions & windowing clause 1
Lecture 22: Aggregate functions & windowing clause 2
Lecture 23: Aggregate functions & windowing clause 3
Lecture 24: Aggregate functions & windowing clause 4
Lecture 25: Aggregate functions & windowing clause 5
Lecture 26: Aggregate functions & windowing clause 6
Lecture 27: Aggregate functions & windowing clause 7
Lecture 28: Aggregate functions & windowing clause 8
Lecture 29: Aggregate functions & windowing clause 9
Lecture 30: first_value & last_value PART 1
Lecture 31: first_value & last_value PART 2
Lecture 32: first_value & last_value PART 3
Chapter 4: Advanced Oracle SQL
Lecture 1: DBMS_RANDOM part 1
Lecture 2: DBMS_RANDOM part 2
Lecture 3: Using SELECT statement to create dynamic scripts
Lecture 4: Hierarchical Queries Part 1
Lecture 5: Hierarchical Queries Part 2
Lecture 6: Hierarchical Queries Part 3
Lecture 7: Hierarchical Queries Part 4
Lecture 8: Hierarchical Queries Part 5
Lecture 9: DML logs using package dbms_errlog
Lecture 10: create matrix report using PIVOT
Chapter 5: Bonus section- the full installation info
Lecture 1: Course Setup Notes / 4 Options
Lecture 2: Option 2- creating the HR Schema
Lecture 3: Option 3- Part 1 : Oracle Database 12c Architecture
Lecture 4: Option 3- Part 2 : Downloading Oracle DB 12c
Lecture 5: Option 3- Part 3 : Installing Oracle DB 12c
Lecture 6: Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
Lecture 7: Option 3- Part 5: Unlock HR Account Part 1
Lecture 8: Option 3- Part 6 : Unlock HR Account Part 2
Lecture 9: Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
Lecture 10: Option 4- Installing Oracle 11g express Edition + Unlock HR
Lecture 11: HR Schema in this Course
Lecture 12: Navigate HR schema
Lecture 13: oracle 18c express edition part 1 (download and install )
Lecture 14: oracle 18c express edition part 2 (unlock hr )
Lecture 15: oracle 18c express edition part 3 ( sql developer )
Lecture 16: about oracle apex
Instructors
-
Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst
Rating Distribution
- 1 stars: 11 votes
- 2 stars: 16 votes
- 3 stars: 138 votes
- 4 stars: 571 votes
- 5 stars: 899 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple