Microsoft SQL Server Notes for Professionals

• 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