| 1 - Course Overview Topics of coverage English.vtt | 2.7 KB | ||
| 1 - Course Overview Topics of coverage.mp4 | 53.7 MB | ||
| 1 - Quiz 1.html | 0 B | ||
| 10 - Oracle Apex SQL environment and dataset for learning English.vtt | 5.5 KB | ||
| 10 - Oracle Apex SQL environment and dataset for learning.mp4 | 34.4 MB | ||
| 11 - Select statement Arithmetic Concatenate Distinct functions English.vtt | 5.7 KB | ||
| 11 - Select statement Arithmetic Concatenate Distinct functions.mp4 | 90.4 MB | ||
| 12 - Chapter-1.txt | 409.6 B | ||
| 12 - Select Statement Demonstration Arithmetic Concatenate Distinct function English.vtt | 4.3 KB | ||
| 12 - Select Statement Demonstration Arithmetic Concatenate Distinct function.mp4 | 35.6 MB | ||
| 13 - Oracle SQL Select Statement Filtering data using where clause English.vtt | 5.7 KB | ||
| 13 - Oracle SQL Select Statement Filtering data using where clause.mp4 | 90.6 MB | ||
| 14 - Chapter-2.txt | 921.6 B | ||
| 14 - Demonstration Select Statement Filtering data using where clause English.vtt | 5.8 KB | ||
| 14 - Demonstration Select Statement Filtering data using where clause.mp4 | 34.9 MB | ||
| 15 - Oracle SQL Select statement Functions 1 English.vtt | 5.4 KB | ||
| 15 - Oracle SQL Select statement Functions 1.mp4 | 90.5 MB | ||
| 16 - Oracle SQL Select statement Demonstration Functions English.vtt | 4.8 KB | ||
| 16 - Oracle SQL Select statement Demonstration Functions.mp4 | 29.3 MB | ||
| 16 - chapter-3-sql-sample.txt | 512 B | ||
| 17 - Chapter-3-nested-case-decode.txt | 716.8 B | ||
| 17 - Oracle SQL Select statement Functions 2 Nested CaseDecode English.vtt | 6.5 KB | ||
| 17 - Oracle SQL Select statement Functions 2 Nested CaseDecode.mp4 | 106.7 MB | ||
| 18 - Analytics functions Min Max Avg Nvl Std dev English.vtt | 6.9 KB | ||
| 18 - Analytics functions Min Max Avg Nvl Std dev.mp4 | 113.2 MB | ||
| 19 - Analytics functions Demonstration Min Max Avg Nvl Std dev English.vtt | 6 KB | ||
| 19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp4 | 53.4 MB | ||
| 2 - Quiz 2.html | 0 B | ||
| 2 - What is business application English.vtt | 9 KB | ||
| 2 - What is business application.mp4 | 142.9 MB | ||
| 20 - Analytics functions Group By and having clause English.vtt | 3.1 KB | ||
| 20 - Analytics functions Group By and having clause.mp4 | 46.3 MB | ||
| 21 - Analytics functions Demonstration Group by and having clause English.vtt | 6.4 KB | ||
| 21 - Analytics functions Demonstration Group by and having clause.mp4 | 45.6 MB | ||
| 22 - Analytics functions Rollup and Cube functions English.vtt | 4.7 KB | ||
| 22 - Analytics functions Rollup and Cube functions.mp4 | 84.1 MB | ||
| 23 - Analytics function Demonstration Rollup and Cube functions English.vtt | 4.2 KB | ||
| 23 - Analytics function Demonstration Rollup and Cube functions.mp4 | 44.1 MB | ||
| 23 - chapter-4-rollup-cube.txt | 307.2 B | ||
| 24 - Analytics Function Select statement Hierarchical English.vtt | 4 KB | ||
| 24 - Analytics Function Select statement Hierarchical.mp4 | 77.5 MB | ||
| 24 - heirarchial-sql.txt | 512 B | ||
| 25 - Analytics Functions Select Statement Demonstration Hierarchical English.vtt | 2.5 KB | ||
| 25 - Analytics Functions Select Statement Demonstration Hierarchical.mp4 | 23.6 MB | ||
| 26 - Different Types of Joins Natural and equi joins English.vtt | 4.8 KB | ||
| 26 - Different Types of Joins Natural and equi joins.mp4 | 83.4 MB | ||
| 27 - Demonstration 1 Natural and equi joins English.vtt | 3.4 KB | ||
| 27 - Demonstration 1 Natural and equi joins.mp4 | 26.8 MB | ||
| 27 - chapter-5-equi-joins.txt | 921.6 B | ||
| 28 - Demonstration 2 Natural and Equi Joins English.vtt | 1.8 KB | ||
| 28 - Demonstration 2 Natural and Equi Joins.mp4 | 15.1 MB | ||
| 29 - Joining table to itself towards data retrieval Self Joins English.vtt | 1.8 KB | ||
| 29 - Joining table to itself towards data retrieval Self Joins.mp4 | 32.5 MB | ||
| 3 - Difference between OLTP and OLAP English.vtt | 2.9 KB | ||
| 3 - Difference between OLTP and OLAP.mp4 | 32.4 MB | ||
| 3 - Quiz 3.html | 0 B | ||
| 30 - Demonstration Self Joins English.vtt | 819.2 B | ||
| 30 - Demonstration Self Joins.mp4 | 6 MB | ||
| 30 - chapter-5-self-joins.txt | 307.2 B | ||
| 31 - Outer Joins between tables English.vtt | 3.9 KB | ||
| 31 - Outer Joins between tables.mp4 | 71.9 MB | ||
| 31 - chapter-5-outer-joins.txt | 921.6 B | ||
| 32 - Demonstration Outer joins between tables English.vtt | 2.7 KB | ||
| 32 - Demonstration Outer joins between tables.mp4 | 26.4 MB | ||
| 33 - Lesson-6-Sub-querry.txt | 614.4 B | ||
| 33 - Oracle SQL What is subquery English.vtt | 5.2 KB | ||
| 33 - Oracle SQL What is subquery.mp4 | 82.1 MB | ||
| 34 - Demonstration Subquery English.vtt | 2.8 KB | ||
| 34 - Demonstration Subquery.mp4 | 16.3 MB | ||
| 35 - Other DMLs English.vtt | 4.3 KB | ||
| 35 - Other DMLs.mp4 | 65.4 MB | ||
| 36 - Data Definition Language English.vtt | 7.8 KB | ||
| 36 - Data Definition Language.mp4 | 130.4 MB | ||
| 37 - Demonstration Data definition Language English.vtt | 5.2 KB | ||
| 37 - Demonstration Data definition Language.mp4 | 45.1 MB | ||
| 37 - Lesson-7-insert.txt | 409.6 B | ||
| 38 - DB Schema Synonym Sequence Index Overview English.vtt | 9 KB | ||
| 38 - DB Schema Synonym Sequence Index Overview.mp4 | 133.7 MB | ||
| 39 - Dos Dont and Tuning Sql Overview English.vtt | 8 KB | ||
| 39 - Dos Dont and Tuning Sql Overview.mp4 | 131.2 MB | ||
| 4 - Quiz 4.html | 0 B | ||
| 4 - What is Relational Database English.vtt | 7.1 KB | ||
| 4 - What is Relational Database.mp4 | 120.5 MB | ||
| 40 - What is Data Dictionary English.vtt | 3.8 KB | ||
| 40 - What is Data Dictionary.mp4 | 49.7 MB | ||
| 41 - DataWarehouse and Business intelligence English.vtt | 11.3 KB | ||
| 41 - DataWarehouse and Business intelligence.mp4 | 180.5 MB | ||
| 42 - Dimension models English.vtt | 8.5 KB | ||
| 42 - Dimension models.mp4 | 148.9 MB | ||
| 43 - DWH Schema Star and Snowflake schema English.vtt | 2.8 KB | ||
| 43 - DWH Schema Star and Snowflake schema.mp4 | 49.3 MB | ||
| 44 - Fact and Dimension table English.vtt | 8.5 KB | ||
| 44 - Fact and Dimension table.mp4 | 148.8 MB | ||
| 45 - Bonus Lecture Concluding remarks & Next steps English.vtt | 4.2 KB | ||
| 45 - Bonus Lecture Concluding remarks & Next steps.mp4 | 73 MB | ||
| 45 - Data Modelling and Relational Database Design.txt | 102.4 B | ||
| 45 - Linux unix essentials and introduction to Shell scripting.txt | 102.4 B | ||
| 45 - Oracle APEX 19 SQL PLSQL to building web application development.txt | 102.4 B | ||
| 5 - Business flows ER diagrams and RDBMS English.vtt | 5.5 KB | ||
| 5 - Business flows ER diagrams and RDBMS.mp4 | 96.3 MB | ||
| 5 - Quiz 5.html | 0 B | ||
| 6 - Structured Query Language Introduction English.vtt | 3.8 KB | ||
| 6 - Structured Query Language Introduction.mp4 | 50.4 MB | ||
| 7 - ER Diagram Tables commonly used in this course English.vtt | 2.9 KB | ||
| 7 - ER Diagram Tables commonly used in this course.mp4 | 53.5 MB | ||
| 8 - What is an Oracle Instance English.vtt | 5 KB | ||
| 8 - What is an Oracle Instance.mp4 | 91.7 MB | ||
| 9 - Difference environment to practice Oracle SQL English.vtt | 6.2 KB | ||
| 9 - Difference environment to practice Oracle SQL.mp4 | 66.1 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 111 total files | |||
Oracle Sql For Data Analytics And Data Warehousing Overview
https://DevCourseWeb.com
Last updated 11/2019
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.15 GB | Duration: 4h 31m
Learn about enhanced functions of Oracle SQL for Data analytics and get an overview about Data warehousing
What you'll learn
Oracle SQL - Extensively about select statement (DML) from Data analytics point of view
An overview about Data warehousing concepts.
Understanding about other sql statement like DDL, DMLs
Basic understanding of ER diagrams, Oracle Instance and Database
Requirements
Some programming background would be beneficial
For optimum results use headphone speaker
Does not require any installs on your laptop/ PC
Description
Enterprise worldwide has huge data on their business application be it in the from of ERP or Data warehousing information. The heart of these system are Relational data base and enterprise world over are looking for expert who can derive meaningful information from the system, so as to grow and drive the business.An Oracle SQL expert from data analytics perspective is always on high demand. Considering this, the course is packed with all the necessary details.Apart from regular sql 'select statement ' which is called DML statement it also covers business analytics statement such as:Roll Up group.Cube - commonly referred in Data warehousing towards multi-dimensional data analyticsHierarchical functions.Additionally it also has an overview about Data warehousing concepts, which provides you with basic knowledge, which can then be used to acquire Datawarehouse - ETL tools and OLAP tools knowledge.One can learn Oracle SQL without any install through Cloud Oracle DB along with data set for easier practice.Happy Learning!!
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 1 week | 1 | 1 | |
| 2.7 GB | freecoursewb | 3 weeks | 2 | 1 | |
| 918 MB | freecoursewb | 5 months | 4 | 5 | |
|
Udemy - Oracle Fusion Smart View - Financial Reporting Studio - OTBI Posted by
freecoursewb in Other
|
3.6 GB | freecoursewb | 5 months | 0 | 1 |
| 653.3 MB | freecoursewb | 5 months | 1 | 0 |
All Comments