Udemy SQL Advanced | 02954F4D6F178AAFF40A76B553DFE38B2764A2AF

Udemy SQL Advanced

Name	Udemy-SQL Advanced	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.1 GB
Total Files	89
Hash	02954F4D6F178AAFF40A76B553DFE38B2764A2AF

/00 None/
001 Welcome to the course.mp4	4.5 MB
002 How to make best use of the program..pdf	207.9 KB
/01 Software Installation/
003 Installing Oracle.mp4	11.8 MB
005 Installing SQL Developer.mp4	10.5 MB
006 Running scripts necessary for the course.mp4	9.9 MB
004 Installing Java SDK.mp4	7.4 MB
007 Scripts used in the demonstration.pdf	177.3 KB
/.../013 Lab Setup/
SETUP-for-Lab-Exercises.pdf	200.8 KB
/attached_files/014 Exercise 1/
Exercise-1.pdf	211.6 KB
/02 Manipulating data/
012 Merge the data....mp4	35.1 MB
011 Multi table Inserts.mp4	28.1 MB
010 Arithmetic calculations on NULL Values.mp4	24.8 MB
008 Default values for columns.mp4	22.0 MB
009 Virtual Columns.mp4	21.8 MB
013 Lab Setup.html	0.5 KB
014 Exercise 1.html	0.5 KB
/attached_files/026 Exercise 2/
Analytical-Functions-Exercises.pdf	264.7 KB
/03 Analytical Functions/
016 Why Analytical Functions Example 1.mp4	26.9 MB
015 Analytical Functions Introduction.mp4	22.1 MB
023 LAG and LEAD function Examples.mp4	19.5 MB
020 Ranking your data.mp4	19.1 MB
022 Dividing your data into Bands.mp4	18.7 MB
021 Performing Top N Analysis.mp4	17.3 MB
024 Analyzing Sales growth across time.mp4	16.7 MB
019 Displaying Sales as a percentage of Total sales.mp4	14.6 MB
017 Why Analytical Functions Example 2.mp4	13.7 MB
018 Getting the cummulative Sum of Sales.mp4	8.6 MB
025 Analytical Functions Recap.pdf	313.4 KB
026 Exercise 2.html	0.5 KB
/.../032 Data Transformation Recap/
Data-Transformation.pdf	365.3 KB
/attached_files/033 Exercise 3/
Data-Transformation.pdf	242.9 KB
/04 Transforming the Data/
027 Row level data to Column level using CASE statement.mp4	15.2 MB
030 Column level data to Row level using UNION.mp4	14.3 MB
029 Row level data to Column level using LISTAGG.mp4	10.5 MB
031 Column level data to Row level using UNPIVOT.mp4	10.5 MB
028 Row level data to Column level using PIVOT.mp4	10.0 MB
033 Exercise 3.html	0.5 KB
032 Data Transformation Recap.html	0.4 KB
/attached_files/043 Exercise 4/
Exercise-2.pdf	227.8 KB
/05 Hierarchical Queries/
035 Connect By clause.mp4	29.0 MB
039 Get me the Sales under Manager Raj.mp4	15.6 MB
036 Creating the Hierarchy Tree.mp4	14.2 MB
038 CONNECT_BY_ROOT unary operator.mp4	11.1 MB
037 Sorting the Hierarchy Tree.mp4	9.2 MB
040 SYS_CONNECT_BY_PATH function.mp4	7.9 MB
034 Hierarchical Queries Introduction.mp4	4.6 MB
041 CONNECT BY for number generation.mp4	4.1 MB
042 Hierarchical Queries Recap.pdf	340.7 KB
043 Exercise 4.html	0.5 KB
/attached_files/052 Exercise 5/
Exercise-3.pdf	316.3 KB
/06 Extensions to Group BY/
045 Sub Totals using ROLLUP function.mp4	24.6 MB
049 Limiting number of sub totals using GROUPING SETS function.mp4	24.3 MB
050 Composite Columns.mp4	20.0 MB
047 GROUPING function.mp4	19.9 MB
048 GROUPING_ID function.mp4	14.7 MB
046 Sub Totals using CUBE function.mp4	11.1 MB
044 Extensions to Group BY.mp4	1.5 MB
051 Group by Extensions Recap.pdf	482.9 KB
052 Exercise 5.html	0.5 KB
/07 Table Partitioning/
055 Range Partition based on range of values.mp4	46.7 MB
059 Interval Partition for automatic partition creation.mp4	35.9 MB
056 List Partition based on list of values.mp4	26.0 MB
058 Composite Partitioning by mixing things up.mp4	24.2 MB
057 Hash Partition based on the hash key.mp4	23.8 MB
054 Table Partitioning Introduction.mp4	15.6 MB
061 Table Partitioning Recap.pdf	291.3 KB
060 AddingDroping Partitions.pdf	277.8 KB
053 Read This.pdf	192.7 KB
/08 Materialized Views/
064 Materialized Views with ON COMMIT option.mp4	34.2 MB
068 Query Rewrite functionality.mp4	31.8 MB
065 Materialized Views with ON DEMAND option.mp4	26.8 MB
066 Materialized Views with REFRESH FAST option.mp4	26.1 MB
067 Timing the refresh.mp4	20.5 MB
063 Materialized Views creation Options.mp4	12.6 MB
062 Materialized Views Introduction.mp4	10.1 MB
069 Materialized Views Recap.pdf	430.9 KB
/09 Regular Expressions/
074 Matching the characters in a List.mp4	22.1 MB
071 Meta Characters . and.mp4	18.8 MB
077 POSIX Character class operators.mp4	16.8 MB
072 Meta Characters and.mp4	15.3 MB
073 Interval Operator to match the number of occurances.mp4	14.0 MB
076 Check for an expression in the beginning or end of a string.mp4	9.9 MB
075 Lets combine multiple expressions using.mp4	9.5 MB
070 Regular Expressions Introduction.mp4	8.7 MB
078 Search for meta characters by placing a escape character.mp4	7.8 MB
079 More examples on Regular Expressions.pdf	90.1 KB
/10 Flashback operations/
081 Tracking changes in Data.mp4	20.6 MB
080 Flashback operations Introduction.mp4	19.3 MB
082 Flashback Operations Recap.pdf	258.4 KB
Total files 89