Course Preparation
- Chapter Summary
- Oracle 12c /18c Architecture
- Review some Basic commands in 12c / 18c
- Create new pluggable database
- Create the HR Schema
- Navigate the HR Schema
Grouping and Aggregating Data Using SQL
- Chapter Summary
- Introduction
- Group Functions and Group by part 1
- Group Functions and Group by part 2
- Group Functions and NULLS
- Rollup Part 1
- Rollup Part 2
- Rollup Part 3
- Rollup Part 4
- Cube Part 1
- Cube Part 2
- Cube Part 3
- GROUPING Function Part 1
- GROUPING Function Part 2
- GROUPING Function Part 3
- GROUPING Function Part 4
- The GROUPING_ID function
- GROUPING SETS Part 1
- GROUPING SETS Part 2
- Composite Columns
- Concatenated Groupings
- Solving one task in 4 methods
Analyzing and Reporting Data Using SQL
- RANK & DENSE_RANK Part 1
- RANK & DENSE_RANK Part 2
- RANK & DENSE_RANK Part 3
- RANK & DENSE_RANK Part 4
- RANK & DENSE_RANK ( Aggregate Syntax )
- PERCENT_RANK Part 1
- PERCENT_RANK Part 2
- PERCENT_RANK Part 3 ( Aggregate Syntax )
- CUME_DIST (cumulative distribution) Part 1
- CUME_DIST (cumulative distribution) Part 2
- LISTAGG function Part 1
- LISTAGG function Part 2
- NTILE function
- ROWNUM & ROW_NUMBER Part 1
- ROWNUM & ROW_NUMBER Part 2
- ROWNUM & ROW_NUMBER Part 3
- LAG & LEAD Functions Part 1
- LAG & LEAD Functions Part 2
- Aggregate functions VS Analytic Part 1 ( Very Important)
- Aggregate functions VS Analytic Part 2 ( Very Important)
- Aggregate functions & windowing clause 1
- Aggregate functions & windowing clause 2
- Aggregate functions & windowing clause 3
- Aggregate functions & windowing clause 4
- Aggregate functions & windowing clause 5
- Aggregate functions & windowing clause 6
- Aggregate functions & windowing clause 7
- Aggregate functions & windowing clause 8
- Aggregate functions & windowing clause 9
- first_value & last_value PART 1
- first_value & last_value PART 2
- first_value & last_value PART 3
Advanced Oracle SQL
- DBMS_RANDOM part 1
- DBMS_RANDOM part 2
- Using SELECT statement to create dynamic scripts
- Hierarchical Queries Part 1
- Hierarchical Queries Part 2
- Hierarchical Queries Part 3
- Hierarchical Queries Part 4
- Hierarchical Queries Part 5
- DML logs using package dbms_errlog
- create matrix report using PIVOT
Bonus section- the full installation info
- Course Setup Notes / 4 Options
- Option 2- creating the HR Schema
- Option 3- Part 1 : Oracle Database 12c Architecture
- Option 3- Part 2 : Downloading Oracle DB 12c
- Option 3- Part 3 : Installing Oracle DB 12c
- Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
- Option 3- Part 5: Unlock HR Account Part 1
- Option 3- Part 6 : Unlock HR Account Part 2
- Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
- Option 4- Installing Oracle 11g express Edition + Unlock HR
- HR Schema in this Course
- Navigate HR schema
- oracle 18c express edition part 1 (download and install )
- oracle 18c express edition part 2 (unlock hr )
- oracle 18c express edition part 3 ( sql developer )
