HOT
blank

SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS

IT & Software

SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS, available at $84.99, has an average rating of 4.75, with 71 lectures, based on 29 reviews, and has 1387 subscribers.

Rating4.8
Enroll Now

You will learn about Extract | Combine Data From Different Tables Sorting Data Filtering Data Aggregating and Grouping Data Data Analysis using SET Operators Data Analysis using Analytic Functions Build 27 Real World Data Analysis SQL Queries This course is ideal for individuals who are Beginners Data Analyst or Beginner Data Scientist It is particularly useful for Beginners Data Analyst or Beginner Data Scientist.

Enroll now: SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS

Summary

Title: SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS

Price: $84.99

Average Rating: 4.75

Number of Lectures: 71

Number of Published Lectures: 71

Number of Curriculum Items: 71

Number of Published Curriculum Objects: 71

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

  • Extract | Combine Data From Different Tables
  • Sorting Data
  • Filtering Data
  • Aggregating and Grouping Data
  • Data Analysis using SET Operators
  • Data Analysis using Analytic Functions
  • Build 27 Real World Data Analysis SQL Queries

Who Should Attend

  • Beginners Data Analyst
  • Beginner Data Scientist

Target Audiences

  • Beginners Data Analyst
  • Beginner Data Scientist

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL,MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server’s version of SQL is known as Transact-SQL  (T-SQL).    In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way.

T-SQL is also popularly referenced to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database.  But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: What is SQL

Lecture 4: What is MS SQL (T-SQL)

Lecture 5: SQL Server Hardware and Software Requirements

Lecture 6: SQL Server Editions

Lecture 7: Download SQL Server

Lecture 8: Install SQL Server

Lecture 9: Install SSMS

Lecture 10: Connect SSMS to SQL Server

Lecture 11: Install Sample database

Lecture 12: Basic database concepts

Chapter 2: Filtering Data

Lecture 1: Introduction

Lecture 2: Filtering data with basic equality filters

Lecture 3: Filtering data with basic comparisons

Lecture 4: Filtering data with logical comparisons

Lecture 5: Filtering data with String Comparisons

Lecture 6: Filtering data with NULL Comparisons

Chapter 3: Sorting Data

Lecture 1: Introduction

Lecture 2: Order By Clause

Lecture 3: Sorting by ascending

Lecture 4: Sorting by descending

Lecture 5: Sorting by multiple columns

Chapter 4: Extract | Combine Data From Different Tables

Lecture 1: Introduction

Lecture 2: Why Table Joins are necessary

Lecture 3: Using INNER Join

Lecture 4: Using LEFT Outer Join

Lecture 5: Using Right Outer Join

Chapter 5: Aggregating and Grouping Data

Lecture 1: Introduction

Lecture 2: Using COUNT ( ) Aggregate Function

Lecture 3: Using AVG ( ) Aggregate Function

Lecture 4: Using MAX ( ) Aggregate Function

Lecture 5: Using MIN ( ) Aggregate Function

Lecture 6: Using SUM ( ) Aggregate Function

Lecture 7: Using VAR Function

Lecture 8: Using VARP Function

Lecture 9: Using Multiple Aggregate Functions

Lecture 10: Grouping Data

Chapter 6: Data Analysis using SET Operators

Lecture 1: What are SET Operators

Lecture 2: Query Data with EXCEPT

Lecture 3: Query Data with INTERSECT

Lecture 4: Query Data with UNION

Chapter 7: Data Analysis using Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Syntax for Analytic Functions

Lecture 3: CUME_DIST Function

Lecture 4: Row Number Functions

Lecture 5: Rank Functions

Lecture 6: NTILE Function

Lecture 7: Using LEAD Function

Lecture 8: Using the LAG Function

Lecture 9: Using FIRST_VALUE Function

Lecture 10: Using LAST_VALUE Function

Lecture 11: Using PERCENT_RANK Function

Lecture 12: Using PERCENT_COUNT Function

Lecture 13: Using PERCENTILE_DISC Function

Chapter 8: 27 Real World Data Analysis SQL Queries

Lecture 1: Download Sample Database

Lecture 2: Install Sample Database

Lecture 3: Data Analysis of Countries with Customers

Lecture 4: Data Analysis of Customer Contact Titles

Lecture 5: Data Analysis of Customers and Employee Count

Lecture 6: Data Analysis of Employee Full Name

Lecture 7: Data Analysis of Customer First Order

Lecture 8: Data Analysis of discontinued products

Lecture 9: Data Analysis of Shippers

Lecture 10: Data Analysis of Most and least expensive products

Lecture 11: Data Analysis of Orders placed

Lecture 12: Data Analysis of Orders shipped to specific countries

Lecture 13: Data Analysis of products stock

Lecture 14: Data Analysis of specific products

Lecture 15: Data Analysis of Total price

Lecture 16: Data Analysis of Sales Reps

Instructors

Rating Distribution

  • 1 stars: 2 votes
  • 2 stars: 1 votes
  • 3 stars: 2 votes
  • 4 stars: 9 votes
  • 5 stars: 15 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!

You may also like

Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024

Top 10 Smart Home Technology Courses to Learn in November 2024

Top 10 Agile Methodologies Courses to Learn in November 2024