Introduction to Data Analysis and Statistics Using SQL

Introduction to Data Analysis and Statistics Using SQL, available at $39.99, has an average rating of 2.85, with 38 lectures, based on 25 reviews, and has 2332 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner DBA or Beginner Data Analyst or Beginner Systems Analyst or Anyone who wants to learn something new It is particularly useful for Beginner DBA or Beginner Data Analyst or Beginner Systems Analyst or Anyone who wants to learn something new.

Enroll now: Introduction to Data Analysis and Statistics Using SQL

Summary

Title: Introduction to Data Analysis and Statistics Using SQL

Price: $39.99

Average Rating: 2.85

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginner DBA
Beginner Data Analyst
Beginner Systems Analyst
Anyone who wants to learn something new

Target Audiences

Beginner DBA
Beginner Data Analyst
Beginner Systems Analyst
Anyone who wants to learn something new

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

Course Curriculum

Chapter 1: Setting Up Database Environment

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is SQL Server

Lecture 4: Download and Install SQL Server 2017

Lecture 5: Download SQL Server 2019

Lecture 6: Install SQL Server 2019

Lecture 7: Install SSMS

Lecture 8: Connect SSMS to SQL Server

Lecture 9: Download sample database

Lecture 10: Load Sample Database into SQL Server

Lecture 11: SQL Server Utilities Statements

Lecture 12: Using Comments

Chapter 2: SQL Aggregate Functions

Lecture 1: What are aggregate functions

Lecture 2: AVG Aggregate Functions

Lecture 3: MIN Aggregate Functions

Lecture 4: MAX Aggregate Functions

Lecture 5: SUM Aggregate Functions

Lecture 6: COUNT Aggregate Function

Lecture 7: GROUPING Aggregate Function

Lecture 8: VAR Aggregate Functions

Lecture 9: VARP Aggregate Functions

Chapter 3: SQL Rank Functions

Lecture 1: What are Ranking functions

Lecture 2: Rank Functions

Lecture 3: NTILE Functions

Lecture 4: DENSE_RANK Functions

Lecture 5: ROW_NUMBER Functions

Lecture 6: Implementing Multiple Ranking Functions

Chapter 4: SQL Analytic Functions

Lecture 1: What are analytic functions

Lecture 2: Analytic Function Syntax

Lecture 3: LEAD Function

Lecture 4: LAG Function

Lecture 5: LAST_VALUE Function

Lecture 6: FIRST_VALUE Function

Lecture 7: PERCENT_RANK Function

Lecture 8: CUME_DIST Function

Lecture 9: PERCENTILE_DISC Function

Lecture 10: PERCENTILE_CONT Function

Lecture 11: Thank You

Instructors

Digital Learning Academy
Digital learning 24 /7

Rating Distribution

1 stars: 3 votes
2 stars: 4 votes
3 stars: 5 votes
4 stars: 5 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu