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: 234
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

PostgreSQL Shell Commands free PDF

PostgreSQL tutorial

SQL injection: attacks and defenses

Learning Microsoft SQL Server

Microsoft SQL Server 2012

Others related eBooks about Microsoft SQL Server Notes for Professionals

PostgreSQL Shell Commands free PDF

Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com....

Oracle Database 11g: SQL Fundamentals Tutorial

A complete free tutorial for download about Oracle Database 11g: SQL Fundamentals course material and training, PDF document under 500 pages for advanced users....

SQL Notes for Professionals

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

Learning Microsoft SQL Server

Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

The Definitive Guide to Graph Databases

Download free course The Definitive Guide to Graph Databases, pdf file on 30 pages by Michael Hungers, Ryan Boyd, William Lyon....

SQL Server Backup and Restore

Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....

SQL Notes for Professionals

SQL is a standard language for storing, manipulating and retrieving data in relational databases....

PostgreSQL for Beginners

PostgreSQL for Beginners book is intended for those who only start getting acquainted with..., download free PostgreSQL tutorial in PDF (142 pages) created by Pavel Luzanov ....

Microsoft Access 2013 course

Download free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....

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