About this book
This book will take you on an interactive journey to understand SQL querying from the most basic to the most expert level utilising a variety of SQL techniques to extract relevant insights from your MySQL databases.The first section of this book serves as an introduction to the fundamental ideas of both SQL and MySQL. It then walks readers through constructing queries using simple and then more sophisticated table joins and gradually more advanced data filtering to produce advanced queries based on a range of SQL techniques. The reader will better understand MySQL database analysis by mastering the fundamentals of SQL computation, relational logic, and data grouping and aggregation. SQL fundamentals such as query formatting, constructing subqueries, generating derived tables, joining and filtering tables, etc., are also covered. In addition, the book explains how to do rolling analysis, study time-series data, and manage huge and complex MySQL datasets.After completing the book, readers can create their methods for analysing relational MySQL datasets and gaining the needed 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
- Acknowledgements
- Errata
- Table of Contents
- Introduction
- 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 MySQL
- 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 MySQL
- Appendix B: Installing MySQL Workbench
- Appendix C: Setting Up the Sample Database
- Index