Oracle SQL for Data Analytics and Data warehousing overview

Focused View

Guha Rajan M., B.Engg, MBA, PMP

4:32:07

9 View

1 - Introduction

1 - Course Overview Topics of coverage.mp4

03:34

2 - Whats a business application

2 - What is business application.mp4

09:59

3 - Difference between OLTP and OLAP.mp4

03:20

3 - Relational Database and SQL

4 - What is Relational Database.mp4

07:50

5 - Business flows ER diagrams and RDBMS.mp4

06:20

6 - Structured Query Language Introduction.mp4

03:59

7 - ER Diagram Tables commonly used in this course.mp4

03:24

4 - What is an Oracle Instance

8 - What is an Oracle Instance.mp4

06:02

5 - Quiz 1

1 - Quiz 1.html

6 - Difference environment to practice Oracle SQL

9 - Difference environment to practice Oracle SQL.mp4

06:28

10 - Oracle Apex SQL environment and dataset for learning.mp4

06:57

7 - Oracle SQL Select statement Arithmetic Concatenate Distinct functions

11 - Select statement Arithmetic Concatenate Distinct functions.mp4

06:07

12 - Chapter-1.txt

12 - Select Statement Demonstration Arithmetic Concatenate Distinct function.mp4

06:00

8 - Oracle SQL Select Statement Filtering data using where clause

13 - Oracle SQL Select Statement Filtering data using where clause.mp4

06:07

14 - Chapter-2.txt

14 - Demonstration Select Statement Filtering data using where clause.mp4

06:39

9 - Oracle SQL Select statement Functions

15 - Oracle SQL Select statement Functions 1.mp4

06:32

16 - Oracle SQL Select statement Demonstration Functions.mp4

06:23

16 - chapter-3-sql-sample.txt

17 - Chapter-3-nested-case-decode.txt

17 - Oracle SQL Select statement Functions 2 Nested CaseDecode.mp4

08:00

10 - Quiz 2

2 - Quiz 2.html

11 - Analytics function used in Data warehousing Business Intelligence

18 - Analytics functions Min Max Avg Nvl Std dev.mp4

07:37

19 - Analytics functions Demonstration Min Max Avg Nvl Std dev.mp4

08:43

20 - Analytics functions Group By and having clause.mp4

03:30

21 - Analytics functions Demonstration Group by and having clause.mp4

08:57

22 - Analytics functions Rollup and Cube functions.mp4

05:28

23 - Analytics function Demonstration Rollup and Cube functions.mp4

05:10

23 - chapter-4-rollup-cube.txt

24 - Analytics Function Select statement Hierarchical.mp4

05:40

24 - heirarchial-sql.txt

25 - Analytics Functions Select Statement Demonstration Hierarchical.mp4

03:19

12 - Oracle SQL Retrieving Data from multiple tables JOINS

26 - Different Types of Joins Natural and equi joins.mp4

05:47

27 - Demonstration 1 Natural and equi joins.mp4

04:16

27 - chapter-5-equi-joins.txt

28 - Demonstration 2 Natural and Equi Joins.mp4

02:30

29 - Joining table to itself towards data retrieval Self Joins.mp4

02:22

30 - Demonstration Self Joins.mp4

01:09

30 - chapter-5-self-joins.txt

31 - Outer Joins between tables.mp4

04:44

31 - chapter-5-outer-joins.txt

32 - Demonstration Outer joins between tables.mp4

03:54

33 - Lesson-6-Sub-querry.txt

33 - Oracle SQL What is subquery.mp4

06:32

34 - Demonstration Subquery.mp4

03:26

35 - Other DMLs.mp4

04:39

13 - Quiz 3

3 - Quiz 3.html

14 - Data Definition Language

36 - Data Definition Language.mp4

09:13

37 - Demonstration Data definition Language.mp4

06:48

37 - Lesson-7-insert.txt

15 - DB Schema Synonym Sequence Index Overview

38 - DB Schema Synonym Sequence Index Overview.mp4

10:32

16 - Dos Dont and Tuning Sql Overview

39 - Dos Dont and Tuning Sql Overview.mp4

09:00

17 - What is Data Dictionary

40 - What is Data Dictionary.mp4

04:46

18 - Quiz 4

4 - Quiz 4.html

19 - DataWarehouse and Business Intelligence An overview

41 - DataWarehouse and Business intelligence.mp4

13:19

42 - Dimension models.mp4

09:30

43 - DWH Schema Star and Snowflake schema.mp4

03:15

44 - Fact and Dimension table.mp4

09:30

20 - Quiz 5

5 - Quiz 5.html

21 - Bonus Lecture Concluding remarks & Next steps

45 - Bonus Lecture Concluding remarks & Next steps.mp4

04:50

45 - Data Modelling and Relational Database Design.txt

45 - Linux unix essentials and introduction to Shell scripting.txt

45 - Oracle APEX 19 SQL PLSQL to building web application development.txt

Description

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

Who is this for?

Beginner interested to get into the most sought and on-demand career in Data analytics using Oracle SQL

Student who wish to enter into the career as Oracle Developer (analytics) and get an understanding on Data warehousing / analytics

What You Need to Know?

Some programming background would be beneficial

For optimum results use headphone speaker

Does not require any installs on your laptop/ PC

More details

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 analytics
Hierarchical 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!!
Who this course is for:
Beginner interested to get into the most sought and on-demand career in Data analytics using Oracle SQL
Student who wish to enter into the career as Oracle Developer (analytics) and get an understanding on Data warehousing / analytics

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Guha Rajan M., B.Engg, MBA, PMP

Instructor's Courses

Having over 25 + years of IT industry experience (Product development, Consulting & Training). His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management. He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of Internet of things and Machine learning, AI these days. Due to his vast experience, he has crafted varied unique courses in Udemy related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.He is certified asOracle Cloud Infrastructure 2021 Architect Professional.Oracle Cloud Infrastructure 2021 Architect Associate.Oracle Cloud Infrastructure 2021 Cloud Operations Associate. Oracle Cloud Infrastructure Security 2021 Certified AssociateOracle Autonomous Database Cloud 2021 Certified SpecialistOracle Machine Learning using Autonomous Database 2021 Certified SpecialistAlso certified in Python, IOT by NPTEL (Govt of India ) recently.He holds a degree in engineering (Computer science) with MBA and a certified PMP since 2007

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.