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
Click the BUY button now and download the book now to start learning UML. Learn it fast and learn it well.
Share This eBook: