SQL Practical Training
 |
Description
Book Introduction
Life and SQL are ultimately about 'practical' situations.
“I know the basic grammar of SQL to some extent.
“It’s difficult to actually write a query… Should I study grammar more?”
What if you've mastered the principles and methods of exercise and are actually practicing them, but your body doesn't feel like it? Isn't systematic training necessary before additional learning? The same holds true for SQL. There's a gap between "knowing" SQL syntax and "solving problems" based on that knowledge, so even if you understand the syntax, actually solving problems can be challenging.
If your goal is to become a practical expert who can effectively use SQL, you should be exposed to a variety of practical problems.
In the process, any missing knowledge will be filled in naturally.
This book briefly explains the concepts and grammar of 18 core types, and then provides problems of various difficulty levels and types.
Let's think about the answer to the question and solve it together step by step.
It also presents error patterns that often lead to traps in the process.
Through this, let's now become a practical player of SQL.
“I know the basic grammar of SQL to some extent.
“It’s difficult to actually write a query… Should I study grammar more?”
What if you've mastered the principles and methods of exercise and are actually practicing them, but your body doesn't feel like it? Isn't systematic training necessary before additional learning? The same holds true for SQL. There's a gap between "knowing" SQL syntax and "solving problems" based on that knowledge, so even if you understand the syntax, actually solving problems can be challenging.
If your goal is to become a practical expert who can effectively use SQL, you should be exposed to a variety of practical problems.
In the process, any missing knowledge will be filled in naturally.
This book briefly explains the concepts and grammar of 18 core types, and then provides problems of various difficulty levels and types.
Let's think about the answer to the question and solve it together step by step.
It also presents error patterns that often lead to traps in the process.
Through this, let's now become a practical player of SQL.
- You can preview some of the book's contents.
Preview
index
Preparing the Lab Environment: Connecting MySQL and GitHub
Type 1. INNER JOIN
_Problem 1.
Basic INNER JOIN
_Problem 2.
Subqueries and INNER JOINs
_Problem 3.
Self-join
Type 2. LEFT OUTER JOIN
_Problem 1.
Basic LEFT OUTER JOIN
_Problem 2. Add a right table condition to WHERE
_Problem 3. Add a condition to ON
Type 3. CROSS JOIN
_Problem 1.
One-to-many (1:N) CROSS JOIN
_Problem 2.
Many-to-Many (N:N) CROSS JOIN
Type 4. FULL OUTER JOIN
_Problem 1.
Two LEFT OUTER JOINs and a UNION
Type 5. GROUP BY
_Problem 1.
Basic GROUP BY
_Problem 2. CASE WHEN and GROUP BY
_Problem 3.
Aggregation by partition
Type 6. HAVING
_Problem 1.
Basic HAVING
_Problem 2.
Group identifier
_Problem 3. WHERE and HAVING
_Problem 4.
Subquery HAVING
Type 7. MIN, MAX
_Problem 1.
Basic MIN, MAX
_Problem 2. Subquery using MIN and MAX
_Problem 3. Subquery using MIN and MAX
Type 8. SUM, COUNT
_Problem 1. Difference between SUM and COUNT in CASE WHEN
_Problem 2.
Cumulative total
_Problem 3.
Cumulative sum by partition
Type 9. CASE WHEN
_Problem 1. CASE WHEN and GROUP BY
_Problem 2. Multiple conditions in CASE WHEN
_Problem 3.
SUM of different THEN results
_Problem 4.
UNION of independent queries
Type 10. IFNULL
_Problem 1. LEFT OUTER JOIN and IFNULL
_Problem 2. LEFT OUTER JOIN and IFNULL
Type 11. LIMIT
_Problem 1.
Combination of basic ORDER BY and LIMIT
_Problem 2. Extracting the top rank after GROUP BY
_Problem 3. Extracting the top result after INNER JOIN and GROUP BY
Type 12. NOT IN
_Problem 1.
Basic NOT IN
_Problem 2. Subqueries of IN and NOT IN
_Problem 3. NOT IN and GROUP BY
Type 13. RANK
_Problem 1. RANK using PARTITION BY
_Problem 2. RANK using PARTITION BY
Type 14. DENSE_RANK
_Problem 1.
Default DENSE_RANK
_Problem 2.
2nd place ranking
Type 15. ROW_NUMBER
_Problem 1. Comparison of RANK, DENSE_RANK, and ROW_NUMBER
_Problem 2.
Default ROW_NUMBER
Type 16. LAG, LEAD
_Problem 1.
Basic LAG, LEAD
_Problem 2. Add a WHERE condition after LAG
_Problem 3. Adding an IF condition to SELECT after LAG
Type 17. DATE
_Problem 1. TIMESTAMP data type
_Problem 2. DATE_ADD, DATE_SUB functions
_Problem 3. DATE_FORMAT function
Type 18. CONCAT
_Problem 1.
Basic CONCAT
_Problem 2.
Basic GROUP_CONCAT
SQL Problem Set 1
SQL Problem Set 2
SQL Problem Set 3
Search
Type 1. INNER JOIN
_Problem 1.
Basic INNER JOIN
_Problem 2.
Subqueries and INNER JOINs
_Problem 3.
Self-join
Type 2. LEFT OUTER JOIN
_Problem 1.
Basic LEFT OUTER JOIN
_Problem 2. Add a right table condition to WHERE
_Problem 3. Add a condition to ON
Type 3. CROSS JOIN
_Problem 1.
One-to-many (1:N) CROSS JOIN
_Problem 2.
Many-to-Many (N:N) CROSS JOIN
Type 4. FULL OUTER JOIN
_Problem 1.
Two LEFT OUTER JOINs and a UNION
Type 5. GROUP BY
_Problem 1.
Basic GROUP BY
_Problem 2. CASE WHEN and GROUP BY
_Problem 3.
Aggregation by partition
Type 6. HAVING
_Problem 1.
Basic HAVING
_Problem 2.
Group identifier
_Problem 3. WHERE and HAVING
_Problem 4.
Subquery HAVING
Type 7. MIN, MAX
_Problem 1.
Basic MIN, MAX
_Problem 2. Subquery using MIN and MAX
_Problem 3. Subquery using MIN and MAX
Type 8. SUM, COUNT
_Problem 1. Difference between SUM and COUNT in CASE WHEN
_Problem 2.
Cumulative total
_Problem 3.
Cumulative sum by partition
Type 9. CASE WHEN
_Problem 1. CASE WHEN and GROUP BY
_Problem 2. Multiple conditions in CASE WHEN
_Problem 3.
SUM of different THEN results
_Problem 4.
UNION of independent queries
Type 10. IFNULL
_Problem 1. LEFT OUTER JOIN and IFNULL
_Problem 2. LEFT OUTER JOIN and IFNULL
Type 11. LIMIT
_Problem 1.
Combination of basic ORDER BY and LIMIT
_Problem 2. Extracting the top rank after GROUP BY
_Problem 3. Extracting the top result after INNER JOIN and GROUP BY
Type 12. NOT IN
_Problem 1.
Basic NOT IN
_Problem 2. Subqueries of IN and NOT IN
_Problem 3. NOT IN and GROUP BY
Type 13. RANK
_Problem 1. RANK using PARTITION BY
_Problem 2. RANK using PARTITION BY
Type 14. DENSE_RANK
_Problem 1.
Default DENSE_RANK
_Problem 2.
2nd place ranking
Type 15. ROW_NUMBER
_Problem 1. Comparison of RANK, DENSE_RANK, and ROW_NUMBER
_Problem 2.
Default ROW_NUMBER
Type 16. LAG, LEAD
_Problem 1.
Basic LAG, LEAD
_Problem 2. Add a WHERE condition after LAG
_Problem 3. Adding an IF condition to SELECT after LAG
Type 17. DATE
_Problem 1. TIMESTAMP data type
_Problem 2. DATE_ADD, DATE_SUB functions
_Problem 3. DATE_FORMAT function
Type 18. CONCAT
_Problem 1.
Basic CONCAT
_Problem 2.
Basic GROUP_CONCAT
SQL Problem Set 1
SQL Problem Set 2
SQL Problem Set 3
Search
Detailed image
Publisher's Review
★ Personal training to develop practical query writing skills
This book aims to help you turn your SQL grammar knowledge, which has been confined to your head, into practical skills.
Let's try customized training through 18 core type problems.
Let's think about solutions to the problem question, solve it together, and identify the key points and incorrect answers.
As you follow this book, you will finally find yourself with 'query strength'.
There is no result without process.
And wrong answers are also a process.
In practice, developers and analysts also complete code through a process of trial and error.
This book, accordingly, doesn't simply produce complete code in one fell swoop. Instead, it aims to demonstrate the process of completing SQL code and the potential errors encountered along the way.
This encourages students to develop practical thinking skills appropriate to problem situations, rather than simply outputting memorized knowledge.
Various difficulty levels, various topics, and problem sets
SQL problems are categorized by core type.
And it provides a wide range of problems from low to high difficulty by type.
This structure allows you to build your skills gradually and focus on learning your weaker types.
Finally, you will be able to further strengthen your application skills through problem sets that allow you to practice a variety of types comprehensively.
★ Who needs this book?
- For those who have some basic grammar skills and want to develop practical skills
- People preparing for SQL coding tests
- Those who prefer to learn by solving real-world problems
- Anyone who is using SQL or needs to use it but wants to quickly learn the parts they are lacking
This book aims to help you turn your SQL grammar knowledge, which has been confined to your head, into practical skills.
Let's try customized training through 18 core type problems.
Let's think about solutions to the problem question, solve it together, and identify the key points and incorrect answers.
As you follow this book, you will finally find yourself with 'query strength'.
There is no result without process.
And wrong answers are also a process.
In practice, developers and analysts also complete code through a process of trial and error.
This book, accordingly, doesn't simply produce complete code in one fell swoop. Instead, it aims to demonstrate the process of completing SQL code and the potential errors encountered along the way.
This encourages students to develop practical thinking skills appropriate to problem situations, rather than simply outputting memorized knowledge.
Various difficulty levels, various topics, and problem sets
SQL problems are categorized by core type.
And it provides a wide range of problems from low to high difficulty by type.
This structure allows you to build your skills gradually and focus on learning your weaker types.
Finally, you will be able to further strengthen your application skills through problem sets that allow you to practice a variety of types comprehensively.
★ Who needs this book?
- For those who have some basic grammar skills and want to develop practical skills
- People preparing for SQL coding tests
- Those who prefer to learn by solving real-world problems
- Anyone who is using SQL or needs to use it but wants to quickly learn the parts they are lacking
GOODS SPECIFICS
- Date of issue: August 11, 2025
- Page count, weight, size: 416 pages | 173*230*30mm
- ISBN13: 9791165923273
- ISBN10: 1165923270
You may also like
카테고리
korean
korean
![GQ KOREA Mark (Monthly): December [2025]](http://librairie.coreenne.fr/cdn/shop/files/8ef265dbbfbf186523ed75ba7319009d.jpg?v=1765340328&width=3840)
