SQL Query Design Patterns and Best Practices

Index

As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.

A

Access Control List (ACL) 196

actual execution plan 125

ALTER index statement 148

AVG() function 22

Azure Data Studio

Jupyter notebooks, creating 206

notebooks 206

reference link 227

Azure environment

Azure SQL Server, creating 230-234

database, restoring 230-234

setting up 228

subscription and resource group, creating 229

Azure SQL Database 228

C

CASE expression

searched version, using in SELECT statement 47

simple version, using in SELECT statement 46

using 46

using, in HAVING statement 52-55

using, in ORDER BY statement 47-50

using, in UPDATE statement 50, 51

CAST() function

used, ...