Introduction to using SQL for Reporting
4.6 (7 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.
2,051 students enrolled

Introduction to using SQL for Reporting

Learn how to use SQL to generate reports that can be helpful to a business.
4.6 (7 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.
2,051 students enrolled
Last updated 4/2018
English
English [Auto]
Current price: $76.99 Original price: $109.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 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
  • Install database
  • Install TOAD
  • Install SQL Developer
  • Connect TOAD to Oracle
  • Order reporting data output
  • Limit reporting data output
  • Filter data with WHERE clause
  • Filter with various operators and WHERE clause
  • Generate output from sub -queries
  • Understand views and dual tables
  • Understand character functions
  • Understand conversion functions
  • Understand date functions
  • Understand numeric functions
  • Understand and use Aggregate functions
  • Eliminate duplicates from reporting output.
Course content
Expand all 38 lectures 03:47:27
+ Setting Up Database and Query Tools
8 lectures 52:57
Unlock Sample Oracle HR Schema
05:04
Install TOAD
07:09
Connecting TOAD to Oracle
06:38
Install SQL Developer
08:55
Connect SQL Developer to Oracle
06:05
+ Ordering and Limiting Results
13 lectures 01:13:00
Specifying the table with FROM clause
02:51
Using WHERE clause to filter records
06:31
Some Operators used with WHERE clause - Part 1
07:02
Some Operators used with WHERE clause - Part 2
06:33
View and DUAL tables
06:06
Using LIKE to filter results
09:18
Finding out empty values.
07:51
Ordering with the ORDER BY clause
04:02
Retrieving results from multiple columns
02:40
Removing duplicates from results
03:07
Limiting the number of results
02:59
Using SUB-Queries
08:38
+ Working with single Row Functions
5 lectures 26:04
Character Functions
07:50
Conversion Functions
06:48
Numeric Functions
05:25
Date Functions
05:02
+ Aggregating Results
6 lectures 26:36
Counting Results
04:40
Summing Values
05:00
Getting Maximum Values
03:13
Grouping Results
07:35
+ Some Real - World SQL Reporting Examples
6 lectures 48:50
Generating a report for employee count
03:27
Generating a report for distinct salaries
06:24
Generating a report showing people with same job titles
07:42
Produce a report with a specified criteria
08:53
Generating a salary report
09:40
Generating a report showing hire date
12:44
Requirements
  • Basic knowledge of SQL
  • Basic knowledge of relational database
Description

SQL can be used to generate reports and present information on websites. This course covers  SQL features in helping you answer more interesting questions about your data.

The most popular business problems  can be solved with SQL . What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions can bee translated from the database using SQL into useful reports for the business.

Topics covered includes:

  • Installing Oracle database
  • Installing TOAD
  • Installing SQL developer
  • Connecting TOAD and SQL Developer to Oracle Database
  • Ordering and Limiting results
  • Filtering data using the WHERE clause
  • Using multiple operators with the WHERE clause
  • How to use Views and Dual Tables
  • Using Like operators with wild cards to achieve search patterns
  • Removing duplicates records
  • Using sub-queries 
  • Using character functions
  • Using conversion functions
  • Using numeric functions
  • Using date functions
  • Grouping results
  • Aggregate functions
  • Some real world SQL reporting

What Am I Going To Get from This SQL Reporting  Course?

  • You'll discover how  to use various built in features of SQL to generate useful for reports that can help a business make important decisions.

Who Should Take This Course?

  • Beginning database analysts
  • Developers who want to keep their knowledge of SQL current
  • Students taking classes in relational databases
  • Anyone who wants to learn SQL Reporting
Who this course is for:
  • ​Beginning database analysts
  • Developers who want to keep their knowledge of SQL current
  • Students taking classes in relational databases
  • Anyone who wants to learn SQL Reporting