MsSql Server Course Content

DAY

TOPIC

Day – 1

MS SQL Server Type

Client Server Architecture

Server name/IP Address and Instance

Authentication Type

Database & Schema Overview

System Database & User database

.mdf, and .ldf file

SQL Statement Type

DDL Statement (Create, Alter, Drop, Truncate)

DML Statement (Insert, Update, Delete)

DQL Statement (Select)

DCL Statement (Create user, grant access, revoke access)

TCL Statement (Begin transaction , commit, rollback)

SQL Datatype

Where clause

Operator

Keywords : in, not in, between, not between, is null, is not null

Day – 2

Wild card/patter matching : %, _

Case when/Case statement

Order By - Ascending, Descending

Group By

Aggregate Function

Having

Keyword: Top, Distinct

Constraints & Integrity

Primary key

Foreign key

Unique

Not null

Null

Default

Check

Identity column

Composite key

Day – 3

Index & its type

Cluster index

Non-cluster index

System defined function(Aggregate, Scalar)

Mathematic Function

Text/String Function

Date-time function

Type conversion function, and other

Subquery/Nested query

Union

Union All

Day – 4

Join and its type

Inner join/Default join

Outer join/full outer join

Left join/left outer join

Right join/right outer join

Self-join

Cross join

Minus

Intersect

Day - 5

View

View - SQL Statement support

TL-SQL

SQL variable declaration

Set value

Expression

If condition

Loop

Day - 6

User defined function

Scalar function

Tabular function

Function - SQL statement support

Day – 7

Stored Procedure

Stored procedure - Parameter

In/Out parameter

Default value

Procedure multiple value/table return

Temp table #

Temp table ##

Table variable

 

Navigate to

Advertisment

ad

X

Request a call back