SQL Query Design Patterns and Best Practices

Table of Contents

1. Reducing Rows and Columns in Your Result Sets
2. Efficiently Aggregating Data in Your Results
3. Formatting Your Results for Easier Consumption
4. Manipulating Your Data Results Using Conditional SQL
5. Using Common Table Expressions
6. Analyze Your Data Using Window Functions
7. Reshaping Your Data with Advanced Techniques
8. Impact of SQL Security on Query Results
9. Understanding Query Plans
10. Understanding the Impact of Indexes on Your Query Design
11. Handling JSON Data in SQL Server
12. Integrating File Data and Data Lake Content with SQL
13. Organizing and Sharing Your Queries with Jupyter Notebooks
14. Appendix – Preparing Your Environment