Udemy - Oracle Sql For Data Analytics And Data Warehousing Overview

seeders: 1
leechers: 30
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Oracle Sql For Data Analytics And Data Warehousing Overview
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction
    • 1 - Course Overview Topics of coverage English.vtt (2.7 KB)
    • 1 - Course Overview Topics of coverage.mp4 (53.7 MB)
    10 - Quiz 2
    • 2 - Quiz 2.html (0.0 KB)
    11 - Analytics function used in Data warehousing Business Intelligence
    • 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.0 KB)
    • 19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp4 (53.4 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 (0.3 KB)
    • 24 - Analytics Function Select statement Hierarchical English.vtt (4.0 KB)
    • 24 - Analytics Function Select statement Hierarchical.mp4 (77.5 MB)
    • 24 - heirarchial-sql.txt (0.5 KB)
    • 25 - Analytics Functions Select Statement Demonstration Hierarchical English.vtt (2.5 KB)
    • 25 - Analytics Functions Select Statement Demonstration Hierarchical.mp4 (23.6 MB)
    12 - Oracle SQL Retrieving Data from multiple tables JOINS
    • 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 (0.9 KB)
    • 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)
    • 30 - Demonstration Self Joins English.vtt (0.8 KB)
    • 30 - Demonstration Self Joins.mp4 (6.0 MB)
    • 30 - chapter-5-self-joins.txt (0.3 KB)
    • 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 (0.9 KB)
    • 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 (0.6 KB)
    • 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)
    13 - Quiz 3
    • 3 - Quiz 3.html (0.0 KB)
    14 - Data Definition Language
    • 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 (0.4 KB)
    15 - DB Schema Synonym Sequence Index Overview
    • 38 - DB Schema Synonym Sequence Index Overview English.vtt (9.0 KB)
    • 38 - DB Schema Synonym Sequence Index Overview.mp4 (133.7 MB)
    16 - Dos Dont and Tuning Sql Overview
    • 39 - Dos Dont and Tuning Sql Overview English.vtt (8.0 KB)
    • 39 - Dos Dont and Tuning Sql Overview.mp4 (131.2 MB)
    17 - What is Data Dictionary
    • 40 - What is Data Dictionary English.vtt (3.8 KB)
    • 40 - What is Data Dictionary.mp4 (49.7 MB)
    18 - Quiz 4
    • 4 - Quiz 4.html (0.0 KB)
    19 - DataWarehouse and Business Intelligence An overview
    • 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)
    2 - Whats a business application
    • 2 - What is business application English.vtt (9.0 KB)
    • 2 - What is business application.mp4 (142.9 MB)
    • 3 - Difference between OLTP and OLAP English.vtt (2.9 KB)
    • 3 - Difference between OLTP and OLAP.mp4 (32.4 MB)
    20 - Quiz 5
    • 5 - Quiz 5.html (0.0 KB)
    21 - Bonus Lecture Concluding remarks & Next steps
    • 45 - Bonus Lecture Concluding remarks & Next steps English.vtt (4.2 KB)
    • 45 - Bonus Lecture Concluding remarks & Next steps.mp4 (73.0 MB)
    • 45 - Data Modelling and Relational Database Design.txt (0.1 KB)
    • 45 - Linux unix essentials and introduction to Shell scripting.txt (0.1 KB)
    • 45 - Oracle APEX 19 SQL PLSQL to building web application development.txt (0.1 KB)
    3 - Relational Database and SQL
    • 4 - What is Relational Database English.vtt (7.1 KB)
    • 4 - What is Relational Database.mp4 (120.5 MB)
    • 5 - Business flows ER diagrams and RDBMS English.vtt (5.5 KB)
    • 5 - Business flows ER diagrams and RDBMS.mp4 (96.3 MB)
    • 6 - Structured Query Language Introduction English.vtt (3.8 KB)
    • 6 - Structured Query Langu

Description

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



Download torrent
3.1 GB
seeders:1
leechers:30
Udemy - Oracle Sql For Data Analytics And Data Warehousing Overview

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
3.1 GB
seeders:1
leechers:30
Udemy - Oracle Sql For Data Analytics And Data Warehousing Overview

Torrent hash: AF4DA396E79B81423460CC5685D9A95B0BB7687C