Oracle Analytic Functions In-Depth & Advanced Oracle SQL

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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

Who 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

Instructor

Sr Oracle Developer/ Sr system analyst
  • 4.5 Instructor Rating
  • 9,188 Reviews
  • 34,222 Students
  • 7 Courses

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.



Expected Outcomes

  1. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  2. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  3. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  4. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  5. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  6. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  7. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  8. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677770770e75066a',m:'d1ccdc473d0350794760297010b7ff345029de1d-1627740933-1800-AaIbyUQAy/ySOni+XaRw3mYFChTK8hZ23ZrCsm2/8/azwZ3SQh6PTF6gV0bdAtpdsN9fz3IqH6ZpZRcps/iANA/BbkJIET7xwSUukzVkovP9X0o3rOEhvWGRfGqGykG6AA78NmcGTRvDOz0ySiJ2YLwcl77j8uypXjKegd9IIfDR',s:[0x15c00f40fc,0x0b605d9b01],}})();
  9. 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 Show more Show less Curated for the Udemy Business collection Course content 5 sections • 85 lectures • 9h 20m total length Expand all sections Course Preparation 6 lectures • 29min Chapter Summary Preview 02:04 Oracle 12c /18c Architecture Preview 05:02 Review some Basic commands in 12c / 18c Preview 06:09 Create new pluggable database 04:00 Create the HR Schema 07:24 Navigate the HR Schema 04:25 Grouping and Aggregating Data Using SQL 22 lectures • 2hr 14min Chapter Summary 01:01 Introduction 02:46 Group Functions and Group by part 1 Preview 07:40 Group Functions and Group by part 2 06:39 Group Functions and NULLS 03:16 Rollup Part 1 Preview 10:28 Rollup Part 2 07:50 Rollup Part 3 06:22 Rollup Part 4 09:01 Cube Part 1 03:55 Cube Part 2 07:21 Cube Part 3 05:14 GROUPING Function Part 1 07:38 GROUPING Function Part 2 04:49 GROUPING Function Part 3 07:19 GROUPING Function Part 4 04:43 The GROUPING_ID function 07:31 GROUPING SETS Part 1 09:32 GROUPING SETS Part 2 03:29 Composite Columns 06:18 Concatenated Groupings 04:23 Solving one task in 4 methods 06:22 Analyzing and Reporting Data Using SQL 32 lectures • 3hr 41min RANK & DENSE_RANK Part 1 12:25 RANK & DENSE_RANK Part 2 04:22 RANK & DENSE_RANK Part 3 08:49 RANK & DENSE_RANK Part 4 05:40 RANK & DENSE_RANK ( Aggregate Syntax ) 07:27 PERCENT_RANK Part 1 08:00 PERCENT_RANK Part 2 05:01 PERCENT_RANK Part 3 ( Aggregate Syntax ) 10:05 CUME_DIST (cumulative distribution) Part 1 08:34 CUME_DIST (cumulative distribution) Part 2 05:06 LISTAGG function Part 1 04:55 LISTAGG function Part 2 07:11 NTILE function 06:07 ROWNUM & ROW_NUMBER Part 1 06:27 ROWNUM & ROW_NUMBER Part 2 04:13 ROWNUM & ROW_NUMBER Part 3 07:30 LAG & LEAD Functions Part 1 06:44 LAG & LEAD Functions Part 2 08:27 Aggregate functions VS Analytic Part 1 ( Very Important) 07:16 Aggregate functions VS Analytic Part 2 ( Very Important) 11:01 Aggregate functions & windowing clause 1 08:55 Aggregate functions & windowing clause 2 07:11 Aggregate functions & windowing clause 3 07:18 Aggregate functions & windowing clause 4 09:45 Aggregate functions & windowing clause 5 08:34 Aggregate functions & windowing clause 6 03:06 Aggregate functions & windowing clause 7 05:23 Aggregate functions & windowing clause 8 05:04 Aggregate functions & windowing clause 9 06:43 first_value & last_value PART 1 06:43 first_value & last_value PART 2 03:29 first_value & last_value PART 3 03:55 Advanced Oracle SQL 10 lectures • 1hr 7min DBMS_RANDOM part 1 06:08 DBMS_RANDOM part 2 05:09 Using SELECT statement to create dynamic scripts 06:34 Hierarchical Queries Part 1 03:45 Hierarchical Queries Part 2 06:50 Hierarchical Queries Part 3 07:35 Hierarchical Queries Part 4 08:46 Hierarchical Queries Part 5 07:15 DML logs using package dbms_errlog 08:28 create matrix report using PIVOT 06:06 Bonus section- the full installation info 15 lectures • 1hr 50min Course Setup Notes / 4 Options 04:32 Option 2- creating the HR Schema 07:34 Option 3- Part 1 : Oracle Database 12c Architecture 05:02 Option 3- Part 2 : Downloading Oracle DB 12c 03:42 Option 3- Part 3 : Installing Oracle DB 12c 09:16 Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer 10:39 Option 3- Part 5: Unlock HR Account Part 1 04:30 Option 3- Part 6 : Unlock HR Account Part 2 11:49 Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c 03:33 Option 4- Installing Oracle 11g express Edition + Unlock HR 10:21 HR Schema in this Course 04:34 Navigate HR schema 07:05 oracle 18c express edition part 1 (download and install ) 08:59 oracle 18c express edition part 2 (unlock hr ) 11:32 oracle 18c express edition part 3 ( sql developer ) 06:46 Requirements Familiarity with SQL Good working knowledge of the SQL language Familiarity with Oracle SQL Developer and SQL*Plus This course is not for beginners, do not take this course if you have no experience in SQL Downloading oracle database and this will be covered in details on Windows OS. Description 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 Who 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 Show more Show less Instructor Khaled Alkhudari Sr Oracle Developer/ Sr system analyst 4.5 Instructor Rating 9,188 Reviews 34,222 Students 7 Courses My name is Khaled Al Khudari, I graduated in 2003 in computer science. I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others ) I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others ) I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn . I believe in success through hard work & dedication. My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’. Show more Show less