Learning Microsoft SQL Server

by Stack Overflow Community

DescriptionTable of ContentsDetailsHashtagsReport an issue

Book Description

Microsoft SQL Server is a relational database management system developed by Microsoft. It is an unofficial and free Microsoft SQL Server ebook created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow.

This open book is licensed under a Creative Commons License (CC BY-SA). You can download Learning Microsoft SQL Server ebook for free in PDF format (2.7 MB).

Table of Contents

Chapter 1
Getting started with Microsoft SQL Server
Chapter 2
Advanced options
Chapter 3
Aggregate Functions
Chapter 4
Alias Names in Sql Server
Chapter 5
Analyzing a Query
Chapter 6
Backup and Restore Database
Chapter 7
Basic DDL Operations in MS SQL Server
Chapter 8
bcp (bulk copy program) Utility
Chapter 9
BULK Import
Chapter 10
CASE Statement
Chapter 11
CLUSTERED COLUMNSTORE
Chapter 12
COALESCE
Chapter 13
Common Language Runtime Integration
Chapter 14
Common Table Expressions
Chapter 15
Computed Columns
Chapter 16
Converting data types
Chapter 17
CREATE VIEW
Chapter 18
cross apply
Chapter 19
Cursors
Chapter 20
Data Types
Chapter 21
Database permissions
Chapter 22
Database Snapshots
Chapter 23
Dates
Chapter 24
DBCC
Chapter 25
DBMAIL
Chapter 26
Delimiting special characters and reserved words
Chapter 27
Drop Keyword
Chapter 28
Dynamic data masking
Chapter 29
Dynamic SQL
Chapter 30
Dynamic SQL Pivot
Chapter 31
Encryption
Chapter 32
Export data in txt file by using SQLCMD
Chapter 33
File Group
Chapter 34
Filestream
Chapter 35
FOR JSON
Chapter 36
FOR XML PATH
Chapter 37
Foreign Keys
Chapter 38
Full-Text Indexing
Chapter 39
Generating a range of dates
Chapter 40
GROUP BY
Chapter 41
IF...ELSE
Chapter 42
Index
Chapter 43
In-Memory OLTP (Hekaton)
Chapter 44
Insert
Chapter 45
INSERT INTO
Chapter 46
Installing SQL Server on Windows
Chapter 47
Isolation levels and locking
Chapter 48
Join
Chapter 49
JSON in Sql Server
Chapter 50
Last Inserted Identity
Chapter 51
Limit Result Set
Chapter 52
Logical Functions
Chapter 53
Managing Azure SQL Database
Chapter 54
MERGE
Chapter 55
Microsoft SQL Server Management Studio Shortcut Keys
Chapter 56
Migration
Chapter 57
Modify JSON text
Chapter 58
Move and copy data around tables
Chapter 59
Natively compiled modules (Hekaton)
Chapter 60
NULLs
Chapter 61
OPENJSON
Chapter 62
ORDER BY
Chapter 63
OVER Clause
Chapter 64
Pagination
Chapter 65
Parsename
Chapter 66
Partitioning
Chapter 67
Permissions and Security
Chapter 68
PHANTOM read
Chapter 69
PIVOT / UNPIVOT
Chapter 70
Primary Keys
Chapter 71
Privileges or Permissions
Chapter 72
Queries with JSON data
Chapter 73
Query Hints
Chapter 74
Query Store
Chapter 75
Querying results by page
Chapter 76
Ranking Functions
Chapter 77
Resource Governor
Chapter 78
Retrieve information about the database
Chapter 79
Retrieve Information about your Instance
Chapter 80
Row-level security
Chapter 81
Scheduled Task or Job
Chapter 82
Schemas
Chapter 83
SCOPE_IDENTITY()
Chapter 84
SELECT statement
Chapter 85
Sequences
Chapter 86
Service broker
Chapter 87
Sorting/ordering rows
Chapter 88
Spatial Data
Chapter 89
Split String function in Sql Server
Chapter 90
SQL Server Evolution through different versions (2000 - 2016)
Chapter 91
SQL Server Management Studio (SSMS)
Chapter 92
SQLCMD
Chapter 93
Stored Procedures
Chapter 94
Storing JSON in SQL tables
Chapter 95
String Aggregate functions in SQL Server
Chapter 96
String Functions
Chapter 97
Subqueries
Chapter 98
System database - TempDb
Chapter 99
Table Valued Parameters
Chapter 100
Temporal Tables
Chapter 101
The STUFF Function
Chapter 102
Transaction handling
Chapter 103
Transaction isolation levels
Chapter 104
Trigger
Chapter 105
TRY/CATCH
Chapter 106
UNION
Chapter 107
Use of TEMP Table
Chapter 108
User Defined Table Types
Chapter 109
Variables
Chapter 110
Views
Chapter 111
WHILE loop
Chapter 112
Window functions
Chapter 113
With Ties Option

Book Details

Subject
Computer Science
Publisher
RIP Tutorial
Published
2019
Pages
361
Edition
1
Language
English
PDF Size
2.7 MB
License
CC BY-SA

Related Books

Data Science with Microsoft SQL Server 2016
R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic capab...
Microsoft SQL Server Notes for Professionals
The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
SQL Server Internals: In-Memory OLTP
The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server h...
Migrating SQL Server Databases to Azure
SQL Server is Microsoft's relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a service (PaaS)....
Introducing Microsoft SQL Server 2016
Build your database management knowledge with the technical open book, Introducing SQL Server 2016. Get an overview of the SQL Server 2016 features - from in-memory performance and enhanced security to end-to-end mobile business intelligence and advanced analytics. Learn about faster queries, improved security, higher availability, and state-of-...
SQL Server Hardware
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. Relational databases place heavy demands on their underlying hardware and many of these databases are mission-...