Oracle SQL for Analysis and Reporting: essential training
4.5 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
933 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL for Analysis and Reporting: essential training to your Wishlist.

Add to Wishlist

Oracle SQL for Analysis and Reporting: essential training

Data mining and reporting with Oracle Queries
4.5 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
933 students enrolled
Created by Neba Funwi-gabga
Last updated 3/2017
English
Current price: $10 Original price: $90 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use powerful analytic functions for business intelligence in Oracle
  • Use other powerful aggregate functions for business intelligence in Oracle
  • Use manual SQL queries to extract information from a database that answers real-life business questions
View Curriculum
Requirements
  • Have Oracle installed, preferably Oracle 11gR2 and up.
  • Download Oracle SQL Developer and the JDK and ensure that it runs.
  • You should already be familiar with simple SQL, such as writing basic SELECT statement and GROUP BY functions.
Description

This course teaches people in Database reporting, Business Intelligence or any field that requires creating database reports in Oracle how to use some of the cool functions in Oracle to answer real-world questions. Each lesson covers one or more reporting and analysis function / technique in Oracle and uses Oracle 11gR2 for demos. You will get a combination of slideshows and hands-on query exercises, including challenges and brain-teasers to help you think deeper into problems and write simple queries that answer these questions.

All the queries in this course are included for download. Also, make sure you attempt all the challenge exercises before you look at the solutions.

You should take this course if you are looking to up your game in database querying, data mining and business intelligence using SQL queries. A special section is dedicated to Analytic Functions, a really cool set of functions in Oracle that make it easy to write highly scalable, high performance queries with very little code. It starts wit an introduction of Analytic functions and then goes deeper into using these functions to answer business questions. Have fun, as more examples are uploaded to this course.

Who is the target audience?
  • This SQL is meant for anyone who has basic knowledge in writing simple SQL queries and wants to take it to the next level by exploring other robust functions built into Oracle to garner valuable information from an Oracle database that answer real-world business questions. It is not an introduction to SQL querying. If you have no knowledge of writing simple SQL, then this course is not for you.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
02:19:34
+
Basics first
3 Lectures 11:16


Download the script to install the HR schema if you don't find it pre-installed in your database, and instructions on how to install it.

Also download the SQL script that contains all the statements run in this course. With this, you can follow the course at your own pace.

Downloads
00:16
+
Exploring Data Aggregation, Temporary Tables and Conditionals in Reports
8 Lectures 22:48

Learn how to use Subqueries to resolve queries in Oracle. Use the challenge that follows to learn how to solve complex problems with correlated subqueries.

Solving problems with Subqueries
04:12

This challenge will help you understand what a correlated subquery is, and how to use correlated subqueries to answer business questions.

Subquery Challenge Solution
00:49

Flipping rows to columns is a powerful reporting tool in data analysis. If you have worked with Excel before, then you have seen the PIVOT function. learn how to use the PIVOT function in Oracle to transpose rows to column headings.

Preview 04:05

In this lesson, you will learn how to use temporary tables (Called Common Table Expressions in other databases management systems). These temporary object are really valuable in reducing query complexity, especially when dealing with aggregate functions.

Amazing power of Temporary Tables
03:58

Use this brain teaser to test your knowledge of temporary tables in oracle.

Temporary Table Brain Teaser
00:24

Evaluating conditions within a SQL Query
05:12

How to aggregate ROWS in Oracle
03:51

Row Aggregation Brain Teaser
00:16
+
Introducing Reporting and Analysis Functions in Oracle
7 Lectures 38:39
What analytic functions are
04:19


Syntax of Analytic Functions in Oracle
02:51

What the PARTITION BY clause does in Analytic Functions
09:13

What the ORDER BY clause does in Analytic Functions
03:56

Piecing the ORDER BY and PARTITION BY clauses together
03:19

Restricting rows with WINDOWING
12:04
+
Querying Hierarchical Data in Oracle
7 Lectures 31:11
Download Hierarchical Querying Script
00:02


Hierarchical statements - the CONNECT BY clause
07:36

Hierarchical statements - the START WITH keyword
05:18

Top-Down versus Bottom-Up hierarchical query
01:55

Generating complete parent-child relationship paths
08:22

Catching cyclic hierarchical relationships
05:35
+
Using PARTITION BY / RIGHT OUTER JOIN
3 Lectures 15:55
Overview and Data used
02:47

What we will accomplish
01:05

Partition by Right Outer Join Demo
12:03
+
Working with the MERGE statement
6 Lectures 19:51
Introducing the MERGE statement
02:14

Data used in this section
02:35

Revisiting regular INSERT, UPDATE, DELETE statements
01:56

The MERGE syntax
02:54

MERGE Demo I
06:07

MERGE Demo II
04:05
About the Instructor
Neba Funwi-gabga
4.2 Average rating
80 Reviews
1,658 Students
4 Courses
Database / GIS Specialist

I'm a professionally trained database developer, administrator and a Spatial Ecologist. My work experience spans multiple disciplines, including developing and maintaining databases for nonprofit organizations, performing data science tasks for research institutions, doing extensive data mining in the Oil and gas sector as well as spatial ecology. With over 10 years of experience, I currently coordinate database development for one of Canada's biggest nonprofit organizations. If you need services in oracle, PLSQL, TSQL, Python geospatial scripting or R programming, talk to me!!