Introduction to Data Analysis and Statistics Using SQL
3.4 (21 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,315 students enrolled

Introduction to Data Analysis and Statistics Using SQL

Hands-on Practical Data Analysis Using SQL
3.4 (21 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,315 students enrolled
Last updated 2/2018
English
English [Auto]
Current price: $86.99 Original price: $124.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 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
  • Use SQL to get Data Count
  • Use SQL to find average of a set of data
  • Use SQL to find SUM of a set of data
  • Use SQL to Group Data Sets
  • Use Ranking functions
  • Use various Analytic functions to analyse data
Course content
Expand all 31 lectures 02:11:28
+ Setting Up Database Environment
6 lectures 27:26
Download sample database
03:01
Load Sample Database into SQL Server
05:45
SQL Server Utilities Statements
04:11
Using Comments
04:27
+ SQL Aggregate Functions
9 lectures 27:46
What are aggregate functions
01:37
AVG Aggregate Functions
04:12
MIN Aggregate Functions
02:56
MAX Aggregate Functions
02:43
SUM Aggregate Functions
03:39
COUNT Aggregate Function
03:33
GROUPING Aggregate Function
04:06
VAR Aggregate Functions
02:40
VARP Aggregate Functions
02:20
+ SQL Rank Functions
6 lectures 25:41
What are Ranking functions
01:06
Rank Functions
04:45
NTILE Functions
04:47
DENSE_RANK Functions
05:38
ROW_NUMBER Functions
05:42
Implementing Multiple Ranking Functions
03:43
+ SQL Analytic Functions
10 lectures 50:35
What are analytic functions
04:45
Analytic Function Syntax
04:19
LEAD Function
07:49
LAG Function
06:35
LAST_VALUE Function
05:01
FIRST_VALUE Function
04:45
PERCENT_RANK Function
04:43
CUME_DIST Function
04:22
PERCENTILE_DISC Function
04:38
PERCENTILE_CONT Function
03:38
Requirements
  • You should be able to use a PC at beginner level
  • You should have basic knowledge of SQL
  • You should have basic knowledge of SQL Server
Description

Descriptive statistics help us understand the overall structure of data, and SQL is the most widely used language for manipulating it. Together, they can help data analysts derive better insights and make far-reaching predictions. This course provides an overview of basic descriptive statistics and analytic SQL commands you need to know to summarise data sets, find averages, count, max and min value and calculate other analytic and statistical information relating to data contained in the database.

SQL Server is a relational database management system -RDBMS developed and owned by Microsoft.Thousands of companies all over the world use SQL Server for their data solution . 
SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.

T-SQL  - Transact SQL is Microsoft's implementation of SQL.  There are a lot of similarities between them but also proprietary parts that are specific to SQL Server.
SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.
This course is a beginners guide to performing data analysis  and statistics using SQL to  interrogate SQL Server to provide answers to data related questions.  You will learn to write useful SQL queries that is applicable to the Real World  production environment.
Everywhere data is being collected, every transaction, every web page visit, every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.

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.

Topic covered include:

  • Install SQL Server 2017
  • Load sample database
  • Introduction to Aggregate Functions
  • AVG
  • MIN
  • MAX
  • SUM
  • COUNT
  • GROUPING
  • VAR
  • VARP
  • Introduction to Ranking Functions
  • RANK
  • NTILE
  • DENSE_RANK
  • ROW_NUMBER
  • Introduction to Analytic Functions
  • LEAD
  • LAG
  • LAST_VALUE
  • FIRST_VALUE
  • PERCENT_RANK
  • CUM_DIST
  • PERCENTILE_DISC
  • PERCENTILE-CONT
Who this course is for:
  • Beginner DBA
  • Beginner Data Analyst
  • Beginner Systems Analyst
  • Anyone who wants to learn something new