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.
SQL Joins and SET Operators
Overview
Understanding Inner Join
Understanding Outer Join
Understanding Cross Join
Understanding Self Join
UNION and UNIONALL
INTERSECT and EXCEPT
Understanding Sub-Queries