Microsoft SQL Server Notes for Professionals

Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community.

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.

Table of contents

Getting started with Microsoft SQL Server
Data Types
Converting data types
User Defined Table Types
SELECT statement
Alias Names in SQL Server
NULLs
Variables
Dates
Generating a range of dates
Database Snapshots
COALESCE
IF...ELSE
CASE Statement
INSERT INTO
MERGE
CREATE VIEW
Views
UNION
TRY/CATCH
WHILE loop
OVER Clause
GROUP BY
ORDER BY
The STUFF Function
JSON in SQL Server
OPENJSON
FOR JSON
Queries with JSON data
Storing JSON in SQL tables
Modify JSON text
FOR XML PATH
Join
cross apply
Computed Columns
Common Table Expressions
Move and copy data around tables
Limit Result Set
Retrieve Information about your Instance
With Ties Option
String Functions
Logical Functions
Aggregate Functions
String Aggregate functions in SQL Server
Ranking Functions
Window functions
PIVOT / UNPIVOT
Dynamic SQL Pivot
Partitioning
Stored Procedures
Retrieve information about the database
Split String function in SQL Server
Insert
Primary Keys
Foreign Keys
Last Inserted Identity
SCOPE_IDENTITY()
Sequences
Index
Full-Text Indexing
Trigger
Cursors
Transaction isolation levels
Advanced options
Migration
Table Valued Parameters
DBMAIL
In-Memory OLTP (Hekaton)
Temporal Tables
Use of TEMP Table
Scheduled Task or Job
Isolation levels and locking
Sorting/ordering rows
Privileges or Permissions
SQLCMD
Resource Governor
File Group
Basic DDL Operations in MS SQL Server
Subqueries
Pagination
CLUSTERED COLUMNSTORE
Parsename
Installing SQL Server on Windows
Analyzing a Query
Query Hints
Query Store
Querying results by page
Schemas
Backup and Restore Database
Transaction handling
Natively compiled modules (Hekaton)
Spatial Data
Dynamic SQL
Dynamic data masking
Export data in txt file by using SQLCMD
Common Language Runtime Integration
Delimiting special characters and reserved words
DBCC
BULK Import
Service broker
Permissions and Security
Database permissions
Row-level security
Encryption
PHANTOM read
Filestream
bcp (bulk copy program) Utility
SQL Server Evolution through diffferent versions (2000 - 2016)
SQL Server Management Studio (SSMS)
Managing Azure SQL Database
System database - TempDb
Microsoft SQL Server Management Studio Shortcut Keys

Pages :	285
Size :	2.7 MB
File type :	PDF
Downloads:	237
Created:	2022-02-03
License:	CC BY-SA
Author(s):	Stack Overflow Community

Microsoft SQL Server Notes for Professionals

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others sql Tutorials

MySQL Notes for Professionals

SQL Notes for Professionals

MySQL – Create Database free PDF

SQL Server Internals: In-Memory OLTP

SQL in 21 days

Others related eBooks about Microsoft SQL Server Notes for Professionals

Introduction to SQL Server 2008

This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....

Introduction to SQL

This tutorial is a brief overview about SQL language and free training document courses under 39 pages for beginners....

How To Manage a Redis Database

This book aims to provide an approachable introduction to Redis concepts by outlining many..., download free Redis Database tutorial in PDF (95 pages) created by Mark Drake ....

Microsoft Access course

This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....

Graph Databases For Beginners

Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....

SQL Server Hardware

Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....

SQL Server Internals: In-Memory OLTP

Download free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....

Download Oracle training document

This pdf tutorial provides a complet lessons about Oracle in order to become familiar with Oracle architecture and able to managinig database....

Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web Applications

Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. ...

Mastering SQL Queries for SAP Business One

SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers..., download free SQL Queries tutorial in PDF (352 pages) created by Gordon Du ....