Learn Microsoft SQL Server

######## Learn Microsoft SQL Server ########

This app contains tutorials and reports for the all who want to learn Microsoft SQL Server. They can learn easily from this application.

Following Chapters included in this Application:

#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