~Get Your Files Here !/1 - Introduction/1 - Course Overview Topics of coverage.mp453.71MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/18 - Analytics functions Min Max Avg Nvl Std dev.mp4113.15MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp453.4MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/20 - Analytics functions Group By and having clause.mp446.35MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/21 - Analytics functions Demonstration Group by and having clause.mp445.61MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/22 - Analytics functions Rollup and Cube functions.mp484.1MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/23 - Analytics function Demonstration Rollup and Cube functions.mp444.14MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/24 - Analytics Function Select statement Hierarchical.mp477.49MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/25 - Analytics Functions Select Statement Demonstration Hierarchical.mp423.64MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/26 - Different Types of Joins Natural and equi joins.mp483.41MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/27 - Demonstration 1 Natural and equi joins.mp426.81MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/28 - Demonstration 2 Natural and Equi Joins.mp415.1MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/29 - Joining table to itself towards data retrieval Self Joins.mp432.45MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/30 - Demonstration Self Joins.mp46.02MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/31 - Outer Joins between tables.mp471.95MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/32 - Demonstration Outer joins between tables.mp426.42MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/33 - Oracle SQL What is subquery.mp482.12MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/34 - Demonstration Subquery.mp416.31MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/35 - Other DMLs.mp465.4MB
~Get Your Files Here !/14 - Data Definition Language/36 - Data Definition Language.mp4130.42MB
~Get Your Files Here !/14 - Data Definition Language/37 - Demonstration Data definition Language.mp445.06MB
~Get Your Files Here !/15 - DB Schema Synonym Sequence Index Overview/38 - DB Schema Synonym Sequence Index Overview.mp4133.72MB
~Get Your Files Here !/16 - Dos Dont and Tuning Sql Overview/39 - Dos Dont and Tuning Sql Overview.mp4131.18MB
~Get Your Files Here !/17 - What is Data Dictionary/40 - What is Data Dictionary.mp449.68MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/41 - DataWarehouse and Business intelligence.mp4180.53MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/42 - Dimension models.mp4148.89MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/43 - DWH Schema Star and Snowflake schema.mp449.35MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/44 - Fact and Dimension table.mp4148.78MB
~Get Your Files Here !/2 - Whats a business application/2 - What is business application.mp4142.89MB
~Get Your Files Here !/2 - Whats a business application/3 - Difference between OLTP and OLAP.mp432.39MB
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Bonus Lecture Concluding remarks & Next steps.mp473.02MB
~Get Your Files Here !/3 - Relational Database and SQL/4 - What is Relational Database.mp4120.53MB
~Get Your Files Here !/3 - Relational Database and SQL/5 - Business flows ER diagrams and RDBMS.mp496.32MB
~Get Your Files Here !/3 - Relational Database and SQL/6 - Structured Query Language Introduction.mp450.4MB
~Get Your Files Here !/3 - Relational Database and SQL/7 - ER Diagram Tables commonly used in this course.mp453.47MB
~Get Your Files Here !/4 - What is an Oracle Instance/8 - What is an Oracle Instance.mp491.69MB
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/10 - Oracle Apex SQL environment and dataset for learning.mp434.45MB
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/9 - Difference environment to practice Oracle SQL.mp466.09MB
~Get Your Files Here !/8 - Oracle SQL Select Statement Filtering data using where clause/13 - Oracle SQL Select Statement Filtering data using where clause.mp490.61MB
~Get Your Files Here !/8 - Oracle SQL Select Statement Filtering data using where clause/14 - Demonstration Select Statement Filtering data using where clause.mp434.88MB
~Get Your Files Here !/9 - Oracle SQL Select statement Functions/15 - Oracle SQL Select statement Functions 1.mp490.48MB
~Get Your Files Here !/9 - Oracle SQL Select statement Functions/16 - Oracle SQL Select statement Demonstration Functions.mp429.31MB
~Get Your Files Here !/9 - Oracle SQL Select statement Functions/17 - Oracle SQL Select statement Functions 2 Nested CaseDecode.mp4106.73MB