[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/attached_files/013 Lab Setup/SETUP-for-Lab-Exercises.pdf |
196 KB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/attached_files/014 Exercise 1/Exercise-1.pdf |
207 KB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/attached_files/026 Exercise 2/Analytical-Functions-Exercises.pdf |
258 KB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/attached_files/032 Data Transformation Recap/Data-Transformation.pdf |
357 KB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/attached_files/033 Exercise 3/Data-Transformation.pdf |
237 KB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/attached_files/043 Exercise 4/Exercise-2.pdf |
222 KB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/attached_files/052 Exercise 5/Exercise-3.pdf |
309 KB |
[FreeTutorials.Us] advanced-sql-tutorial/00 None/001 Welcome to the course.mp4 |
4.3 MB |
[FreeTutorials.Us] advanced-sql-tutorial/00 None/002 How to make best use of the program..pdf |
203 KB |
[FreeTutorials.Us] advanced-sql-tutorial/01 Software Installation/003 Installing Oracle.mp4 |
11.2 MB |
[FreeTutorials.Us] advanced-sql-tutorial/01 Software Installation/004 Installing Java SDK.mp4 |
7 MB |
[FreeTutorials.Us] advanced-sql-tutorial/01 Software Installation/005 Installing SQL Developer.mp4 |
10.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/01 Software Installation/006 Running scripts necessary for the course.mp4 |
9.4 MB |
[FreeTutorials.Us] advanced-sql-tutorial/01 Software Installation/007 Scripts used in the demonstration.pdf |
173 KB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/008 Default values for columns.mp4 |
20.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/009 Virtual Columns.mp4 |
20.8 MB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/010 Arithmetic calculations on NULL Values.mp4 |
23.7 MB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/011 Multi table Inserts.mp4 |
26.8 MB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/012 Merge the data....mp4 |
33.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/013 Lab Setup.html |
490 B |
[FreeTutorials.Us] advanced-sql-tutorial/02 Manipulating data/014 Exercise 1.html |
458 B |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/015 Analytical Functions Introduction.mp4 |
21.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/016 Why Analytical Functions Example 1.mp4 |
25.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/017 Why Analytical Functions Example 2.mp4 |
13 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/018 Getting the cummulative Sum of Sales.mp4 |
8.2 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/019 Displaying Sales as a percentage of Total sales.mp4 |
13.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/020 Ranking your data.mp4 |
18.2 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/021 Performing Top N Analysis.mp4 |
16.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/022 Dividing your data into Bands.mp4 |
17.8 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/023 LAG and LEAD function Examples.mp4 |
18.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/024 Analyzing Sales growth across time.mp4 |
15.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/025 Analytical Functions Recap.pdf |
306 KB |
[FreeTutorials.Us] advanced-sql-tutorial/03 Analytical Functions/026 Exercise 2.html |
499 B |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/027 Row level data to Column level using CASE statement.mp4 |
14.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/028 Row level data to Column level using PIVOT.mp4 |
9.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/029 Row level data to Column level using LISTAGG.mp4 |
10 MB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/030 Column level data to Row level using UNION.mp4 |
13.7 MB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/031 Column level data to Row level using UNPIVOT.mp4 |
10 MB |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/032 Data Transformation Recap.html |
379 B |
[FreeTutorials.Us] advanced-sql-tutorial/04 Transforming the Data/033 Exercise 3.html |
488 B |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/034 Hierarchical Queries Introduction.mp4 |
4.3 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/035 Connect By clause.mp4 |
27.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/036 Creating the Hierarchy Tree.mp4 |
13.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/037 Sorting the Hierarchy Tree.mp4 |
8.8 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/038 CONNECT_BY_ROOT unary operator.mp4 |
10.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/039 Get me the Sales under Manager Raj.mp4 |
14.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/040 SYS_CONNECT_BY_PATH function.mp4 |
7.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/041 CONNECT BY for number generation.mp4 |
3.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/042 Hierarchical Queries Recap.pdf |
333 KB |
[FreeTutorials.Us] advanced-sql-tutorial/05 Hierarchical Queries/043 Exercise 4.html |
458 B |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/044 Extensions to Group BY.mp4 |
1.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/045 Sub Totals using ROLLUP function.mp4 |
23.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/046 Sub Totals using CUBE function.mp4 |
10.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/047 GROUPING function.mp4 |
18.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/048 GROUPING_ID function.mp4 |
14 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/049 Limiting number of sub totals using GROUPING SETS function.mp4 |
23.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/050 Composite Columns.mp4 |
19.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/051 Group by Extensions Recap.pdf |
472 KB |
[FreeTutorials.Us] advanced-sql-tutorial/06 Extensions to Group BY/052 Exercise 5.html |
459 B |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/053 Read This.pdf |
188 KB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/054 Table Partitioning Introduction.mp4 |
14.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/055 Range Partition based on range of values.mp4 |
44.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/056 List Partition based on list of values.mp4 |
24.8 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/057 Hash Partition based on the hash key.mp4 |
22.7 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/058 Composite Partitioning by mixing things up.mp4 |
23.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/059 Interval Partition for automatic partition creation.mp4 |
34.2 MB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/060 AddingDroping Partitions.pdf |
271 KB |
[FreeTutorials.Us] advanced-sql-tutorial/07 Table Partitioning/061 Table Partitioning Recap.pdf |
284 KB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/062 Materialized Views Introduction.mp4 |
9.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/063 Materialized Views creation Options.mp4 |
12 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/064 Materialized Views with ON COMMIT option.mp4 |
32.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/065 Materialized Views with ON DEMAND option.mp4 |
25.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/066 Materialized Views with REFRESH FAST option.mp4 |
24.9 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/067 Timing the refresh.mp4 |
19.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/068 Query Rewrite functionality.mp4 |
30.4 MB |
[FreeTutorials.Us] advanced-sql-tutorial/08 Materialized Views/069 Materialized Views Recap.pdf |
421 KB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/070 Regular Expressions Introduction.mp4 |
8.3 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/071 Meta Characters . and.mp4 |
18 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/072 Meta Characters and.mp4 |
14.6 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/073 Interval Operator to match the number of occurances.mp4 |
13.4 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/074 Matching the characters in a List.mp4 |
21.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/075 Lets combine multiple expressions using.mp4 |
9.1 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/076 Check for an expression in the beginning or end of a string.mp4 |
9.4 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/077 POSIX Character class operators.mp4 |
16 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/078 Search for meta characters by placing a escape character.mp4 |
7.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/09 Regular Expressions/079 More examples on Regular Expressions.pdf |
88 KB |
[FreeTutorials.Us] advanced-sql-tutorial/10 Flashback operations/080 Flashback operations Introduction.mp4 |
18.5 MB |
[FreeTutorials.Us] advanced-sql-tutorial/10 Flashback operations/081 Tracking changes in Data.mp4 |
19.7 MB |
[FreeTutorials.Us] advanced-sql-tutorial/10 Flashback operations/082 Flashback Operations Recap.pdf |
252 KB |
[FreeTutorials.Us] advanced-sql-tutorial/[FreeTutorials.Us].txt |
75 B |
[FreeTutorials.Us] advanced-sql-tutorial/Freetutorials.Us.url |
119 B |