Microsoft SQL Server Installation 2017

Introduction To Database

Create, Alter, Drop Database Using SQL Syntax

Create, Alter, Drop Database Using GUI

Introduction To Data Types

Create, Alter, Drop Table Using SQL Syntax

Create, Alter, Drop Table Using GUI

Data Manipulation Language (DML)

Insert Statement

Update Statement

Delete Statement

Select Statement Part 1

Select Statement Part 2

Select Statement Part 3

Select Statement Part 4

Select Statement Part 5

Advance Table Concepts Part 1

Advance Table Concepts Part 2

Advance Table Concepts Part 3

Advance Table Concepts Part 4

SQL Comments

Introduction To Joins

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

Cross Join

Self Join

Stored Procedure Part 1

Stored Procedure Part 2

SQL Injection And Advantages of Stored Procedure

Functions

Built-in Functions Part 1

Built-in Functions Part 2

User Defined Function

Temp Tables

View

Trigger Part 1

Trigger Part 2

Examples

Answers 1-15

Answers 16-30

Answers 31- 35