Accede a nuestras Descargas Privadas

Microsoft SQL Server Notes for Professionals

Microsoft® SQL Server® Notes for Professionals book

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. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified.

Book created for educational purposes and is not affiliated with Microsoft® SQL Server® group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners.

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

Formato:  pdf Comprimido:  No Peso:  2.64 MB Lenguaje:  Inglés

Sin comentarios.

Deja tu Comentario