SQL Server For Beginners - Part 3

Sql Server querying essentials and concepts

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.

1. 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