Sql Server for Beginners - Part 2

Name: Sql Server for Beginners - Part 2
Rating: 4.4 (122 reviews)

Sql Server querying essentials and concepts

Created byBytescout Academy

Last updated 3/2020

English

What you'll learn

Basic of querying in T-SQL with SQL Server

Course content

1 section • 13 lectures • 1h 23m total length

Overview2:33
In this video, we will be going to learn about how to get started with the T-SQL fundamentals. We will see the overview of what we gonna cover in this module.
Logical Query Processing Order5:10
In this video, we will be going to learn about how in SQL Server Logical workflow used by the query processor in order to generate the related PHYSICAL process for retrieving data.
Select statement fundamentals7:35
In this video, we will be going to learn about how to query SQL Server using the SELECT statement. It is very important to understand the structure of the SELECT statement and how to use its various clauses to perform data manipulation tasks.
Filtering data with WHERE clause - Overview3:39
In this video, we will be going to learn about the fundamentals of where clause. We will see the overview of different operator that we can use with the where clause.
Filtering data with WHERE clause - Part 19:22
In this video, we will be going to learn the basic structure or syntax of the where clause and how we can filter the data using different operators such as equality operator, range operator etc. with the where clause.
Filtering data with WHERE clause - Part 26:32
In this video, we will be going to learn how we can filter the data using LIKE operator and [NOT] IN operator with the where clause.
Filtering data using WHERE clause - Part 33:24
Sorting data using ORDER BY clause9:37
Grouping data with GROUP BY clause Part-18:46
In this video, we will be going to learn the basic structure or syntax of the group by clause and In addition to this we will also learn that how we can get the unique records using the group by clause as well as using distinct clause.
Grouping data with GROUP BY clause Part-26:50
In this video, we will be going to learn about different types of aggregate function which is used with group by clause such as COUNT(), SUM() etc.
Grouping data with GROUP BY clause Part-34:39
In this video, we will be going to learn how we can filter the grouped data with Having clause which evaluates the predicate per group as opposed to per row like where clause.
Limiting data with TOP clause6:08
In this video, we will be going to learn how it help us to limits the rows returned in a query result to a specified number of rows or percentage of rows in SQL Server. In addition to this, we will also learn WITH TIES clause in which additional rows will be included if their values match, or tie, the values of the last row.
Summary and Quiz8:51
In this video, we will be revising what we have learned so far and then we will play one small interesting quiz.

Requirements

Basic knowledge on computing

Description

In this course we'll cover basics of SQL querying and concepts with SQL Server. We'll start with basics and essentials of SQL Server, followed by SQL syntax and lastly we'll delve into SQL joins and set operators.

Following is the manifest we'll be covering. Each course video is designed to be short and concept wise complete.

Learning SQL
- Overview
- Logical Query Processing Order
- Select statement fundamentals
- Filtering data with where clause - overview
- Filtering data with where clause - Part 1
- Filtering data with where clause - Part 2
- Filtering data with where clause - Part 3
- Sorting data with order by clause
- Grouping data with Group By clause - Part 1
- Grouping data with Group By clause - Part 2
- Grouping data with Group By clause - Part 3
- Limit data with top clause
- Summary and Quiz

Who this course is for:

Beginners in T-SQL