SQL Server: Learn SQL Server in 1 Day

SQL Server is a leading Relational Database Management System by Microsoft. SQL Server supports the standard ANSI SQL (Structured Query Language). language. SQL Server also comes with its own implementation of the SQL language, T-SQL (Transact-SQL).

Here is what is covered in the book –

Chapter 1: What is SQL Server? Introduction, History, Editions, Instances

What is SQL Server?
History SQL Server
SQL Server Editions
MS SQL Server as Client-Server Architecture
Key Components and Services of SQL Server
SQL Server Instances

Chapter 2: How to Download and Install SQL Server

Chapter 3: SQL Server Architecture

Protocol Layer - SNI
Relational Engine
Storage Engine

Chapter 4: SQL Server Management Studio (SSMS): What is, Install, Versions

Download and Install SQL Server Management Studio
How to access ""Management Studio.""
Access ""Management studio"" using Command line.
Introduction to Data Management Studio IDE

Chapter 5: SQL Server Database: Create, Alter, Drop, Restore

Rules to Create a Database
Create Database using SQL Server Management Studio
Create Database with T-SQL
How to Alter Database
Alter Database with SQL Server Management Studio

Chapter 6: SQL Server DataTypes: Varchar, Numeric, Date Time [T-SQL Examples]

What is Datatype?
Why use DataTypes?
Data type available in MS SQL

Chapter 7: SQL Server Variable: Declare, Set, Select, Global,Local [TSQL Examples]

What is Variable?
Types of Variable: Local, Global
How to DECLARE a variable
Assigning a value to a VARIABLE

Chapter 8: SQL Server Table: CREATE, ALTER, DROP [T-SQL Examples]

What is a Table?
How to Create a Table
Alter Table
Delete Table

Chapter 9: SQL Server PRIMARY KEY: T-SQL Examples

Chapter 10: SQL Server FOREIGN KEY: T-SQL Examples

Chapter 11: SQL Server IF…ELSE Statement: T-SQL Example

IF… Else statement
IF statement with No Else
Nested IF…Else Statements

Chapter 12: CASE statement in SQL Server: T-SQL Example

Overview of Case in real life!
What is CASE?
Simple CASE
Searched CASE
Difference between Simple and searched case
Nested CASE: CASE in IF ELSE

Chapter 13: SQL Server SUBSTRING() Function: T-SQL Example

Chapter 14: SQL SERVER JOINS Tutorial: INNER, LEFT, RIGHT, OUTER

Chapter 15: Create Login, User, assign Permission: SQL Server Tutorial

How to Create a Login
How to create a User
Assigning Permission to a User

Chapter 16: Oracle Vs. SQL Server: Key Differences

What is Microsoft SQL server?
What is Oracle Database?
Early History of Microsoft SQL:
Early History of Oracle:
Features of Microsoft SQL Server
Features of Oracle
Difference between SQL Server and Oracle

Chapter 17: SSIS Tutorial for Beginners: What is, Architecture, Best Practices

What Is SSIS?
Why we use SSIS?
History of SIS
SSIS Salient Features
SSIS Architecture
SSIS Tasks Types
Other Important ETL tools