3 out of 5
3
56 reviews on Udemy

Beginner Data Analysis Using SQL and Microsoft SQL Server

Learn Hands-On how to build Real World SQL Queries to answer questions with data.
Instructor:
Bluelime Learning Solutions
1,906 students enrolled
English [Auto]
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

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 .

.

Installing SQL Server and Sample Database

1
Introduction
2
Hardware and Software Requirements for SQL Server
3
Download SQL Server
4
SQL Server Installation
5
Download Nortwind Database
6
How to attach Northwind Database to SQL Server
7
Using SSMS

Data Analysis Using SQL Examples For The Real World

1
Employee Age with Date Time
2
Customer Contact Titles
3
Customer and Employee Count
4
Countries with Customers
5
Getting Data from multiple Tables
6
Full Employee Name Data
7
Employee BirthDate in Age Order
8
Query to show Sales Reps
9
Restricted Fields
10
Query to show Sales Reps in a country
11
Query to check specific products
12
Query to get suppliers details
13
Query to Check Products Stock
14
Query to check orders Shipped
15
Query to check orders shipped to Latin America
16
Total Price Query
17
Most and least expensive product query
18
Orders placed query
19
List of Shippers Query
20
List of Discontinued products query
21
First order placed query

Practice Exercises

1
Exercise 1
2
Exercise 2
3
Exercise 3
4
Exercise 4
5
Exercise 5
6
Exercise 6
7
Exercise 7
8
Exercise 8
9
Exercise 9
10
Exercise 10
11
Exercise 11
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
3
3 out of 5
56 Ratings

Detailed Rating

Stars 5
18
Stars 4
23
Stars 3
7
Stars 2
6
Stars 1
2
52f46dca78de6e952d266279de8ae7cb
Course available for 2 days
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
11 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW