Description
Become a SELECT Star (Wizard Zines) takes a different approach to the SQL query language, focusing on the internal logic of databases rather than repeating dry statements. Julia Evans explains why the structure of SQL statements can sometimes seem strange and how understanding the order in which operations are executed in a database can help you write more efficient queries. This book is designed for those who are familiar with the basic commands but are confused by complex queries or unexpected database behavior (such as how to handle NULL values).
In the second part of the book, the author moves on to more advanced concepts that are often overlooked in introductory tutorials. Using illustrative examples, he illustrates the power of “window functions,” which are crucial for temporal and comparative analysis of large data sets. The book emphasizes that SQL is not simply a language for extracting data, but a tool for structured thinking. By reading this work, the reader will learn how to force the database to perform heavy calculations to avoid transferring huge amounts of data to the application.
Book Features
- A detailed explanation of the order in which commands are executed in SQL (which is different from the order in which they are written).
- Learn how JOIN types work and their impact on combining different tables.
- Examine the specific behaviors of the NULL value and the common errors it causes in data comparisons.
- Learn Window Functions to perform advanced calculations on related rows.
- A guide to using indexes to dramatically improve query speed.
- Provide practical methods for simplifying complex, nested queries into understandable parts.
Book specifications
- Publisher: Julia Evans
- Instructor: Julia Evans
- Number of pages: 28
- Format: PDF
Headlines
Pictures
User Guide
Extract the file and run it with the appropriate software.
Download link
File(s) password: www.downloadly.ir
File size
18.9 MB
