Download link
File List
-
02 Manipulating data/attached_files/013 Lab Setup/SETUP-for-Lab-Exercises.pdf 196.06 KB
02 Manipulating data/attached_files/014 Exercise 1/Exercise-1.pdf 206.6 KB
03 Analytical Functions/attached_files/026 Exercise 2/Analytical-Functions-Exercises.pdf 258.48 KB
04 Transforming the Data/attached_files/032 Data Transformation Recap/Data-Transformation.pdf 356.76 KB
04 Transforming the Data/attached_files/033 Exercise 3/Data-Transformation.pdf 237.16 KB
05 Hierarchical Queries/attached_files/043 Exercise 4/Exercise-2.pdf 222.46 KB
06 Extensions to Group BY/attached_files/052 Exercise 5/Exercise-3.pdf 308.93 KB
00 None/001 Welcome to the course.mp4 4.29 MB
00 None/002 How to make best use of the program..pdf 203.01 KB
01 Software Installation/003 Installing Oracle.mp4 11.23 MB
01 Software Installation/004 Installing Java SDK.mp4 7.04 MB
01 Software Installation/005 Installing SQL Developer.mp4 10.05 MB
01 Software Installation/006 Running scripts necessary for the course.mp4 9.4 MB
01 Software Installation/007 Scripts used in the demonstration.pdf 173.12 KB
02 Manipulating data/008 Default values for columns.mp4 20.94 MB
02 Manipulating data/009 Virtual Columns.mp4 20.78 MB
02 Manipulating data/010 Arithmetic calculations on NULL Values.mp4 23.67 MB
02 Manipulating data/011 Multi table Inserts.mp4 26.79 MB
02 Manipulating data/012 Merge the data....mp4 33.48 MB
02 Manipulating data/013 Lab Setup.html 490 B
02 Manipulating data/014 Exercise 1.html 458 B
03 Analytical Functions/015 Analytical Functions Introduction.mp4 21.09 MB
03 Analytical Functions/016 Why Analytical Functions Example 1.mp4 25.65 MB
03 Analytical Functions/017 Why Analytical Functions Example 2.mp4 13.05 MB
03 Analytical Functions/018 Getting the cummulative Sum of Sales.mp4 8.24 MB
03 Analytical Functions/019 Displaying Sales as a percentage of Total sales.mp4 13.9 MB
03 Analytical Functions/020 Ranking your data.mp4 18.24 MB
03 Analytical Functions/021 Performing Top N Analysis.mp4 16.54 MB
03 Analytical Functions/022 Dividing your data into Bands.mp4 17.79 MB
03 Analytical Functions/023 LAG and LEAD function Examples.mp4 18.64 MB
03 Analytical Functions/024 Analyzing Sales growth across time.mp4 15.95 MB
03 Analytical Functions/025 Analytical Functions Recap.pdf 306.06 KB
03 Analytical Functions/026 Exercise 2.html 499 B
04 Transforming the Data/027 Row level data to Column level using CASE statement.mp4 14.5 MB
04 Transforming the Data/028 Row level data to Column level using PIVOT.mp4 9.5 MB
04 Transforming the Data/029 Row level data to Column level using LISTAGG.mp4 10.02 MB
04 Transforming the Data/030 Column level data to Row level using UNION.mp4 13.65 MB
04 Transforming the Data/031 Column level data to Row level using UNPIVOT.mp4 10 MB
04 Transforming the Data/032 Data Transformation Recap.html 379 B
04 Transforming the Data/033 Exercise 3.html 488 B
05 Hierarchical Queries/034 Hierarchical Queries Introduction.mp4 4.34 MB
05 Hierarchical Queries/035 Connect By clause.mp4 27.61 MB
05 Hierarchical Queries/036 Creating the Hierarchy Tree.mp4 13.57 MB
05 Hierarchical Queries/037 Sorting the Hierarchy Tree.mp4 8.78 MB
05 Hierarchical Queries/038 CONNECT_BY_ROOT unary operator.mp4 10.59 MB
05 Hierarchical Queries/039 Get me the Sales under Manager Raj.mp4 14.87 MB
05 Hierarchical Queries/040 SYS_CONNECT_BY_PATH function.mp4 7.55 MB
05 Hierarchical Queries/041 CONNECT BY for number generation.mp4 3.88 MB
05 Hierarchical Queries/042 Hierarchical Queries Recap.pdf 332.75 KB
05 Hierarchical Queries/043 Exercise 4.html 458 B
06 Extensions to Group BY/044 Extensions to Group BY.mp4 1.45 MB
06 Extensions to Group BY/045 Sub Totals using ROLLUP function.mp4 23.46 MB
06 Extensions to Group BY/046 Sub Totals using CUBE function.mp4 10.62 MB
06 Extensions to Group BY/047 GROUPING function.mp4 18.93 MB
06 Extensions to Group BY/048 GROUPING_ID function.mp4 14.04 MB
06 Extensions to Group BY/049 Limiting number of sub totals using GROUPING SETS function.mp4 23.14 MB
06 Extensions to Group BY/050 Composite Columns.mp4 19.07 MB
06 Extensions to Group BY/051 Group by Extensions Recap.pdf 471.63 KB
06 Extensions to Group BY/052 Exercise 5.html 459 B
07 Table Partitioning/053 Read This.pdf 188.19 KB
07 Table Partitioning/054 Table Partitioning Introduction.mp4 14.91 MB
07 Table Partitioning/055 Range Partition based on range of values.mp4 44.58 MB
07 Table Partitioning/056 List Partition based on list of values.mp4 24.79 MB
07 Table Partitioning/057 Hash Partition based on the hash key.mp4 22.68 MB
07 Table Partitioning/058 Composite Partitioning by mixing things up.mp4 23.09 MB
07 Table Partitioning/059 Interval Partition for automatic partition creation.mp4 34.2 MB
07 Table Partitioning/060 AddingDroping Partitions.pdf 271.32 KB
07 Table Partitioning/061 Table Partitioning Recap.pdf 284.46 KB
08 Materialized Views/062 Materialized Views Introduction.mp4 9.59 MB
08 Materialized Views/063 Materialized Views creation Options.mp4 12.03 MB
08 Materialized Views/064 Materialized Views with ON COMMIT option.mp4 32.6 MB
08 Materialized Views/065 Materialized Views with ON DEMAND option.mp4 25.59 MB
08 Materialized Views/066 Materialized Views with REFRESH FAST option.mp4 24.89 MB
08 Materialized Views/067 Timing the refresh.mp4 19.5 MB
08 Materialized Views/068 Query Rewrite functionality.mp4 30.36 MB
08 Materialized Views/069 Materialized Views Recap.pdf 420.84 KB
09 Regular Expressions/070 Regular Expressions Introduction.mp4 8.25 MB
09 Regular Expressions/071 Meta Characters . and.mp4 17.97 MB
09 Regular Expressions/072 Meta Characters and.mp4 14.62 MB
09 Regular Expressions/073 Interval Operator to match the number of occurances.mp4 13.4 MB
09 Regular Expressions/074 Matching the characters in a List.mp4 21.07 MB
09 Regular Expressions/075 Lets combine multiple expressions using.mp4 9.07 MB
09 Regular Expressions/076 Check for an expression in the beginning or end of a string.mp4 9.42 MB
09 Regular Expressions/077 POSIX Character class operators.mp4 16.04 MB
09 Regular Expressions/078 Search for meta characters by placing a escape character.mp4 7.45 MB
09 Regular Expressions/079 More examples on Regular Expressions.pdf 87.98 KB
10 Flashback operations/080 Flashback operations Introduction.mp4 18.45 MB
10 Flashback operations/081 Tracking changes in Data.mp4 19.66 MB
10 Flashback operations/082 Flashback Operations Recap.pdf 252.39 KB
[FreeTutorials.Us].txt 75 B
Freetutorials.Us.url 119 B
Download Info
-
Tips
“[FreeTutorials.Us] advanced-sql-tutorial” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.