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: | 229 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others sql Tutorials
PostgreSQL tutorial for professionals
Oracle Advanced PL/SQL Developer Professional Guide
Others related eBooks about Microsoft SQL Server Notes for Professionals
SQL Server Backup and RestoreDownload tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....
RavenDB in ActionThe data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....
Microsoft Access courseThis PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....
SQL Notes for ProfessionalsDownload free course SQL Notes for Professionals, pdf file on 165 pages by Stack Overflow Community....
Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web ApplicationsCosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. ...
Migrating SQL Server Databases to AzureDownload free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....
The Little MongoDB BookKarl Seguin is a developer with experience across various fields and technologies. He's an..., download free MongoDB tutorial in PDF (66 pages) created by ....
Learning access-vba PDF courseDownload free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Introduction to SQL Server 2008This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....
Oracle database tutorials for professionalsDownload free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....