Practical T-SQL Pocket Guide For Beginners

A simple but comprehensive introduction to T-SQL for aspiring business analytics professionals.

Author: Bob Wakefield

Preface

I. A Note From The Author	II. Tutorial Overview
III. Running The Examples	IV. How To Report An Issue
V. Join The MSU Community On Discord	VI. Supplimentery Material

1. Obligatory Hello World	2. Code Comments
3. Basic Syntax	4. Your First Query
5. Filtering Data	6. Sorting Data
7. Complex Data Filtering	8. Aliases
9. String Functions	10. Creating New Columns From Existing Data (Calculated Fields)
11. Displaying Data Based On Conditions (Case Statement)	12. Aggregate Functions
13. Grouping And Summarizing Data	14. Querying More Than One Table
15. Combining Queries	16. Subqueries
17. Creating Data	18. Updating Data
19. Deleting Data	20. Common Table Expressions (CTEs)
21. Derived Tables	22. Putting It All Together

45. Listing All Tables In A SQL Server Database	46. Listing All Columns In A SQL Server Database
47. Pull Records From A Table At Random	48. A Better Alternative To WITH (NOLOCK)
49. Boost Performance When Calling A Stored Proc From SSIS	50. Setting Up Queries For Ablation Testing
51. Reduce Code And Save Time With Default Column Values	52. Finding Duplicate Records In A Table
53. Why You Cannot Have More Than One Clustered Index On A Table	54. Converting Dates To YYYYMMDD
55. Sending Notification Emails With T-SQL Without Using Hardcoded Email Addresses	56. Troubleshooting Long Running Queries
57. Loading Large CSVs Into Data Warehouse Staging Tables	58. The Only Bloody Good Reason To Use Cursors (AKA Moving Large Amounts Of Data Between Tables)
59. Loading A Type II Slowly Changing Dimension With SQL Merge	60. A Clearer Explanation Of The Parameters Of The Numeric Data Type
61. Why You Cannot Join On Null Values	62. A Deep Dive On How The Where Clause Functions
63. Using HASHBYTES() To Compare Character Strings	64. Using Pipe To Hash Multiple Columns For Matching
65. Why People That Indent Code Drive Me Nuts (AKA A Recommended SQL Style Guide)	66. How To Rapidly Stand Up A Data Warehouse From Scratch
67. How To Pivot Data With T-SQL When Columns Are Not Predefined	68. Prepopulating A Junk Dimension