Learn SQL Server in 24 Hours

Learn SQL Server in 24 Hours

by Alex Nordeen
Publication Date: 23/11/2020

Share This eBook:

  $17.05

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



  1. What is SQL Server?

  2. History SQL Server

  3. SQL Server Editions

  4. MS SQL Server as Client-Server Architecture

  5. Key Components and Services of SQL Server

  6. SQL Server Instances


Chapter 2: How to Download and Install SQL Server


Chapter 3: SQL Server Architecture



  1. Protocol Layer - SNI

  2. Relational Engine

  3. Storage Engine


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



  1. Download and Install SQL Server Management Studio

  2. How to access ""Management Studio.""

  3. Access ""Management studio"" using Command line.

  4. Introduction to Data Management Studio IDE


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



  1. Rules to Create a Database

  2. Create Database using SQL Server Management Studio

  3. Create Database with T-SQL

  4. How to Alter Database

  5. Alter Database with SQL Server Management Studio


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



  1. What is Datatype?

  2. Why use DataTypes?

  3. Data type available in MS SQL


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



  1. What is Variable?

  2. Types of Variable: Local, Global

  3. How to DECLARE a variable

  4. Assigning a value to a VARIABLE


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



  1. What is a Table?

  2. How to Create a Table

  3. Alter Table

  4. 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



  1. IF… Else statement

  2. IF statement with No Else

  3. Nested IF…Else Statements


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



  1. Overview of Case in real life!

  2. What is CASE?

  3. Simple CASE

  4. Searched CASE

  5. Difference between Simple and searched case

  6. 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



  1. How to Create a Login

  2. How to create a User

  3. Assigning Permission to a User


Chapter 16: Oracle Vs. SQL Server: Key Differences



  1. What is Microsoft SQL server?

  2. What is Oracle Database?

  3. Early History of Microsoft SQL:

  4. Early History of Oracle:

  5. Features of Microsoft SQL Server

  6. Features of Oracle

  7. Difference between SQL Server and Oracle


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



  1. What Is SSIS?

  2. Why we use SSIS?

  3. History of SIS

  4. SSIS Salient Features

  5. SSIS Architecture

  6. SSIS Tasks Types

  7. 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.

ISBN:
1230004365136
1230004365136
Category:
Database programming
Publication Date:
23-11-2020
Language:
English
Publisher:
Guru99

This item is delivered digitally

Reviews

Be the first to review Learn SQL Server in 24 Hours.