Oracle SQL for Data Analytics and Data warehousing overview
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6 students enrolled

Oracle SQL for Data Analytics and Data warehousing overview

Learn about enhanced functions of Oracle SQL for Data analytics and get an overview about Data warehousing
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6 students enrolled
Last updated 11/2019
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 45 lectures 04:32:07
+ Relational Database and SQL
4 lectures 21:33
Business flows, ER diagrams and RDBMS
06:20
ER Diagram - Tables commonly used in this course
03:24
+ What is an Oracle Instance?
1 lecture 06:02
What is an Oracle Instance?
06:02
+ Difference environment to practice Oracle SQL
2 lectures 13:25
Difference environment to practice Oracle SQL
06:28
Oracle Apex SQL environment and dataset for learning
06:57
+ Oracle SQL : Select statement - Arithmetic, Concatenate, Distinct functions
2 lectures 12:07
Select statement - Arithmetic, Concatenate, Distinct functions
06:07
Select Statement - Demonstration - Arithmetic, Concatenate, Distinct function
06:00
+ Oracle SQL: Select Statement - Filtering data - using where clause
2 lectures 12:46
Oracle SQL: Select Statement - Filtering data - using where clause
06:07
Demonstration Select Statement - Filtering data - using where clause
06:39
+ Oracle SQL: Select statement - Functions
3 lectures 20:55
Oracle SQL: Select statement - Functions 1
06:32
Oracle SQL: Select statement - Demonstration - Functions
06:23
Oracle SQL: Select statement - Functions 2 - Nested, Case,Decode
08:00
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 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