Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached
Created by: Khaled Alkhudari
Produced in 2021
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
- 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
Overall Score : 92 / 100
Live Chat with CourseDuck's Co-Founder for Help
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 exercisesWho this course is for:
- 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
My name is Khaled Al Khudari, I graduatedin 2003 in computer science.
I have more than 12 years'experience in oracle development, I worked many projects with the bestcompanies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others )
I HaveMany Certifications ( OCA, OCP, Oracle ERP certifications and many others )
I have big experience inOracle ERP modules and data migration, and I have experience in Education systemlike Banner, People soft and desire tolearn .
Ibelieve in success through hard work & dedication.
My motto in life is: If you wantsomething, work hard & you will achieve it; there are no short cuts'.
Students also recommend
0.0 (0 Reviews)
- Provider: Manning Publications
- Time: 4h
4.7 (6 Reviews)
- Provider: SQLBolt
0.0 (0 Reviews)
- Provider: Khan Academy
- Time: 1h