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
- Descrição
- Currículo
- FAQ
- Revisões
Tempo de leitura less than a minute
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
Grouping and Aggregating Data Using SQL
Analyzing and Reporting Data Using SQL
-
7
Chapter Summary -
8
Introduction
-
9
Group Functions and Group by part 1
-
10
Group Functions and Group by part 2
-
11
Group Functions and NULLS
-
12
Rollup Part 1
-
13
Rollup Part 2
-
14
Rollup Part 3
-
15
Rollup Part 4
-
16
Cube Part 1
-
17
Cube Part 2
-
18
Cube Part 3
-
19
GROUPING Function Part 1
-
20
GROUPING Function Part 2
-
21
GROUPING Function Part 3
-
22
GROUPING Function Part 4
-
23
The GROUPING_ID function
-
24
GROUPING SETS Part 1
-
25
GROUPING SETS Part 2
-
26
Composite Columns
-
27
Concatenated Groupings
-
28
Solving one task in 4 methods
Advanced Oracle SQL
-
29
RANK & DENSE_RANK Part 1
-
30
RANK & DENSE_RANK Part 2
-
31
RANK & DENSE_RANK Part 3
-
32
RANK & DENSE_RANK Part 4
-
33
RANK & DENSE_RANK ( Aggregate Syntax )
-
34
PERCENT_RANK Part 1
-
35
PERCENT_RANK Part 2
-
36
PERCENT_RANK Part 3 ( Aggregate Syntax )
-
37
CUME_DIST (cumulative distribution) Part 1
-
38
CUME_DIST (cumulative distribution) Part 2
-
39
LISTAGG function Part 1
-
40
LISTAGG function Part 2
-
41
NTILE function
-
42
ROWNUM & ROW_NUMBER Part 1
-
43
ROWNUM & ROW_NUMBER Part 2
-
44
ROWNUM & ROW_NUMBER Part 3
-
45
LAG & LEAD Functions Part 1
-
46
LAG & LEAD Functions Part 2
-
47
Aggregate functions VS Analytic Part 1 ( Very Important)
-
48
Aggregate functions VS Analytic Part 2 ( Very Important)
-
49
Aggregate functions & windowing clause 1
-
50
Aggregate functions & windowing clause 2
-
51
Aggregate functions & windowing clause 3
-
52
Aggregate functions & windowing clause 4
-
53
Aggregate functions & windowing clause 5
-
54
Aggregate functions & windowing clause 6
-
55
Aggregate functions & windowing clause 7
-
56
Aggregate functions & windowing clause 8
-
57
Aggregate functions & windowing clause 9
-
58
first_value & last_value PART 1
-
59
first_value & last_value PART 2
-
60
first_value & last_value PART 3
Bonus section- the full installation info
-
61
DBMS_RANDOM part 1
-
62
DBMS_RANDOM part 2
-
63
Using SELECT statement to create dynamic scripts
-
64
Hierarchical Queries Part 1
-
65
Hierarchical Queries Part 2
-
66
Hierarchical Queries Part 3
-
67
Hierarchical Queries Part 4
-
68
Hierarchical Queries Part 5
-
69
DML logs using package dbms_errlog
-
70
create matrix report using PIVOT
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!
Estrelas 5
954
Estrelas 4
612
Estrelas 3
143
Estrelas 2
17
Estrelas 1
11
Course details
Vídeo
9 hours
Sessões de Formação
1
Certificate of Completion
Popular courses
