|
|
1 - Course Overview Topics of coverage English.vtt
|
VTT
|
2.7 KB
|
|
|
1 - Course Overview Topics of coverage.mp4
|
MP4
|
53.7 MB
|
|
|
1 - Quiz 1.html
|
HTML
|
0 B
|
|
|
10 - Oracle Apex SQL environment and dataset for learning English.vtt
|
VTT
|
5.5 KB
|
|
|
10 - Oracle Apex SQL environment and dataset for learning.mp4
|
MP4
|
34.4 MB
|
|
|
11 - Select statement Arithmetic Concatenate Distinct functions English.vtt
|
VTT
|
5.7 KB
|
|
|
11 - Select statement Arithmetic Concatenate Distinct functions.mp4
|
MP4
|
90.4 MB
|
|
|
12 - Chapter-1.txt
|
TXT
|
409.6 B
|
|
|
12 - Select Statement Demonstration Arithmetic Concatenate Distinct function English.vtt
|
VTT
|
4.3 KB
|
|
|
12 - Select Statement Demonstration Arithmetic Concatenate Distinct function.mp4
|
MP4
|
35.6 MB
|
|
|
13 - Oracle SQL Select Statement Filtering data using where clause English.vtt
|
VTT
|
5.7 KB
|
|
|
13 - Oracle SQL Select Statement Filtering data using where clause.mp4
|
MP4
|
90.6 MB
|
|
|
14 - Chapter-2.txt
|
TXT
|
921.6 B
|
|
|
14 - Demonstration Select Statement Filtering data using where clause English.vtt
|
VTT
|
5.8 KB
|
|
|
14 - Demonstration Select Statement Filtering data using where clause.mp4
|
MP4
|
34.9 MB
|
|
|
15 - Oracle SQL Select statement Functions 1 English.vtt
|
VTT
|
5.4 KB
|
|
|
15 - Oracle SQL Select statement Functions 1.mp4
|
MP4
|
90.5 MB
|
|
|
16 - Oracle SQL Select statement Demonstration Functions English.vtt
|
VTT
|
4.8 KB
|
|
|
16 - Oracle SQL Select statement Demonstration Functions.mp4
|
MP4
|
29.3 MB
|
|
|
16 - chapter-3-sql-sample.txt
|
TXT
|
512 B
|
|
|
17 - Chapter-3-nested-case-decode.txt
|
TXT
|
716.8 B
|
|
|
17 - Oracle SQL Select statement Functions 2 Nested CaseDecode English.vtt
|
VTT
|
6.5 KB
|
|
|
17 - Oracle SQL Select statement Functions 2 Nested CaseDecode.mp4
|
MP4
|
106.7 MB
|
|
|
18 - Analytics functions Min Max Avg Nvl Std dev English.vtt
|
VTT
|
6.9 KB
|
|
|
18 - Analytics functions Min Max Avg Nvl Std dev.mp4
|
MP4
|
113.2 MB
|
|
|
19 - Analytics functions Demonstration Min Max Avg Nvl Std dev English.vtt
|
VTT
|
6 KB
|
|
|
19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp4
|
MP4
|
53.4 MB
|
|
|
2 - Quiz 2.html
|
HTML
|
0 B
|
|
|
2 - What is business application English.vtt
|
VTT
|
9 KB
|
|
|
2 - What is business application.mp4
|
MP4
|
142.9 MB
|
|
|
20 - Analytics functions Group By and having clause English.vtt
|
VTT
|
3.1 KB
|
|
|
20 - Analytics functions Group By and having clause.mp4
|
MP4
|
46.3 MB
|
|
|
21 - Analytics functions Demonstration Group by and having clause English.vtt
|
VTT
|
6.4 KB
|
|
|
21 - Analytics functions Demonstration Group by and having clause.mp4
|
MP4
|
45.6 MB
|
|
|
22 - Analytics functions Rollup and Cube functions English.vtt
|
VTT
|
4.7 KB
|
|
|
22 - Analytics functions Rollup and Cube functions.mp4
|
MP4
|
84.1 MB
|
|
|
23 - Analytics function Demonstration Rollup and Cube functions English.vtt
|
VTT
|
4.2 KB
|
|
|
23 - Analytics function Demonstration Rollup and Cube functions.mp4
|
MP4
|
44.1 MB
|
|
|
23 - chapter-4-rollup-cube.txt
|
TXT
|
307.2 B
|
|
|
24 - Analytics Function Select statement Hierarchical English.vtt
|
VTT
|
4 KB
|
|
|
24 - Analytics Function Select statement Hierarchical.mp4
|
MP4
|
77.5 MB
|
|
|
24 - heirarchial-sql.txt
|
TXT
|
512 B
|
|
|
25 - Analytics Functions Select Statement Demonstration Hierarchical English.vtt
|
VTT
|
2.5 KB
|
|
|
25 - Analytics Functions Select Statement Demonstration Hierarchical.mp4
|
MP4
|
23.6 MB
|
|
|
26 - Different Types of Joins Natural and equi joins English.vtt
|
VTT
|
4.8 KB
|
|
|
26 - Different Types of Joins Natural and equi joins.mp4
|
MP4
|
83.4 MB
|
|
|
27 - Demonstration 1 Natural and equi joins English.vtt
|
VTT
|
3.4 KB
|
|
|
27 - Demonstration 1 Natural and equi joins.mp4
|
MP4
|
26.8 MB
|
|
|
27 - chapter-5-equi-joins.txt
|
TXT
|
921.6 B
|
|
|
28 - Demonstration 2 Natural and Equi Joins English.vtt
|
VTT
|
1.8 KB
|
|
|
28 - Demonstration 2 Natural and Equi Joins.mp4
|
MP4
|
15.1 MB
|
|
|
29 - Joining table to itself towards data retrieval Self Joins English.vtt
|
VTT
|
1.8 KB
|
|
|
29 - Joining table to itself towards data retrieval Self Joins.mp4
|
MP4
|
32.5 MB
|
|
|
3 - Difference between OLTP and OLAP English.vtt
|
VTT
|
2.9 KB
|
|
|
3 - Difference between OLTP and OLAP.mp4
|
MP4
|
32.4 MB
|
|
|
3 - Quiz 3.html
|
HTML
|
0 B
|
|
|
30 - Demonstration Self Joins English.vtt
|
VTT
|
819.2 B
|
|
|
30 - Demonstration Self Joins.mp4
|
MP4
|
6 MB
|
|
|
30 - chapter-5-self-joins.txt
|
TXT
|
307.2 B
|
|
|
31 - Outer Joins between tables English.vtt
|
VTT
|
3.9 KB
|
|
|
31 - Outer Joins between tables.mp4
|
MP4
|
71.9 MB
|
|
|
31 - chapter-5-outer-joins.txt
|
TXT
|
921.6 B
|
|
|
32 - Demonstration Outer joins between tables English.vtt
|
VTT
|
2.7 KB
|
|
|
32 - Demonstration Outer joins between tables.mp4
|
MP4
|
26.4 MB
|
|
|
33 - Lesson-6-Sub-querry.txt
|
TXT
|
614.4 B
|
|
|
33 - Oracle SQL What is subquery English.vtt
|
VTT
|
5.2 KB
|
|
|
33 - Oracle SQL What is subquery.mp4
|
MP4
|
82.1 MB
|
|
|
34 - Demonstration Subquery English.vtt
|
VTT
|
2.8 KB
|
|
|
34 - Demonstration Subquery.mp4
|
MP4
|
16.3 MB
|
|
|
35 - Other DMLs English.vtt
|
VTT
|
4.3 KB
|
|
|
35 - Other DMLs.mp4
|
MP4
|
65.4 MB
|
|
|
36 - Data Definition Language English.vtt
|
VTT
|
7.8 KB
|
|
|
36 - Data Definition Language.mp4
|
MP4
|
130.4 MB
|
|
|
37 - Demonstration Data definition Language English.vtt
|
VTT
|
5.2 KB
|
|
|
37 - Demonstration Data definition Language.mp4
|
MP4
|
45.1 MB
|
|
|
37 - Lesson-7-insert.txt
|
TXT
|
409.6 B
|
|
|
38 - DB Schema Synonym Sequence Index Overview English.vtt
|
VTT
|
9 KB
|
|
|
38 - DB Schema Synonym Sequence Index Overview.mp4
|
MP4
|
133.7 MB
|
|
|
39 - Dos Dont and Tuning Sql Overview English.vtt
|
VTT
|
8 KB
|
|
|
39 - Dos Dont and Tuning Sql Overview.mp4
|
MP4
|
131.2 MB
|
|
|
4 - Quiz 4.html
|
HTML
|
0 B
|
|
|
4 - What is Relational Database English.vtt
|
VTT
|
7.1 KB
|
|
|
4 - What is Relational Database.mp4
|
MP4
|
120.5 MB
|
|
|
40 - What is Data Dictionary English.vtt
|
VTT
|
3.8 KB
|
|
|
40 - What is Data Dictionary.mp4
|
MP4
|
49.7 MB
|
|
|
41 - DataWarehouse and Business intelligence English.vtt
|
VTT
|
11.3 KB
|
|
|
41 - DataWarehouse and Business intelligence.mp4
|
MP4
|
180.5 MB
|
|
|
42 - Dimension models English.vtt
|
VTT
|
8.5 KB
|
|
|
42 - Dimension models.mp4
|
MP4
|
148.9 MB
|
|
|
43 - DWH Schema Star and Snowflake schema English.vtt
|
VTT
|
2.8 KB
|
|
|
43 - DWH Schema Star and Snowflake schema.mp4
|
MP4
|
49.3 MB
|
|
|
44 - Fact and Dimension table English.vtt
|
VTT
|
8.5 KB
|
|
|
44 - Fact and Dimension table.mp4
|
MP4
|
148.8 MB
|
|
|
45 - Bonus Lecture Concluding remarks & Next steps English.vtt
|
VTT
|
4.2 KB
|
|
|
45 - Bonus Lecture Concluding remarks & Next steps.mp4
|
MP4
|
73 MB
|
|
|
45 - Data Modelling and Relational Database Design.txt
|
TXT
|
102.4 B
|
|
|
45 - Linux unix essentials and introduction to Shell scripting.txt
|
TXT
|
102.4 B
|
|
|
45 - Oracle APEX 19 SQL PLSQL to building web application development.txt
|
TXT
|
102.4 B
|
|
|
5 - Business flows ER diagrams and RDBMS English.vtt
|
VTT
|
5.5 KB
|
|
|
5 - Business flows ER diagrams and RDBMS.mp4
|
MP4
|
96.3 MB
|
|
|
5 - Quiz 5.html
|
HTML
|
0 B
|
|
|
6 - Structured Query Language Introduction English.vtt
|
VTT
|
3.8 KB
|
|
|
6 - Structured Query Language Introduction.mp4
|
MP4
|
50.4 MB
|
|
|
7 - ER Diagram Tables commonly used in this course English.vtt
|
VTT
|
2.9 KB
|
|
|
7 - ER Diagram Tables commonly used in this course.mp4
|
MP4
|
53.5 MB
|
|
|
8 - What is an Oracle Instance English.vtt
|
VTT
|
5 KB
|
|
|
8 - What is an Oracle Instance.mp4
|
MP4
|
91.7 MB
|
|
|
9 - Difference environment to practice Oracle SQL English.vtt
|
VTT
|
6.2 KB
|
|
|
9 - Difference environment to practice Oracle SQL.mp4
|
MP4
|
66.1 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|