You're reading from SQL Query Design Patterns and Best Practices A practical guide to writing readable and maintainable SQL queries using its design patterns

Product type Paperback

Published in Mar 2023

Publisher Packt

ISBN-13 9781837633289

Length 270 pages

Edition 1st Edition

Languages

SQL

Tools

Jupyter

Concepts

Database Programming

Authors (6):

Chi Zhang

Steven Hughes

Shabbir Mala

Dennis Neer

Leslie Andrews

Ram Babu Singh

+2 more

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: Refining Your Queries to Get the Results You Need

2. Chapter 1: Reducing Rows and Columns in Your Result Sets FREE CHAPTER

3. Chapter 2: Efficiently Aggregating Data

4. Chapter 3: Formatting Your Results for Easier Consumption

5. Chapter 4: Manipulating Data Results Using Conditional SQL

6. Part 2: Solving Complex Business and Data Problems in Your Queries

7. Chapter 5: Using Common Table Expressions

8. Chapter 6: Analyze Your Data Using Window Functions

9. Chapter 7: Reshaping Data with Advanced Techniques

10. Chapter 8: Impact of SQL Server Security on Query Results

11. Part 3: Optimizing Your Queries to Improve Performance

12. Chapter 9: Understanding Query Plans

13. Chapter 10: Understanding the Impact of Indexes on Query Design

14. Part 4: Working with Your Data on the Modern Data Platform

15. Chapter 11: Handling JSON Data in SQL Server

16. Chapter 12: Integrating File Data and Data Lake Content with SQL

17. Chapter 13: Organizing and Sharing Your Queries with Jupyter Notebooks

18. Index

Why subscribe?

19. Other Books You May Enjoy

Appendix: Preparing Your Environment

Prerequisites for running the exercises

Technical requirements

To work with the examples and illustrations in this chapter, you will need Azure Data Studio or SQL Server Management Studio installed. We will be working with the WideWorldImportersDW database on SQL Server or Azure SQL Database. Please refer to the Appendix for tool installation and database restoration guidance.

You will find the code from this chapter here on GitHub: https://github.com/PacktPublishing/SQL-Query-Design-Best-Practices/tree/main/Chapter03

Using the FORMAT() function

FORMAT() is an extremely versatile function for changing how certain strings, dates, and numeric values look. We will consider a few popular things we can do with FORMAT() in this section.

For the examples in this section, we will mainly leverage the dimension date table and the fact sales table from the WideWorldImportersDW database discussed in previous chapters to showcase date and number formatting possibilities. Let’s check out some of the possibilities in...

The rest of the chapter is locked

You're reading from SQL Query Design Patterns and Best Practices A practical guide to writing readable and maintainable SQL queries using its design patterns

Table of Contents (21) Chapters

Technical requirements

Using the FORMAT() function

Authors (7)

Personalised recommendations for you

You're reading from SQL Query Design Patterns and Best Practices A practical guide to writing readable and maintainable SQL queries using its design patterns

Table of Contents (21) Chapters

Technical requirements

Using the FORMAT() function

Unlock this book and the full library FREE for 7 days

Authors (7)

Personalised recommendations for you