Complete Microsoft SQL Server Masterclass:Beginner to Expert 

Welcome and Introduction

Install the Microsoft SQL Server 2019 on Windows

Import a Sample Database

Install Microsoft SQL Server on Mac

SELECT Statement in SQL

Code used - SELECT Statement in SQL

SELECT DISTINCT

Code used - SELECT DISTINCT

Case with SELECT

Code used - Case with SELECT

Quiz

WHERE Clause

Code used - WHERE Clause

Comparison Operators in WHERE Clause

Code used - Comparison Operators in WHERE Clause

Arithmetic Operators in WHERE clause

Code used - Arithmetic Operators in WHERE clause

Logical Operators in WHERE clause

Code used - Logical Operators in WHERE clause

Concatenation operator(+) with WHERE clause

Code used - Concatenation operator(+) with WHERE clause

Concat() function to combine strings

Code used - concat function

IS NULL Value

Code used - IS NULL Value

Between Operator in WHERE Clause

Code used - Between Operator in WHERE Clause

Better way to tackle dates with CAST Function

Code used - Better way to tackle dates with CAST Function

IN Operator

Code used - IN Operator

Quiz

LIKE Operator with percent to match 0 or more Characters

Code used - LIKE Operator with percent to match 0 or more Characters

LIKE Operator with [...] Character classes

Code used - LIKE Operator with [...] Character classes

LIKE Operator with character range

Code used - LIKE Operator with character range

LIKE Operator with Negation Character

Code used - LIKE Operator with Negation Character

LIKE Operator with Underscore

Code used - LIKE Operator with Underscore

Test Your skills

Code used - Test Your skills

Escaping single characters

Code used - Escaping single characters

Quiz

ORDER BY Clause - Part 1

Code used - ORDER BY Clause - Part 1

ORDER BY Clause - Part 2

Code used - ORDER BY Clause - Part 2

ORDER BY clause - Part 3

Code used - ORDER BY Clause - Part 3

ORDER BY Clause - Part 4

Code used - ORDER BY Clause - Part 4

GROUP BY clause - Part 1

Code used - GROUP BY Clause - Part 1

GROUP BY clause - Part 2

Code used - GROUP BY Clause - Part 2

GROUP BY clause - Part 3

Code used - GROUP BY Clause - Part 3

Functions - Numerical Functions & Aggregate functions

sum() Function

Code used - sum() Function

avg() and count() aggregate functions

Code used - avg() and count() aggregate functions

max() and min() functions

Code used - max() and min() functions

Less used Numerical functions

Code used - Less used Numerical functions

String Functions - Part 1

Code used - String Functions - Part 1

String Functions - Part 2

Code used - String Functions - Part 2

String Functions - Part 3

Code used - String Functions - Part 3

String Functions - Part 4

Code used - String Functions - Part 4

String Functions - Part 5

Code used - String Functions - Part 5

String Functions - Part 6

Code used - String Functions - Part 6

Date Functions - Part 1

Code used - Date Functions - Part 1

Date Functions - Part 2

Code used - Date Functions - Part 2

Date Functions - Part 3

Code used - Date Functions - Part 3

Date Functions - Part 4

Code used - Date Functions - Part 4

isdate(), isnull() and isnumeric() functions

Code used - isdate(), isnull() and isnumeric() functions

coalesce(), nullif(), convert, iif() functions

Code used - coalesce, nullif, convert, iif functions

HAVING Clause

Code used - HAVING Clause

Subquery - Part 1

Code used - Subquery - Part 1

Subquery - Part 2

Code used - Subquery - Part 2

Subquery - Part 3

Code used - Subquery - Part 3

Subquery - Part 4

Code used - Subquery - Part 4

Subquery - Part 5

Code used - Subquery - Part 5

Subquery - Part 6

Code used - Subquery - Part 6

Subquery - Part 7

Code used - Subquery - Part 7

Subquery - Part 8

Code used - Subquery - Part 8

Subquery - Part 9

Code used - Subquery - Part 9

Quiz

UNION and UNION All - Part 1

UNION and UNION All - Part 2

Code used - UNION and UNION All - Part 2

UNION and UNION All - Part 3

Code used - UNION and UNION All - Part 3

UNION and UNION All - Part 4

Code used - UNION and UNION All - Part 4

UNION and UNION All - Part 5

Code used - UNION and UNION All - Part 5

INTERSECT Operator

Code used - INTERSECT Operator

EXCEPT Operator

Code used - EXCEPT Operator

Implicit Joins

Code used - Implicit Joins

INNER JOIN - Part 1

Code used - INNER JOIN - Part 1

INNER JOIN - Part 2

Code used - INNER JOIN - Part 2

LEFT JOIN - Part 1

LEFT JOIN - Part 2

Code used - LEFT JOIN - Part 2

LEFT JOIN - Part 3

Code used - LEFT JOIN - Part 3

RIGHT JOIN

Code used - RIGHT JOIN

FULL JOIN

Code used - FULL JOIN

CROSS JOIN

Code used - CROSS JOIN

Data Types in MS SQL Server

CREATE Database

Code used - CREATE Database

Naming Convention for objects in MS SQL Server

Create TABLE without constraints

Code used - Create TABLE without constraints

Create Table under retail Schema

Code used - Create Table under retail Schema

CREATE Table Statement with Constraints

CREATE TABLE with NOT NULL Constraint

Code used - CREATE TABLE with NOT NULL Constraint

CREATE TABLE with CHECK Constraint

Code used - CREATE TABLE with CHECK Constraint

CREATE TABLE with UNIQUE Constraint

Code used - CREATE TABLE with UNIQUE Constraint

CREATE TABLE with DEFAULT Constraint

Code used - CREATE TABLE with DEFAULT Constraint

CREATE TABLE with Primary Key

Code used - CREATE TABLE with Primary Key

Foreign Key - Part 1

Foreign Key - Part 2

Code used - Foreign Key - Part 2

Foreign Key - Part 3

Code used - Foreign Key - Part 3

UNIQUE INDEX with Primary and Foreign Key

Code used - UNIQUE INDEX with Primary and Foreign Key

How to Check for UNIQUE INDEX

INDEX

Code used - INDEX

INSERT Statement into table which does not have any constraint

Code used - INSERT Statement into table which does not have any constraint

INSERT Statement into table which has constraints

Code used - INSERT Statement into table which has constraints

Changing the order of columns in INSERT Statement

Code used - Changing the order of columns in INSERT Statement

INSERT Statement- Insert records into child table

Code used - INSERT Statement- Insert records into child table

UPDATE Statement

Code used - UPDATE Statement

Quiz

Views

Code used - Views

Dropping Views

Code used - Dropping Views

CREATE OR ALTER VIEW Statement

Code used - CREATE OR ALTER VIEW Statement

SELECT INTO Statement

Code used - SELECT INTO Statement

INSERT INTO Statement

Code used - INSERT INTO Statement

Details about Assignment

Details about the tables

Solution - Create table Statements to create 4 Tables

Explaining about the tables of the Assignment

ALTER Statement

ALTER ADD Statement

Code used - ALTER ADD Statement

ALTER ADD for default value

Code used - ALTER ADD for default value

ALTER Statement for modification

Code used - ALTER Statement for modification

ALTER DROP Statement

Code used - ALTER DROP Statement

RENAMING Tables and Columns

Code used - RENAMING Tables and Columns

DELETE and DROP Tables

Code used - DELETE and DROP Tables

Drop Index

Code used - Drop Index

Bonus Lesson : Let us stay connected