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

1 - Course Preparation

1 - Chapter Summary

1 - Course-Preparation.pdf

2 - Oracle 12c 18c Architecture

3 - Review some Basic commands in 12c 18c

3 - chapter-ex1.zip

4 - Create new pluggable database

5 - Create the HR Schema

5 - chapter-ex2.zip

5 - create-hr-tables.zip

6 - Navigate the HR Schema

2 - Grouping and Aggregating Data Using SQL

7 - Chapter Summary

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

8 - Introduction

9 - Group Functions and Group by part 1

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

10 - Group Functions and Group by part 2

11 - Group Functions and NULLS

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

12 - Rollup Part 1

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

13 - Rollup Part 2

13 - Rollup-desc.xlsx

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

14 - Rollup Part 3

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

15 - Rollup Part 4

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

16 - Cube Part 1

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

17 - Cube Part 2

18 - Cube Part 3

18 - Rollup-vs-Cube.xlsx

19 - GROUPING Function Part 1

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

20 - GROUPING Function Part 2

21 - GROUPING Function Part 3

22 - GROUPING Function Part 4

23 - The GROUPINGID function

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

24 - GROUPING SETS Part 1

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

25 - GROUPING SETS Part 2

26 - Composite Columns

26 - Composite-Columns.xlsx

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

27 - Concatenated Groupings

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

28 - Solving one task in 4 methods

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

3 - Analyzing and Reporting Data Using SQL

29 - RANK & DENSERANK Part 1

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

30 - RANK & DENSERANK Part 2

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

31 - RANK & DENSERANK Part 3

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

32 - RANK & DENSERANK Part 4

33 - RANK & DENSERANK Aggregate Syntax

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

34 - PERCENTRANK Part 1

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

35 - PERCENTRANK Part 2

36 - PERCENTRANK Part 3 Aggregate Syntax

37 - CUMEDIST cumulative distribution Part 1

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

38 - CUMEDIST cumulative distribution Part 2

39 - LISTAGG function Part 1

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

40 - LISTAGG function Part 2

41 - NTILE function

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

42 - ROWNUM & ROWNUMBER Part 1

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

43 - ROWNUM & ROWNUMBER Part 2

44 - ROWNUM & ROWNUMBER Part 3

45 - LAG & LEAD Functions Part 1

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

46 - LAG & LEAD Functions Part 2

47 - Aggregate functions VS Analytic Part 1 Very Important

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

48 - Aggregate functions VS Analytic Part 2 Very Important

49 - Aggregate functions & windowing clause 1

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

50 - Aggregate functions & windowing clause 2

51 - Aggregate functions & windowing clause 3

52 - Aggregate functions & windowing clause 4

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

53 - Aggregate functions & windowing clause 5

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

54 - Aggregate functions & windowing clause 6

55 - Aggregate functions & windowing clause 7

56 - Aggregate functions & windowing clause 8

57 - Aggregate functions & windowing clause 9

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

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

58 - firstvalue & lastvalue PART 1

59 - firstvalue & lastvalue PART 2

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

60 - firstvalue & lastvalue PART 3

4 - Advanced Oracle SQL

61 - DBMSRANDOM part 1

61 - random.zip

62 - DBMSRANDOM part 2

63 - Using SELECT statement to create dynamic scripts

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

64 - Hierarchical Queries Part 1

64 - tree-sample.zip

65 - Hierarchical Queries Part 2

65 - tree.xlsx

65 - tree.zip

66 - Hierarchical Queries Part 3

67 - Hierarchical Queries Part 4

68 - Hierarchical Queries Part 5

68 - tree2.zip

69 - DML logs using package dbmserrlog

69 - dbms-errlog.zip

70 - create matrix report using PIVOT

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

5 - Bonus section the full installation info

71 - Course Setup Notes 4 Options

71 - course-setup.pdf

72 - Option 2 creating the HR Schema

72 - create-hr-tables.zip

72 - create-hr-user.zip

73 - Option 3 Part 1 Oracle Database 12c Architecture

74 - Option 3 Part 2 Downloading Oracle DB 12c

75 - Option 3 Part 3 Installing Oracle DB 12c

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

77 - Option 3 Part 5 Unlock HR Account Part 1

78 - Option 3 Part 6 Unlock HR Account Part 2

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

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

81 - HR Schema in this Course

82 - Navigate HR schema

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

84 - oracle 18c express edition part 2 unlock hr

85 - oracle 18c express edition part 3 sql developer

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training