Oracle SQL for Data Analytics and Data warehousing overview

Oracle SQL for Data Analytics and Data warehousing overview, available at $39.99, has an average rating of 4, with 46 lectures, 5 quizzes, based on 4 reviews, and has 31 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner interested to get into the most sought and on-demand career in Data analytics using Oracle SQL or Student who wish to enter into the career as Oracle Developer (analytics) and get an understanding on Data warehousing / analytics It is particularly useful for Beginner interested to get into the most sought and on-demand career in Data analytics using Oracle SQL or Student who wish to enter into the career as Oracle Developer (analytics) and get an understanding on Data warehousing / analytics.

Enroll now: Oracle SQL for Data Analytics and Data warehousing overview

Summary

Title: Oracle SQL for Data Analytics and Data warehousing overview

Price: $39.99

Average Rating: 4

Number of Lectures: 46

Number of Quizzes: 5

Number of Published Lectures: 45

Number of Published Quizzes: 5

Number of Curriculum Items: 51

Number of Published Curriculum Objects: 50

Original Price: ?1,199

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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

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!!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview – Topics of coverage

Chapter 2: Whats a business application?

Lecture 1: What is business application

Lecture 2: Difference between OLTP and OLAP

Chapter 3: Relational Database and SQL

Lecture 1: What is Relational Database?

Lecture 2: Business flows, ER diagrams and RDBMS

Lecture 3: Structured Query Language – Introduction

Lecture 4: ER Diagram – Tables commonly used in this course

Chapter 4: What is an Oracle Instance?

Lecture 1: What is an Oracle Instance?

Chapter 5: Quiz 1

Chapter 6: Difference environment to practice Oracle SQL

Lecture 1: Difference environment to practice Oracle SQL

Lecture 2: Oracle Apex SQL environment and dataset for learning

Chapter 7: Oracle SQL : Select statement – Arithmetic, Concatenate, Distinct functions

Lecture 1: Select statement – Arithmetic, Concatenate, Distinct functions

Lecture 2: Select Statement – Demonstration – Arithmetic, Concatenate, Distinct function

Chapter 8: Oracle SQL: Select Statement – Filtering data – using where clause

Lecture 1: Demonstration Select Statement – Filtering data – using where clause

Lecture 2: Oracle SQL: Select Statement-Filtering date – using where clause with Operators

Chapter 9: Oracle SQL: Select statement – Functions

Lecture 1: Oracle SQL: Select statement – Functions 1

Lecture 2: Oracle SQL: Select statement – Demonstration – Functions

Lecture 3: Oracle SQL: Select statement – Functions 2 – Nested, Case,Decode

Chapter 10: Quiz 2

Chapter 11: Analytics function used in Data warehousing / Business Intelligence

Lecture 1: Analytics functions – Min, Max, Avg, Nvl, Std dev

Lecture 2: Analytics functions – Demonstration – Min, Max, Avg, Nvl, Std dev

Lecture 3: Analytics functions – Group By and having clause

Lecture 4: Analytics functions – Demonstration – Group by and having clause

Lecture 5: Analytics functions – Rollup and Cube functions

Lecture 6: Analytics function – Demonstration – Rollup and Cube functions

Lecture 7: Analytics Function – Select statement – Hierarchical

Lecture 8: Analytics Functions – Select Statement – Demonstration – Hierarchical

Chapter 12: Oracle SQL : Retrieving Data from multiple tables – JOINS

Lecture 1: Different Types of Joins – Natural and equi joins

Lecture 2: Demonstration 1 – Natural and equi joins

Lecture 3: Demonstration 2 – Natural and Equi Joins

Lecture 4: Joining table to itself towards data retrieval – Self Joins

Lecture 5: Demonstration – Self Joins

Lecture 6: Outer Joins between tables

Lecture 7: Demonstration – Outer joins between tables

Lecture 8: Oracle SQL: What is subquery

Lecture 9: Demonstration – Subquery

Lecture 10: Other DMLs

Chapter 13: Quiz 3

Chapter 14: Data Definition Language

Lecture 1: Data Definition Language

Lecture 2: Demonstration – Data definition Language

Chapter 15: DB – Schema, Synonym, Sequence, Index – Overview

Lecture 1: DB – Schema, Synonym, Sequence, Index – Overview

Chapter 16: Dos, Dont and Tuning Sql – Overview

Lecture 1: Dos, Dont and Tuning Sql – Overview

Chapter 17: What is Data Dictionary?

Lecture 1: What is Data Dictionary?

Chapter 18: Quiz 4

Chapter 19: DataWarehouse and Business Intelligence : An overview

Lecture 1: DataWarehouse and Business intelligence

Lecture 2: Dimension models

Lecture 3: DWH Schema – Star and Snowflake schema

Lecture 4: Fact and Dimension table

Chapter 20: Quiz 5

Chapter 21: Bonus Lecture: Concluding remarks & Next steps

Lecture 1: Bonus Lecture: Concluding remarks & Next steps

Instructors

Guha Rajan M., B.Engg, MBA
Founder and CEO – Capstone Solutions, Trainer

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 0 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!