Microsoft SQL Server Notes for Professionals
Table of contents
- 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
| Pages | 285 |
|---|---|
| Size | 2.7 MB |
| File type | |
| Downloads | 375 |
| Created | 2022-02-03 |
| License | CC BY-SA |
| Author(s) | Stack Overflow Community |
Others sql tutorials
Others related eBooks about Microsoft SQL Server Notes for Professionals
-
Database Design, 2nd Edition
This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. ...
-
Learning SQLite
Download SQLite tutorial in PDF format, document created by StackOverFlow intended to beginners....
-
Quick Guide to SQL Server Management Studio
This PDF tutorial will teachs you how to install and use SQL Server Management Studio from Home using VPN,it's a free training courses for beginners...
-
Learning MySQL
Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL....
-
SQL in 21 days
This tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download ....
-
Tutorial Oracle Database 11g: SQL Fundamentals in PDF
Download tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....
-
Introducing Microsoft SQL Server 2016
Download free course Introducing Microsoft SQL Server 2016, pdf file on 215 pages by Stacia Varga, Denny Cherry, Joseph D'Antoni....
-
Graph Databases For Beginners
Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....
-
Microsoft SQL Server 2012
This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft....
-
Essential SQL
This book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....