Beginner Data Analysis Using SQL and Microsoft SQL Server

Beginner Data Analysis Using SQL and Microsoft SQL Server, available at $54.99, has an average rating of 4.2, with 40 lectures, based on 91 reviews, and has 5987 subscribers.

You will learn about 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 This course is ideal for individuals who are New Database Administrators or Aspiring SQL developers or Aspiring Data warehouse professionals or Aspiring Data Analyst or Aspiring database administrators(DBA) or Aspiring Data Scientist or Support Engineers or Enterpreneurs It is particularly useful for New Database Administrators or Aspiring SQL developers or Aspiring Data warehouse professionals or Aspiring Data Analyst or Aspiring database administrators(DBA) or Aspiring Data Scientist or Support Engineers or Enterpreneurs.

Enroll now: Beginner Data Analysis Using SQL and Microsoft SQL Server

Summary

Title: Beginner Data Analysis Using SQL and Microsoft SQL Server

Price: $54.99

Average Rating: 4.2

Number of Lectures: 40

Number of Published Lectures: 40

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $94.99

Quality Status: approved

Status: Live

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

Who Should Attend

New Database Administrators
Aspiring SQL developers
Aspiring Data warehouse professionals
Aspiring Data Analyst
Aspiring database administrators(DBA)
Aspiring Data Scientist
Support Engineers
Enterpreneurs

Target Audiences

New Database Administrators
Aspiring SQL developers
Aspiring Data warehouse professionals
Aspiring Data Analyst
Aspiring database administrators(DBA)
Aspiring Data Scientist
Support Engineers
Enterpreneurs

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 .

Course Curriculum

Chapter 1: Installing SQL Server and Sample Database

Lecture 1: Introduction

Lecture 2: Hardware and Software Requirements for SQL Server

Lecture 3: Download SQL Server

Lecture 4: SQL Server Installation

Lecture 5: Download Nortwind Database

Lecture 6: How to attach Northwind Database to SQL Server

Lecture 7: Using SSMS

Chapter 2: Data Analysis Using SQL Examples For The Real World

Lecture 1: Employee Age with Date Time

Lecture 2: Customer Contact Titles

Lecture 3: Customer and Employee Count

Lecture 4: Countries with Customers

Lecture 5: Getting Data from multiple Tables

Lecture 6: Full Employee Name Data

Lecture 7: Employee BirthDate in Age Order

Lecture 8: Query to show Sales Reps

Lecture 9: Restricted Fields

Lecture 10: Query to show Sales Reps in a country

Lecture 11: Query to check specific products

Lecture 12: Query to get suppliers details

Lecture 13: Query to Check Products Stock

Lecture 14: Query to check orders Shipped

Lecture 15: Query to check orders shipped to Latin America

Lecture 16: Total Price Query

Lecture 17: Most and least expensive product query

Lecture 18: Orders placed query

Lecture 19: List of Shippers Query

Lecture 20: List of Discontinued products query

Lecture 21: First order placed query

Chapter 3: Practice Exercises

Lecture 1: Exercise 1

Lecture 2: Exercise 2

Lecture 3: Exercise 3

Lecture 4: Exercise 4

Lecture 5: Exercise 5

Lecture 6: Exercise 6

Lecture 7: Exercise 7

Lecture 8: Exercise 8

Lecture 9: Exercise 9

Lecture 10: Exercise 10

Lecture 11: Exercise 11

Lecture 12: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 2 votes
2 stars: 7 votes
3 stars: 15 votes
4 stars: 34 votes
5 stars: 33 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