17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Oracle Sql For Data Analytics And Data Warehousing Overview
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Course Overview Topics of coverage English.vtt
2.7 KB
~Get Your Files Here !/1 - Introduction/1 - Course Overview Topics of coverage.mp4
53.7 MB
~Get Your Files Here !/10 - Quiz 2/2 - Quiz 2.html
0 B
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/18 - Analytics functions Min Max Avg Nvl Std dev English.vtt
6.9 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/18 - Analytics functions Min Max Avg Nvl Std dev.mp4
113.2 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/19 - Analytics functions Demonstration Min Max Avg Nvl Std dev English.vtt
6 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp4
53.4 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/20 - Analytics functions Group By and having clause English.vtt
3.1 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/20 - Analytics functions Group By and having clause.mp4
46.3 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/21 - Analytics functions Demonstration Group by and having clause English.vtt
6.4 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/21 - Analytics functions Demonstration Group by and having clause.mp4
45.6 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/22 - Analytics functions Rollup and Cube functions English.vtt
4.7 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/22 - Analytics functions Rollup and Cube functions.mp4
84.1 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/23 - Analytics function Demonstration Rollup and Cube functions English.vtt
4.2 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/23 - Analytics function Demonstration Rollup and Cube functions.mp4
44.1 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/23 - chapter-4-rollup-cube.txt
285 B
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/24 - Analytics Function Select statement Hierarchical English.vtt
4 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/24 - Analytics Function Select statement Hierarchical.mp4
77.5 MB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/24 - heirarchial-sql.txt
561 B
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/25 - Analytics Functions Select Statement Demonstration Hierarchical English.vtt
2.5 KB
~Get Your Files Here !/11 - Analytics function used in Data warehousing Business Intelligence/25 - Analytics Functions Select Statement Demonstration Hierarchical.mp4
23.6 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/26 - Different Types of Joins Natural and equi joins English.vtt
4.8 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/26 - Different Types of Joins Natural and equi joins.mp4
83.4 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/27 - chapter-5-equi-joins.txt
923 B
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/27 - Demonstration 1 Natural and equi joins English.vtt
3.4 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/27 - Demonstration 1 Natural and equi joins.mp4
26.8 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/28 - Demonstration 2 Natural and Equi Joins English.vtt
1.8 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/28 - Demonstration 2 Natural and Equi Joins.mp4
15.1 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/29 - Joining table to itself towards data retrieval Self Joins English.vtt
1.8 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/29 - Joining table to itself towards data retrieval Self Joins.mp4
32.5 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/30 - chapter-5-self-joins.txt
301 B
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/30 - Demonstration Self Joins English.vtt
855 B
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/30 - Demonstration Self Joins.mp4
6 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/31 - chapter-5-outer-joins.txt
889 B
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/31 - Outer Joins between tables English.vtt
3.9 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/31 - Outer Joins between tables.mp4
71.9 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/32 - Demonstration Outer joins between tables English.vtt
2.7 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/32 - Demonstration Outer joins between tables.mp4
26.4 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/33 - Lesson-6-Sub-querry.txt
577 B
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/33 - Oracle SQL What is subquery English.vtt
5.2 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/33 - Oracle SQL What is subquery.mp4
82.1 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/34 - Demonstration Subquery English.vtt
2.8 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/34 - Demonstration Subquery.mp4
16.3 MB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/35 - Other DMLs English.vtt
4.3 KB
~Get Your Files Here !/12 - Oracle SQL Retrieving Data from multiple tables JOINS/35 - Other DMLs.mp4
65.4 MB
~Get Your Files Here !/13 - Quiz 3/3 - Quiz 3.html
0 B
~Get Your Files Here !/14 - Data Definition Language/36 - Data Definition Language English.vtt
7.8 KB
~Get Your Files Here !/14 - Data Definition Language/36 - Data Definition Language.mp4
130.4 MB
~Get Your Files Here !/14 - Data Definition Language/37 - Demonstration Data definition Language English.vtt
5.2 KB
~Get Your Files Here !/14 - Data Definition Language/37 - Demonstration Data definition Language.mp4
45.1 MB
~Get Your Files Here !/14 - Data Definition Language/37 - Lesson-7-insert.txt
440 B
~Get Your Files Here !/15 - DB Schema Synonym Sequence Index Overview/38 - DB Schema Synonym Sequence Index Overview English.vtt
9 KB
~Get Your Files Here !/15 - DB Schema Synonym Sequence Index Overview/38 - DB Schema Synonym Sequence Index Overview.mp4
133.7 MB
~Get Your Files Here !/16 - Dos Dont and Tuning Sql Overview/39 - Dos Dont and Tuning Sql Overview English.vtt
8 KB
~Get Your Files Here !/16 - Dos Dont and Tuning Sql Overview/39 - Dos Dont and Tuning Sql Overview.mp4
131.2 MB
~Get Your Files Here !/17 - What is Data Dictionary/40 - What is Data Dictionary English.vtt
3.8 KB
~Get Your Files Here !/17 - What is Data Dictionary/40 - What is Data Dictionary.mp4
49.7 MB
~Get Your Files Here !/18 - Quiz 4/4 - Quiz 4.html
0 B
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/41 - DataWarehouse and Business intelligence English.vtt
11.3 KB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/41 - DataWarehouse and Business intelligence.mp4
180.5 MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/42 - Dimension models English.vtt
8.5 KB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/42 - Dimension models.mp4
148.9 MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/43 - DWH Schema Star and Snowflake schema English.vtt
2.8 KB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/43 - DWH Schema Star and Snowflake schema.mp4
49.3 MB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/44 - Fact and Dimension table English.vtt
8.5 KB
~Get Your Files Here !/19 - DataWarehouse and Business Intelligence An overview/44 - Fact and Dimension table.mp4
148.8 MB
~Get Your Files Here !/2 - Whats a business application/2 - What is business application English.vtt
9 KB
~Get Your Files Here !/2 - Whats a business application/2 - What is business application.mp4
142.9 MB
~Get Your Files Here !/2 - Whats a business application/3 - Difference between OLTP and OLAP English.vtt
2.9 KB
~Get Your Files Here !/2 - Whats a business application/3 - Difference between OLTP and OLAP.mp4
32.4 MB
~Get Your Files Here !/20 - Quiz 5/5 - Quiz 5.html
0 B
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Bonus Lecture Concluding remarks & Next steps English.vtt
4.2 KB
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Bonus Lecture Concluding remarks & Next steps.mp4
73 MB
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Data Modelling and Relational Database Design.txt
96 B
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Linux unix essentials and introduction to Shell scripting.txt
109 B
~Get Your Files Here !/21 - Bonus Lecture Concluding remarks & Next steps/45 - Oracle APEX 19 SQL PLSQL to building web application development.txt
107 B
~Get Your Files Here !/3 - Relational Database and SQL/4 - What is Relational Database English.vtt
7.1 KB
~Get Your Files Here !/3 - Relational Database and SQL/4 - What is Relational Database.mp4
120.5 MB
~Get Your Files Here !/3 - Relational Database and SQL/5 - Business flows ER diagrams and RDBMS English.vtt
5.5 KB
~Get Your Files Here !/3 - Relational Database and SQL/5 - Business flows ER diagrams and RDBMS.mp4
96.3 MB
~Get Your Files Here !/3 - Relational Database and SQL/6 - Structured Query Language Introduction English.vtt
3.8 KB
~Get Your Files Here !/3 - Relational Database and SQL/6 - Structured Query Language Introduction.mp4
50.4 MB
~Get Your Files Here !/3 - Relational Database and SQL/7 - ER Diagram Tables commonly used in this course English.vtt
2.9 KB
~Get Your Files Here !/3 - Relational Database and SQL/7 - ER Diagram Tables commonly used in this course.mp4
53.5 MB
~Get Your Files Here !/4 - What is an Oracle Instance/8 - What is an Oracle Instance English.vtt
5 KB
~Get Your Files Here !/4 - What is an Oracle Instance/8 - What is an Oracle Instance.mp4
91.7 MB
~Get Your Files Here !/5 - Quiz 1/1 - Quiz 1.html
0 B
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/10 - Oracle Apex SQL environment and dataset for learning English.vtt
5.5 KB
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/10 - Oracle Apex SQL environment and dataset for learning.mp4
34.4 MB
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/9 - Difference environment to practice Oracle SQL English.vtt
6.2 KB
~Get Your Files Here !/6 - Difference environment to practice Oracle SQL/9 - Difference environment to practice Oracle SQL.mp4
~Get Your Files Here !/8 - Oracle SQL Select Statement Filtering data using where clause/13 - Oracle SQL Select Statement Filtering data using where clause English.vtt
5.7 KB
~Get Your Files Here !/8 - Oracle SQL Select Statement Filtering data using where clause/13 - Oracle SQL Select Statement Filtering data using where clause.mp4
