Microsoft SQL Server ebook for professionals

Download free Microsoft SQL Server tutorial course in PDF, training file in 112 chapters and 286 pages. Free unaffiliated ebook created from Stack OverFlow contributor.

Table of contents

  • About
  • Getting started with Microsoft SQL Server
  • INSERT / SELECT / UPDATE / DELETE: the basics of Data Manipulation Language
  • SELECT all rows and columns from a table
  • UPDATE Speci?c Row
  • DELETE All Rows
  • Comments in code
  • PRINT
  • Select rows that match a condition
  • UPDATE All Rows
  • TRUNCATE TABLE
  • Retrieve Basic Server Information
  • Create new table and insert records from old table
  • Using Transactions to change data safely
  • Getting Table Row Count
  • Data Types
  • Exact Numerics
  • Approximate Numerics
  • Date and Time
  • Character Strings
  • Unicode Character Strings
  • Binary Strings
  • Other Data Types
  • Converting data types
  • TRY PARSE
  • TRY CONVERT
  • TRY CAST
  • Cast
  • Convert
  • User De?ned Table Types
  • creating a UDT with a single int column that is also a primary key
  • Creating a UDT with multiple columns
  • Creating a UDT with a unique constraint:
  • Creating a UDT with a primary key and a column with a default value:
  • SELECT statement
  • Basic SELECT from table
  • Filter rows using WHERE clause
  • Sort results using ORDER BY
  • Group result using GROUP BY
  • Filter groups using HAVING clause
  • Returning only ?rst N rows
  • Pagination using OFFSET FETCH
  • SELECT without FROM (no data souce)
  • Alias Names in SQL Server
  • Giving alias after Derived table name
  • Using AS
  • Using =
  • Data Types
  • User Defined Table Types
  • Alias Names in SQL Server
  • Variables
  • Generating a range of dates
  • COALESCE
  • CASE Statement
  • MERGE
  • Views
  • TRY/CATCH
  • OVER Clause
  • ORDER BY
  • JSON in SQL Server
  • FOR JSON
  • Storing JSON in SQL tables
  • FOR XML PATH
  • cross apply
  • Common Table Expressions
  • Limit Result Set
  • With Ties Option
  • Logical Functions
  • String Aggregate functions in SQL Server
  • Window functions
  • Dynamic SQL Pivot
  • Stored Procedures
  • Split String function in SQL Server
  • Primary Keys
  • Last Inserted Identity
  • Sequences
  • Full-Text Indexing
  • 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 different versions (2000 - 2016)
  • SQL Server Management Studio (SSMS)
  • Managing Azure SQL Database
  • System database - TempDb
  • Microsoft SQL Server Management Studio Shortcut Keys

It is a free Microsoft SQL Server ebook created for beginners. The content is extracted from Stack Overflow pltaform, which is written by many Microsoft SQL Server developers and contributors.

The content is released under Creative Commons BY-SA

Size : 2.64 MB
File type : pdf
Downloads: 400
Created: 2019-04-30

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

Others Microsoft SQL Server Tutorials

Others related eBooks about Microsoft SQL Server ebook for professionals

The Linux Commands Handbook

Download free course The Linux Commands Handbook, pdf file on 135 pages by Flavio Copes....

Windows 10 IT Pro Essentials: Top 10 Tools

Download free course Windows 10 IT Pro Essentials: Top 10 Tools, pdf file on 165 pages by Ed Bott....

Just Enough Linux

Download free course Just Enough Linux, pdf file on 264 pages by Malcolm Maclean....

Ten Steps to Linux Survival - Bash for Windows People

Linux systems are everywhere today, even in companies once considered "pure Windows." If you're a sysadmin, network administrator, or developer in a small Windows shop, you may have to jump in and fix a system problem when your site goes down. What if you have no Linux knowledge? This short guide ...

Linux Command Line for You and Me

The command line is a text interface for your computer. It's a program that takes in commands, which it passes on to the computer's operating system to run. Linux command line for you and me is a open book for newcomers to command line environment. ...

Azure Tips and Tricks

When I reflect back on Azure Tips and Tricks a year ago, I was only thinking that I'd writ..., download free Azure tutorial in PDF (67 pages) created by Michael Crump ....

Getting started with Windows 8

Learn more about how operating systems work, check out Understanding Operating Systems and Getting started with Windows 8 Basics tutorial....

Operating Systems: From 0 to 1

This book helps you gain the foundational knowledge required to write an operating system ..., download free Operating Systems tutorial in PDF (309 pages) created by Tu Do Hang ....

Linux From Scratch

What is Linux From Scratch? Linux From Scratch (LFS) is a set of books that provides you with step-by-step instructions for building your own customized Linux system entirely from source. ...

Windows 10 IT Pro Essentials: Support Secrets

Download free course Windows 10 IT Pro Essentials: Support Secrets, pdf file on 125 pages by Ed Bott....