Data Analysis- Filter Sort Data in SQL Server, SSMS T-SQL

Data Analysis: Filter & Sort Data in SQL Server, SSMS T-SQL, available at $19.99, has an average rating of 4.38, with 21 lectures, based on 8 reviews, and has 2433 subscribers.

You will learn about Learn how to Setup SQL Server Connect to SQL Server using SSMS Install sample database Filter data using equality filters Filter data using comparison filters Filter data using logical filters Filter data using string filters Filter data using NULL Filters Sort data in ascending order Sort data in descending order This course is ideal for individuals who are Beginner Data Analyst or Beginner Data Scientist It is particularly useful for Beginner Data Analyst or Beginner Data Scientist.

Enroll now: Data Analysis: Filter & Sort Data in SQL Server, SSMS T-SQL

Summary

Title: Data Analysis: Filter & Sort Data in SQL Server, SSMS T-SQL

Price: $19.99

Average Rating: 4.38

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Learn how to Setup SQL Server

Connect to SQL Server using SSMS

Install sample database

Filter data using equality filters

Filter data using comparison filters

Filter data using logical filters

Filter data using string filters

Filter data using NULL Filters

Sort data in ascending order

Sort data in descending order

Who Should Attend

Beginner Data Analyst

Beginner Data Scientist

Target Audiences

Beginner Data Analyst

Beginner Data Scientist

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database , Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.

T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.

Sorting is the process of arranging data into meaningful order so that you can analyse it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. You can sort text data into alphabetical order. sort numeric data into numerical order. 

The ORDER BY keyword is used to sort the result-set in ascending or descending order.  The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis.

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. . SQL WHERE clause is used to extract only those results from a SQL statement, such as: SELECT , INSERT , UPDATE , or DELETE statement. Using the WHERE clause t you can filter data.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Overview of Data Analysis: Filter & Sort Data in SQL Server, SSMS T-SQL

Lecture 2: Introduction

Lecture 3: What is SQL Server

Lecture 4: What is SSMS

Lecture 5: What is T-SQL

Chapter 2: SQL Server Setup

Lecture 1: Download SQL Server

Lecture 2: Install SQL Server

Lecture 3: Install SSMS

Lecture 4: Connect to SQL Server

Lecture 5: Download Sample Database

Chapter 3: Data Analysis: Filtering Data

Lecture 1: Introduction

Lecture 2: Filter data with basic equality filters

Lecture 3: Filter data with basic comparison filters

Lecture 4: Filter data with logical comparison

Lecture 5: Filter data with String Comparison

Lecture 6: Filter data with NULL Comparison

Chapter 4: Data Analysis: Sorting data

Lecture 1: Introduction

Lecture 2: ORDER BY Clause

Lecture 3: Sort by ascending

Lecture 4: Sort by descending

Lecture 5: Sort by multiple columns

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 2 votes

5 stars: 4 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!