This book takes you further on your journey to mastering SQL querying with MySQL. Step by step, you learn how to build on your existing knowledge and understand the subtleties of the MySQL flavor of the standard database query language.
No matter what your current level of SQL knowledge, this book helps you improve your existing proficiency and gives you the confidence to handle any SQL querying challenge. If you are coming to MySQL from another database, then this book helps you transition smoothly to MySQL, as well as deepening your knowledge of many of the more advanced MySQL query techniques.
In an age in which data is key, you need to ensure that you have the right skills to analyze your data and produce the insight that gives you the competitive edge. So get ahead with SQL using the dozens of practical and enjoyable examples and the methodical and comprehensive approach that this book provides.
To smooth the learning curve, all the sample data used in the book, as well as all the essential query snippets, are available online at www.tetraspublishing.com.
|Publisher:||Tetras Publishing Ltd|
|Product dimensions:||7.50(w) x 9.25(h) x 0.81(d)|
Table of Contents
Chapter 1: Subqueries
Chapter 2: Derived Tables
Chapter 3: Common Table Expressions
Chapter 4: Correlated Subqueries
Chapter 5: Dataset Manipulation
Chapter 6: Using SQL for More Advanced Calculations
Chapter 7: Segmenting and Classifying Data
Chapter 8: Rolling Analysis
Chapter 9: Analyzing Data over Time
Chapter 10: Complex Data Output