Microsoft SQL Server – Beginners Guide

Introduction:

This blog aims beginners on how easily they can learn SQL Server step by step. We are trying to cover most of the topics in a simple way with lots of examples and necessary explanations. Hope you will enjoy this series and feel free to share the feedback in comment section.

Audience:

This tutorial is designed for all those readers who want to learn the fundamentals of SQL Server and put it into practice. For beginners, it helps a step by step or stairway to learn SQL Server an d for advanced and experienced, it helps to refresh the points with examples.

Prerequisites:

As this is designed for beginners, there are only two prerequisites are expected.

1. Interest to learn SQL Server

2. If you have experience in other programming language, sometimes you may need to unlearn few things and learn new things to better understanding the concepts of database management.

It is good to have SQL Server installed on your computer, as it might assist you in executing the examples yourself and get to know how it works.

Table of contents:

Microsoft SQL Server – A bit of History & Introduction

A bit of History & Introduction
TEMPDB

SQL Server – String Functions

QUOTENAME
String_split
String_AGG
LEN & DATALENGTH
LEFT & RIGHT
CHARINDEX
SOUNDEX & DIFFERENCE
STR
UPPER & LOWER

REPLACE, REPLICATE & REVERSE

SQL Server – Date Time Functions

CURRENT_TIMESTAMP
CURRENT_TIMESTAMP, GETDATE(), GATUTCDATE() & SYSDATETIME()

SQL Server – Window Functions

ROW_NUMBER()
RANK()
DENSE_RANK()

SQL Server – System Functions

PARSENAME
UPDATE
ISNULL & COALESCE
NULLIF
IIF

SQL Server – Number Functions

COUNT() & COUNT_BIG()

SQL Server – System Procedures

sp_procoption
xp_servicecontrol
sp_settriggerorder

sp_databases

Exception Handling in SQL Server

XACT_ABORT in SQL Server

SQL Server – Partitioning

Stairway to Partitioning

I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!

5 thoughts on “Microsoft SQL Server – Beginners Guide”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s