Learn to use SQL for Data Analysis and Reporting
3.9 (17 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.
1,529 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn to use SQL for Data Analysis and Reporting to your Wishlist.

Add to Wishlist

Learn to use SQL for Data Analysis and Reporting

Introduction to Data Analysis and Reporting Using SQL and ORACLE Database
3.9 (17 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.
1,529 students enrolled
Created by Tech Academy
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Analyse data using Aggregate functions
  • Analyse data using Analytic functions
  • Analyse data using SET operators
  • Analyse data using sub-queries
  • Analyse data using table joins
  • Analyse data using Single Row functions
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • You should know how to install Oracle database
  • You should know how to install TOAD
  • You should know basic SQL
  • You should know basic database concepts
Description

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation.  SQL is vital for data analysis and reporting.

Have you wondered how you get the data you need? Do you wish you could retrieve it yourself?  This course  teaches you how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database; you'll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want.

You will learn how to design and write simple SQL queries for data reporting and analysis. Also you will learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results.
 Discover how to perform more complex queries, such as joining data together from different database tables. 
 
Topic you will learn include:

Setup a Database Environment
Understand Database Concepts
Write SQL Syntax
Understand SQL Data Types
Retrieve Data using SELECT
Filter Data search with SQL WHERE clause
Sort SQL query result search  with ORDER BY
Transform SQL Search results with string functions
Use Alias to change query results headings
Use various functions for data reporting and analysis

SQL can be used to help solve business problems like :

Who are the top ten sales-reps in each region?
How many employees in an organization
How many employees earn less than 45K in an organization
How many new employees joined the company in the past 18 months
What goods are flying off the supermarket shelves and so on..

Who is the target audience?
This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.

Who is the target audience?
  • Data Analyst
  • Data Scientist
  • Enterpreneurs
  • Data researchers
  • Graduates
  • Students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
52 Lectures
05:10:57
+
Introduction and Lab Setup
15 Lectures 01:28:40



Unlocking Sample Database Schema
03:30

Download TOAD
05:29

Install TOAD
03:33

Connect TOAD to Oracle Database
08:11

Database Concepts -Part 1
04:31

Database Concepts -Part 2
10:16

Retrieving Data with SQL SELECT Statement
05:47

Filtering Data using SQL WHERE Clause
04:16

Sorting Data using SQL ORDER BY Clause
05:54

Using Aliases
07:47

Analysing Data using Sub-Queries
08:38

Removing Duplicate Data
05:52
+
Data Analysis using Analytic Functions and Windowing Clause
15 Lectures 01:54:15
Introduction to Analytic Functions
06:43

Analytic Function Syntax
04:07

Partition BY Clause
08:04

Order By Clause
05:48

First and Last Function
08:56

Row Number Function
09:26

Dense Rank Function
05:57

Rank Function
06:04

LIST AGG Function
06:14

What is a Windowing Clause
08:06

Using Default Windowing Clause
10:52

Using Rows with Windowing Clause
11:25

using Range with Windowing Clause
07:36

Using Between with Windowing Clause
09:35

Using Multiple windows for data analysis
05:22
+
Analysing Data with Aggregate Functions
6 Lectures 20:39
Introduction
01:38

Using AVG Function
03:20

Using COUNT Function
04:40

Using MIN Function
02:48

Using MAX Function
03:13

Using SUM Function
05:00
+
Analysing Data using Table Joins
6 Lectures 43:49
Introduction
04:11

SELF Join
09:53

EQUI -Join
07:46

NON-EQUI Join
07:26

OUTER Join
08:14

CARTESIAN Join
06:19
+
Analysing Data using SET Operators
5 Lectures 17:30
Introduction
04:36

UNION
05:23

UNION ALL
02:53

INTERSECT
02:50

MINUS
01:48
+
Analysing Data using Single Row Functions
5 Lectures 26:04
Introduction
00:59

Conversion Function
06:48

Character Function
07:50

Date Function
05:02

Numeric Function
05:25
About the Instructor
Tech Academy
4.0 Average rating
79 Reviews
3,221 Students
5 Courses
Real Skills For The Real World

Tech Academy is a UK based e-learning provider that offers a range of high quality elearning solutions that teach real life  technical skills that are essential and relevant in today's commercial environment.

Our instructors have a wealth of experience in their respective courses and currently provide consultancy services to fortune 100 companies.

Our courses are presented in HD and are clear and concise to enable retention and provide intuitive learning experience for absolute beginners.