Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Focused View

Khaled Alkhudari

9:20:47

109 View

1 - Course Preparation

1 - Chapter Summary.mp4

02:04

1 - Course-Preparation.pdf

2 - Oracle 12c 18c Architecture.mp4

05:02

3 - Review some Basic commands in 12c 18c.mp4

06:09

3 - chapter-ex1.zip

4 - Create new pluggable database.mp4

04:01

5 - Create the HR Schema.mp4

07:24

5 - chapter-ex2.zip

5 - create-hr-tables.zip

6 - Navigate the HR Schema.mp4

04:25

2 - Grouping and Aggregating Data Using SQL

7 - Chapter Summary.mp4

01:01

7 - Grouping-and-Aggregating-Data-Using-SQL.pdf

8 - Introduction.mp4

02:46

9 - Group Functions and Group by part 1.mp4

07:40

9 - grouping-and-aggregating-data-using-sql-1.zip

10 - Group Functions and Group by part 2.mp4

06:40

11 - Group Functions and NULLS.mp4

03:16

11 - grouping-and-aggregating-data-using-sql-2.zip

12 - Rollup Part 1.mp4

10:29

12 - grouping-and-aggregating-data-using-sql-3.zip

13 - Rollup Part 2.mp4

07:50

13 - Rollup-desc.xlsx

13 - grouping-and-aggregating-data-using-sql-4.zip

14 - Rollup Part 3.mp4

06:22

14 - grouping-and-aggregating-data-using-sql-5.zip

15 - Rollup Part 4.mp4

09:01

15 - grouping-and-aggregating-data-using-sql-6.zip

16 - Cube Part 1.mp4

03:55

16 - grouping-and-aggregating-data-using-sql-7.zip

17 - Cube Part 2.mp4

07:21

18 - Cube Part 3.mp4

05:14

18 - Rollup-vs-Cube.xlsx

19 - GROUPING Function Part 1.mp4

07:39

19 - grouping-and-aggregating-data-using-sql-8.zip

20 - GROUPING Function Part 2.mp4

04:49

21 - GROUPING Function Part 3.mp4

07:19

22 - GROUPING Function Part 4.mp4

04:43

23 - The GROUPINGID function.mp4

07:31

23 - grouping-and-aggregating-data-using-sql-9.zip

24 - GROUPING SETS Part 1.mp4

09:32

24 - grouping-and-aggregating-data-using-sql10.zip

25 - GROUPING SETS Part 2.mp4

03:29

26 - Composite Columns.mp4

06:18

26 - Composite-Columns.xlsx

26 - grouping-and-aggregating-data-using-sql11.zip

27 - Concatenated Groupings.mp4

04:23

27 - grouping-and-aggregating-data-using-sql12.zip

28 - Solving one task in 4 methods.mp4

06:22

28 - grouping-and-aggregating-data-using-sql13.zip

3 - Analyzing and Reporting Data Using SQL

29 - RANK & DENSERANK Part 1.mp4

12:25

29 - analyzing-and-reporting-data-using-sql-1.zip

30 - RANK & DENSERANK Part 2.mp4

04:22

30 - analyzing-and-reporting-data-using-sql-2.zip

31 - RANK & DENSERANK Part 3.mp4

08:49

31 - analyzing-and-reporting-data-using-sql-3.zip

32 - RANK & DENSERANK Part 4.mp4

05:40

33 - RANK & DENSERANK Aggregate Syntax.mp4

07:27

33 - analyzing-and-reporting-data-using-sql-4.zip

34 - PERCENTRANK Part 1.mp4

08:00

34 - analyzing-and-reporting-data-using-sql-5.zip

35 - PERCENTRANK Part 2.mp4

05:01

36 - PERCENTRANK Part 3 Aggregate Syntax.mp4

10:05

37 - CUMEDIST cumulative distribution Part 1.mp4

08:34

37 - analyzing-and-reporting-data-using-sql-6.zip

38 - CUMEDIST cumulative distribution Part 2.mp4

05:06

39 - LISTAGG function Part 1.mp4

04:56

39 - analyzing-and-reporting-data-using-sql-7.zip

40 - LISTAGG function Part 2.mp4

07:11

41 - NTILE function.mp4

06:07

41 - analyzing-and-reporting-data-using-sql-8.zip

42 - ROWNUM & ROWNUMBER Part 1.mp4

06:27

42 - analyzing-and-reporting-data-using-sql-9.zip

43 - ROWNUM & ROWNUMBER Part 2.mp4

04:13

44 - ROWNUM & ROWNUMBER Part 3.mp4

07:30

45 - LAG & LEAD Functions Part 1.mp4

06:44

45 - analyzing-and-reporting-data-using-sql-10.zip

46 - LAG & LEAD Functions Part 2.mp4

08:28

47 - Aggregate functions VS Analytic Part 1 Very Important.mp4

07:16

47 - analyzing-and-reporting-data-using-sql-11.zip

48 - Aggregate functions VS Analytic Part 2 Very Important.mp4

11:01

49 - Aggregate functions & windowing clause 1.mp4

08:55

49 - analyzing-and-reporting-data-using-sql-12.zip

50 - Aggregate functions & windowing clause 2.mp4

07:11

51 - Aggregate functions & windowing clause 3.mp4

07:19

52 - Aggregate functions & windowing clause 4.mp4

09:45

52 - analyzing-and-reporting-data-using-sql-13.zip

53 - Aggregate functions & windowing clause 5.mp4

08:34

53 - analyzing-and-reporting-data-using-sql-14.zip

54 - Aggregate functions & windowing clause 6.mp4

03:06

55 - Aggregate functions & windowing clause 7.mp4

05:23

56 - Aggregate functions & windowing clause 8.mp4

05:04

57 - Aggregate functions & windowing clause 9.mp4

06:43

57 - analyzing-and-reporting-data-using-sql-15.zip

58 - analyzing-and-reporting-data-using-sql-16.zip

58 - firstvalue & lastvalue PART 1.mp4

06:43

59 - firstvalue & lastvalue PART 2.mp4

03:29

60 - analyzing-and-reporting-data-using-sql-17.zip

60 - firstvalue & lastvalue PART 3.mp4

03:55

4 - Advanced Oracle SQL

61 - DBMSRANDOM part 1.mp4

06:09

61 - random.zip

62 - DBMSRANDOM part 2.mp4

05:09

63 - Using SELECT statement to create dynamic scripts.mp4

06:34

63 - using-select-statement-to-create-dynamic-scripts.zip

64 - Hierarchical Queries Part 1.mp4

03:45

64 - tree-sample.zip

65 - Hierarchical Queries Part 2.mp4

06:50

65 - tree.xlsx

65 - tree.zip

66 - Hierarchical Queries Part 3.mp4

07:35

67 - Hierarchical Queries Part 4.mp4

08:46

68 - Hierarchical Queries Part 5.mp4

07:15

68 - tree2.zip

69 - DML logs using package dbmserrlog.mp4

08:28

69 - dbms-errlog.zip

70 - create matrix report using PIVOT.mp4

06:06

70 - create-matrix-report-using-pivot.zip

5 - Bonus section the full installation info

71 - Course Setup Notes 4 Options.mp4

04:32

71 - course-setup.pdf

72 - Option 2 creating the HR Schema.mp4

07:34

72 - create-hr-tables.zip

72 - create-hr-user.zip

73 - Option 3 Part 1 Oracle Database 12c Architecture.mp4

05:02

74 - Option 3 Part 2 Downloading Oracle DB 12c.mp4

03:42

75 - Option 3 Part 3 Installing Oracle DB 12c.mp4

09:16

76 - Option 3 Part 4 Connecting SYS using SQL plus & SQL Developer.mp4

10:40

77 - Option 3 Part 5 Unlock HR Account Part 1.mp4

04:30

78 - Option 3 Part 6 Unlock HR Account Part 2.mp4

11:50

79 - Option 3 Part 7 ORA01033 oracle initialization or shutdown in progress 12c.mp4

03:33

80 - Option 4 Installing Oracle 11g express Edition Unlock HR.mp4

10:21

81 - HR Schema in this Course.mp4

04:34

82 - Navigate HR schema.mp4

07:05

83 - oracle 18c express edition part 1 download and install.mp4

08:59

84 - oracle 18c express edition part 2 unlock hr.mp4

11:32

85 - oracle 18c express edition part 3 sql developer.mp4

06:46

Description

Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached

What You'll 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 is this 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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

Khaled Alkhudari

Instructor's 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’.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.