SQL Server: Learn SQL Server in 1 Day

By Krishna Rungta

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 ServerSQL Server EditionsMS SQL Server as Client-Server ArchitectureKey Components and Services of SQL ServerSQL Server Instances

Chapter 2: How to Download and Install SQL Server

Chapter 3: SQL Server Architecture

Protocol Layer - SNIRelational EngineStorage Engine

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

Download and Install SQL Server Management StudioHow 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 DatabaseCreate Database using SQL Server Management StudioCreate Database with T-SQLHow to Alter DatabaseAlter 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, GlobalHow to DECLARE a variableAssigning a value to a VARIABLE

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

What is a Table?How to Create a TableAlter TableDelete 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 statementIF statement with No ElseNested IF...Else Statements

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

Overview of Case in real life What is CASE?Simple CASESearched CASEDifference between Simple and searched caseNested 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 LoginHow to create a UserAssigning 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 ServerFeatures of OracleDifference 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 SISSSIS Salient FeaturesSSIS ArchitectureSSIS Tasks TypesOther Important ETL tools

Click the BUY button now and download the book now to start learning UML. Learn it fast and learn it well.

Pick up your copy today by clicking the BUY NOW button at the top of this page

• Format: Paperback
• Language: English
• ISBN: 1695592050
• ISBN13: 9781695592056
• Release Date: September 2019
• Publisher: Independently Published
• Length: 206 Pages
• Weight: 1.08 lbs.
• Dimensions: 0.4" x 8.5" x 11.0"