Beginner Data Analysis Using SQL and Microsoft SQL Server
4.2 (21 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.
901 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Beginner Data Analysis Using SQL and Microsoft SQL Server to your Wishlist.

Add to Wishlist

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.2 (21 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.
901 students enrolled
Last updated 3/2017
English
Current price: $10 Original price: $115 Discount: 91% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 11 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • Basic understanding of database concepts
  • Basic SQL Knowledge
  • Basic T-SQL Knowledge
Description

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 .

.

Who is the target audience?
  • New Database Administrators
  • Aspiring SQL developers
  • Aspiring Data warehouse professionals
  • Aspiring Data Analyst
  • Aspiring database administrators(DBA)
  • Aspiring Data Scientist
  • Support Engineers
  • Enterpreneurs
Students Who Viewed This Course Also Viewed
Curriculum For This Course
40 Lectures
02:49:58
+
Installing SQL Server and Sample Database
7 Lectures 33:27




Download Nortwind Database
04:35

How to attach Northwind Database to SQL Server
05:10

Using SSMS
06:28
+
Data Analysis Using SQL Examples For The Real World
22 Lectures 02:15:23
Employee Age with Date Time
05:40

Customer Contact Titles
06:22

Customer and Employee Count
04:17

Countries with Customers
05:40

Getting Data from multiple Tables
07:52

Full Employee Name Data
06:40

Employee BirthDate in Age Order
06:41

Query to show Sales Reps
07:03

Restricted Fields
07:05

Query to show Sales Reps in a country
06:04

Query to check specific products
06:25

Query to get suppliers details
07:51

Query to Check Products Stock
07:24

Query to check orders Shipped
07:17

Query to check orders shipped to Latin America
04:19

Total Price Query
06:21

Most and least expensive product query
05:46

Orders placed query
06:59

List of Shippers Query
05:42

List of Discontinued products query
05:32


First order placed query
04:52
+
Practice Exercises
11 Lectures 01:10
Exercise 1
00:05

Exercise 2
00:06

Exercise 3
00:06

Exercise 4
00:06

Exercise 5
00:06

Exercise 6
00:05

Exercise 7
00:06

Exercise 8
00:05

Exercise 9
00:06

Exercise 10
00:06

Exercise 11
00:08
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,548 Reviews
35,061 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.