Udemy Advanced Sql Tutorial TUTSEM | 8C6EB25B7AC672E31257CB79EEC95A8D4728C5A1

Udemy Advanced Sql Tutorial TUTSEM

Name	Udemy - Advanced Sql Tutorial - TUTSEM	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	92
Hash	8C6EB25B7AC672E31257CB79EEC95A8D4728C5A1

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