Microsoft SQL Server Notes for Professionals
Hello Developers! Today I will share with you such awesome notes
if you follow and practice the notes properly. You will not have to face any
more problems with Microsoft SQL Server, Inshallah.
So let's discuss Microsoft SQL Server notes in
detail.
List of Contents
Chapter 1:
Getting Started with Microsoft SQL Server
Chapter 2: Data
Types
Chapter 3: Converting Data Types
Chapter 4: User-Defined Table Types
Chapter 5: SELECT
statement
Chapter 6: Alias
Names in SQL Server
Chapter 7: NULLs
Chapter 8: Variables
Chapter 9: Dates
Chapter 10: Generating
a range of dates
Chapter 11: Database
Snapshots
Chapter 12: COALESCE
Chapter 13: IF…ELSE
Chapter 14: CASE
Statement
Chapter 15: INSERT
INTO
Chapter 16: MERGE
Chapter 17: CREATE
VIEW
Chapter 18: Views
Chapter 19: UNION
Chapter 20: TRY/CATCH
Chapter 21: WHILE
loop
Chapter 22: OVER
Clause
Chapter 23: GROUP
BY
Chapter 24: ORDER
BY
Chapter 25: The
STUFF Function
Chapter 26: JSON
in SQL Server
Chapter 27: OPENJSON
Chapter 28: FOR
JSON
Chapter 29: Queries
with JSON data
Chapter 30: Storing
JSON in SQL tables
Chapter 31: Modify
JSON text
Chapter 32: FOR
XML PATH
Chapter 33: Join
Chapter 34: cross
apply
Chapter 35: Computed
Columns
Chapter 36: Common
Table Expressions
Chapter 37: Move
and copy data around tables
Chapter 38: Limit
Result Set
Chapter 39: Retrieve
Information about Your Instance
Chapter 40: With
Ties Option
Chapter 41: String
Functions
Chapter 42: Logical
Functions
Chapter 43: Aggregate
Functions
Chapter 44: String
Aggregate Functions in SQL Server
Chapter 45: Ranking
Functions
Chapter 46: Window
functions
Chapter 47: PIVOT
/ UNPIVOT
Chapter 48: Dynamic
SQL Pivot
Chapter 49: Partitioning
Chapter 50: Stored
Procedures
Chapter 51: Retrieve
information about the database
Chapter 52: Split
String function in SQL Server
Chapter 53: Insert
Chapter 54: Primary
Keys
Chapter 55: Foreign
Keys
Chapter 56: Last
Inserted Identity
Chapter 57: SCOPE_IDENTITY()
Chapter 58: Sequences
Chapter 59: Index
Chapter 60: Full-Text
Indexing
Chapter 61: Trigger
Chapter 62: Cursor
Chapter 63: Transaction Isolation Levels
Chapter 64: Advanced
Options
Chapter 65: Migration
Chapter 66: Table
Valued Parameters
Chapter 67: DBMAIL
Chapter 68: In-Memory
OLTP (Hekaton)
Chapter 69:
Temporal Tables
Chapter 70: Use
of TEMP Table
Chapter 71:
Scheduled Task or Job
Chapter 72:
Isolation levels and locking
Chapter 73:
Sorting/ordering rows
Chapter 74: Privileges
or Permissions
Chapter 75:
SQLCMD
Chapter 76:
Resource Governor
Chapter 77:
File Group
Chapter 78:
Basic DDL Operations in MS SQL Server
Chapter 79:
Subqueries
Chapter 80:
Pagination
Chapter 81:
CLUSTERED COLUMNSTORE
Chapter 82:
Parsename
Chapter 83:
Installing SQL Server on Windows
Chapter 84:
Analyzing a Query
Chapter 85:
Query Hints
Chapter 86:
Query Store
Chapter 87:
Querying results by page
Chapter 88:
Schemas
Chapter 89:
Backup and Restore Database
Chapter 90:
Transaction Handling
Chapter 91:
Natively compiled modules (Hekaton)
Chapter 92:
Spatial Data
Chapter 93:
Dynamic SQL
Chapter 94:
Dynamic data masking
Chapter 95:
Export data in Txt file by using SQLCMD
Chapter 96:
Common Language Runtime Integration
Chapter 97:
Delimiting special characters and reserved words
Chapter 98:
DBCC
Chapter 99:
BULK Import
Chapter 100:
Service broker
Chapter 101:
Permissions and Security
Chapter 102:
Database permissions
Chapter 103:
Row-level security
Chapter 104:
Encryption
Chapter 105:
PHANTOM read
Chapter 106:
Filestream
Chapter 107:
bcp (bulk copy program) Utility
Chapter 108:
SQL Server Evolution through different versions (2000 - 2016)
Chapter 109:
SQL Server Management Studio (SSMS)
Chapter 110:
Managing Azure SQL Database
Chapter 111:
System database – TempDb
Appendix A:
Microsoft SQL Server Management Studio Shortcut Keys
|
Notes Details |
|
|
Notes
Name |
Microsoft
SQL Server Notes for Professional |
|
Publisher |
GoalKicker |
|
Total
Chapter |
111 |
|
Total
Pages |
273 |
|
Category |
Free
Programming E-book |
[Preview ##eye##] [Download ##download##]
Disclaimer!
This is an unofficial free book created for educational purposes and is not
affiliated with official Microsoft SQL Server groups or companies. All
trademarks and registered trademarks are registered trademarks are the property
of their respective owners.
