Beginner Data Analysis Using SQL and Microsoft SQL Server

Learn Hands-On how to build Real World SQL Queries to answer questions with data.

4.15 (89 reviews)

Udemy

platform

English

language

Databases

What you will learn

Analyse various types of data Using SQL

Analyse Data from multiple Database Tables

Sort Data for analysis

Restrict Data

Build query with Group By Clause

Build Query with Like operator and wild cards

Build query with aggregate function

Create a data model

Filter data using WHERE Clause

Build query with various types of operators

Why take this course?

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 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.

Skills You will learn include:

• How to design and write simple SQL queries for data analysis.
• How to merge data from multiple tables
• How to use aggregate functions
• How to use wild cards with SQL queries
• How to group related data
• How to Filter Data search with SQL WHERE clause
• How to Use Alias
• How to retrieve all the data from a table

In this course we will use SQL to provide answers to questions like:
How many customers or employees doe a company has?
How many sales reps does a company have?
When was the first order placed?

This course is packed with real world examples that will help you build your SQL Skills .

Screenshots

Beginner Data Analysis Using SQL and Microsoft SQL Server - Screenshot_01

Beginner Data Analysis Using SQL and Microsoft SQL Server - Screenshot_02

Beginner Data Analysis Using SQL and Microsoft SQL Server - Screenshot_03

Beginner Data Analysis Using SQL and Microsoft SQL Server - Screenshot_04

Reviews

Tom

July 5, 2023

The course really could have used a bit of structure in how the lectures were presented. Each one was less a unified whole than individual independent lectures. I was hoping for more organization and increasing sophistication of the learning as the course progressed.

Prakhar

April 1, 2021

ON point according to basics but the info is too basic as i am on lecture 14 and still writing the query for order by which was taught in like first 2-3 lectures

Antoine

January 10, 2021

In the lesson its like it was always the same exercise, we didn't learn how to create a database for example and in the exercise i wanted to have an exercise where we need to link two table thanks to the ID

Duane

August 16, 2020

It is a good beginners course. I would rate it higher if the presenter took a much more structured approach, as well as write code whilst explaining, as opposed to pasting code "in order to save time" and then explaining afterwards.

Jivesh

April 22, 2020

I work within a software environment and we use an SQL database, the tutor on this video has clarified all select scripts and data information from joint tables and which tables in the test environment can be used to to link data and generate expected reports directly from the database. I am happy and beginner i am.

Anastasios

October 11, 2019

Good. However, in every video the first 1.5 minutes are the same while most of videos show exactly the same queries. And sorry for that, but the instructor makes annoying noises with his mouth :S Its a good way though for someone who has no idea to learn the basics of sql. With this knowledge you wont be able to do what is said in the introduction.

Linda

May 8, 2019

Needs to update the section for downloading the Northwind database. The instructions are no longer valid.

John

March 24, 2017

Interesting introduction to databases in general specifically geared toT-SQL. Concepts are presented well, so that a beginner can understand and move forward.

Charts

Price

Rating

Enrollment distribution

Beginner Data Analysis Using SQL and Microsoft SQL Server - Distribution chart