Price: ¥2,750 Thank you for viewing. This is a beautiful item, read only once. Please assess the condition based on the photos. We look forward to your purchase if you understand that this is a used item. [Overview] ● A masterpiece SQL problem book is born! A book to train your mind. This book is a collection of "new SQL puzzles (practice problems)" by Mr. Mick, who has been highly praised for his DB-related books, condensing the knowledge he has cultivated in his practical work. Instead of just tracing sample code, the goal is to grasp the essence of SQL by having the reader work with their hands and think while solving the problems. The puzzles included gradually increase in level from basic to advanced, and widely cover standard SQL that is essential in practice, such as window functions, joins, CASE expressions, subqueries, and recursion. In addition to the answers, the book carefully explains the thought process of "how to think" and "how to write alternative solutions," and by comparing multiple ways of writing, you can cultivate an "eye for aesthetics" to select better SQL. Furthermore, some problems also delve into execution plans, and are designed to help you understand the optimal way of writing from the perspective of processing performance. This book is for beginners to intermediate users, and it is a book that allows you to train your "ability to think about SQL" without difficulty and steadily. [Sneak peek at the puzzles in this book!] ■ Chapter 1 SQL as a Declarative Language Puzzle 1-1 The absolute law of the database - Primary key constraint Puzzle 1-2 Who is the boss? - Referential integrity constraint and others ■ Chapter 2 The Logic of SQL Puzzle 2-1 Work request - Universal quantification ① Puzzle 2-2 Generation of natural number sequences - Recursion and construction and others ■ Chapter 3 Advanced Applications of SQL Puzzle 3-1 Tracking the transition of addresses - Recursion and pointer chain Puzzle 3-2 Combinations of possible dates - Combination of columns and others ■ Chapter 4 Solving Mathematical Puzzles with SQL Puzzle 4-1 Permutations - Self-non-equality join Puzzle 4-2 Perfect numbers - Conditions in the HAVING clause and others ■ Chapter 5 Window Functions - Working Magic with SQL Puzzle 5-1 Moving average - Basics of window functions Puzzle 5-2 90%ile 3 seconds - Percentile and others ■ Chapter 6 Handling Tree Structures with SQL Puzzle 6-1 Adjacency list model Puzzle 6-2 Nested set model and others ■ Chapter 7 Graduation Exam Puzzle 7-1 Specifying conditions for all columns - Universal quantification / existential quantification Puzzle 7-2 Pizza shop sales - Selection by rank and others