1. Home
  2. » Database
  3. » Microsoft SQL Server Notes for Professionals

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

SQL Server Backup and Restore

SQL injection: attacks and defenses

MySQL tutorial for professionals

SQL queries Tutorial

SQL in 21 days

Others related eBooks about Microsoft SQL Server Notes for Professionals

Oracle Database Notes for Professionals

This book is the definitive guide to undocumented and partially-documented features of the Oracle Database server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to Oracle databases. It is packed with of experience over deca...

Learning Microsoft SQL Server

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

MySQL Notes for Professionals

MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out exampl...

Graph Databases, 2nd Edition

Discover how graph databases can help you manage and query highly connected data. With thi..., download free Graph Databases tutorial in PDF (238 pages) created by ....

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

Graph Databases For Beginners

Download free course Graph Databases For Beginners, pdf file on 46 pages by Bryce Merkl Sasaki, Joy Chao, Rachel Howard....

Migrating SQL Server Databases to Azure

Download free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....

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

SQL Server Backup and Restore

Download free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....

PostgreSQL Shell Commands free PDF

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


Categories