What you'll learn:
- Basic of querying in T-SQL with SQL Server
In this course we'll cover basics of SQL querying and concepts with SQLServer. 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