About this book
This book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data.The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides readers through the process of building queries, using simple and then more complex table joins and progressively more advanced data filtering, to deliver advanced queries based on a variety of SQL techniques. The reader will understand how to deliver relevant and trustworthy analysis of the data through learning how to apply fundamental computations in T-SQL, relational logic, and how to group and aggregate data. There is also coverage of other SQL concepts, such as formatting queries, writing subqueries, creating derived tables, joining and filtering tables, etc. In addition to that, the book discusses how to conduct rolling analyses, examine time-series data, and manage large and complex datasets.After finishing the book, readers won't merely be able to write complex queries; rather, they will be able to construct their methodology for analysing relational datasets and arriving at the desired insights.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover Page
- Title Page
- Copyright Page
- About the Author
- About the Reviewer
- Acknowledgement
- Preface
- Errata
- Table of Contents
- 1. Writing Basic SQL Queries
- 2. Using Multiple Tables When Querying Data
- 3. Using Advanced Table Joins
- 4. Filtering Data
- 5. Applying Complex Filters to Queries
- 6. Making Simple Calculations
- 7. Aggregating Output
- 8. Working with Dates in SQL Server
- 9. Formatting Text in Query Output
- 10. Formatting Numbers and Dates
- 11. Using Basic Logic to Enhance Analysis
- 12. Subqueries
- 13. Derived Tables
- 14. Common Table Expressions
- 15. Correlated Subqueries
- 16. Dataset Manipulation
- 17. Using SQL for More Advanced Calculations
- 18. Segmenting and Classifying Data
- 19. Rolling Analysis
- 20. Analyzing Data Over Time
- 21. Complex Data Output
- Appendix A: Installing SQL Server
- Appendix B: Installing SQL Server Management Studio
- Appendix C: Setting Up the Sample Database
- Index