Microsoft SQL Server Notes for Professionals book (FREE DOWNLOAD)
Microsoft SQL Server Notes for Professionals book (FREE DOWNLOAD)
DESCRIPTION
Chapters
- 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 different versions (2000 - 2016)
- SQL Server Management Studio (SSMS)
- Managing Azure SQL Database
- System database - TempDb
- Microsoft SQL Server Management Studio Shortcut Keys
