{"product_id":"139960","title":"SQL Practical Training ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXOZV82BQqEFErvmeAHOgfFjwsBNP.png?v=1765077408\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e SQL Practical Training \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/150547033\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e  \u003ch5\u003e\u003cb\u003eBook Introduction\u003c\/b\u003e\u003c\/h5\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eLife and SQL are ultimately about 'practical' situations.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e “I know the basic grammar of SQL to some extent.\u003cbr\u003e “It’s difficult to actually write a query… Should I study grammar more?”\u003cbr\u003e\u003cbr\u003e 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.\u003cbr\u003e If your goal is to become a practical expert who can effectively use SQL, you should be exposed to a variety of practical problems.\u003cbr\u003e In the process, any missing knowledge will be filled in naturally.\u003cbr\u003e\u003cbr\u003e \u003cbr\u003eThis book briefly explains the concepts and grammar of 18 core types, and then provides problems of various difficulty levels and types.\u003cbr\u003e Let's think about the answer to the question and solve it together step by step.\u003cbr\u003e It also presents error patterns that often lead to traps in the process.\u003cbr\u003e Through this, let's now become a practical player of SQL.\u003cbr\u003e\n\n\u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003e You can preview some of the book's contents.\u003cbr\u003e \u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e Preparing the Lab Environment: Connecting MySQL and GitHub\u003cbr\u003e\u003cbr\u003e Type 1. INNER JOIN\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic INNER JOIN\u003cbr\u003e _Problem 2.\u003cbr\u003e Subqueries and INNER JOINs\u003cbr\u003e _Problem 3.\u003cbr\u003e Self-join\u003cbr\u003e\u003cbr\u003e Type 2. LEFT OUTER JOIN\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic LEFT OUTER JOIN\u003cbr\u003e _Problem 2. Add a right table condition to WHERE\u003cbr\u003e _Problem 3. Add a condition to ON\u003cbr\u003e\u003cbr\u003e Type 3. CROSS JOIN\u003cbr\u003e _Problem 1.\u003cbr\u003e One-to-many (1:N) CROSS JOIN\u003cbr\u003e _Problem 2.\u003cbr\u003e Many-to-Many (N:N) CROSS JOIN\u003cbr\u003e\u003cbr\u003e Type 4. FULL OUTER JOIN\u003cbr\u003e _Problem 1.\u003cbr\u003e Two LEFT OUTER JOINs and a UNION\u003cbr\u003e\u003cbr\u003e Type 5. GROUP BY\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic GROUP BY \u003cbr\u003e_Problem 2. CASE WHEN and GROUP BY\u003cbr\u003e _Problem 3.\u003cbr\u003e Aggregation by partition\u003cbr\u003e\u003cbr\u003e Type 6. HAVING\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic HAVING\u003cbr\u003e _Problem 2.\u003cbr\u003e Group identifier\u003cbr\u003e _Problem 3. WHERE and HAVING\u003cbr\u003e _Problem 4.\u003cbr\u003e Subquery HAVING\u003cbr\u003e\u003cbr\u003e Type 7. MIN, MAX\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic MIN, MAX\u003cbr\u003e _Problem 2. Subquery using MIN and MAX\u003cbr\u003e _Problem 3. Subquery using MIN and MAX\u003cbr\u003e\u003cbr\u003e Type 8. SUM, COUNT\u003cbr\u003e _Problem 1. Difference between SUM and COUNT in CASE WHEN\u003cbr\u003e _Problem 2.\u003cbr\u003e Cumulative total\u003cbr\u003e _Problem 3.\u003cbr\u003e Cumulative sum by partition\u003cbr\u003e\u003cbr\u003e Type 9. CASE WHEN\u003cbr\u003e _Problem 1. CASE WHEN and GROUP BY\u003cbr\u003e _Problem 2. Multiple conditions in CASE WHEN\u003cbr\u003e _Problem 3.\u003cbr\u003e SUM of different THEN results\u003cbr\u003e _Problem 4.\u003cbr\u003e UNION of independent queries\u003cbr\u003e\u003cbr\u003e Type 10. IFNULL\u003cbr\u003e _Problem 1. LEFT OUTER JOIN and IFNULL\u003cbr\u003e _Problem 2. LEFT OUTER JOIN and IFNULL\u003cbr\u003e\u003cbr\u003e Type 11. LIMIT\u003cbr\u003e _Problem 1.\u003cbr\u003e Combination of basic ORDER BY and LIMIT\u003cbr\u003e _Problem 2. Extracting the top rank after GROUP BY\u003cbr\u003e _Problem 3. Extracting the top result after INNER JOIN and GROUP BY\u003cbr\u003e\u003cbr\u003e Type 12. NOT IN\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic NOT IN\u003cbr\u003e _Problem 2. Subqueries of IN and NOT IN\u003cbr\u003e _Problem 3. NOT IN and GROUP BY\u003cbr\u003e\u003cbr\u003e Type 13. RANK\u003cbr\u003e _Problem 1. RANK using PARTITION BY \u003cbr\u003e_Problem 2. RANK using PARTITION BY\u003cbr\u003e\u003cbr\u003e Type 14. DENSE_RANK\u003cbr\u003e _Problem 1.\u003cbr\u003e Default DENSE_RANK\u003cbr\u003e _Problem 2.\u003cbr\u003e 2nd place ranking\u003cbr\u003e\u003cbr\u003e Type 15. ROW_NUMBER\u003cbr\u003e _Problem 1. Comparison of RANK, DENSE_RANK, and ROW_NUMBER\u003cbr\u003e _Problem 2.\u003cbr\u003e Default ROW_NUMBER\u003cbr\u003e\u003cbr\u003e Type 16. LAG, LEAD\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic LAG, LEAD\u003cbr\u003e _Problem 2. Add a WHERE condition after LAG\u003cbr\u003e _Problem 3. Adding an IF condition to SELECT after LAG\u003cbr\u003e\u003cbr\u003e Type 17. DATE\u003cbr\u003e _Problem 1. TIMESTAMP data type\u003cbr\u003e _Problem 2. DATE_ADD, DATE_SUB functions\u003cbr\u003e _Problem 3. DATE_FORMAT function\u003cbr\u003e\u003cbr\u003e Type 18. CONCAT\u003cbr\u003e _Problem 1.\u003cbr\u003e Basic CONCAT\u003cbr\u003e _Problem 2.\u003cbr\u003e Basic GROUP_CONCAT\u003cbr\u003e\u003cbr\u003e SQL Problem Set 1\u003cbr\u003e SQL Problem Set 2\u003cbr\u003e SQL Problem Set 3\u003cbr\u003e\u003cbr\u003e Search\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate5495\/MidCate006\/549456044.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e ★ Personal training to develop practical query writing skills\u003cbr\u003e This book aims to help you turn your SQL grammar knowledge, which has been confined to your head, into practical skills.\u003cbr\u003e Let's try customized training through 18 core type problems. \u003cbr\u003eLet's think about solutions to the problem question, solve it together, and identify the key points and incorrect answers.\u003cbr\u003e As you follow this book, you will finally find yourself with 'query strength'.\u003cbr\u003e\u003cbr\u003e There is no result without process.\u003cbr\u003e And wrong answers are also a process.\u003cbr\u003e\u003cbr\u003e In practice, developers and analysts also complete code through a process of trial and error.\u003cbr\u003e 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.\u003cbr\u003e This encourages students to develop practical thinking skills appropriate to problem situations, rather than simply outputting memorized knowledge.\u003cbr\u003e\u003cbr\u003e Various difficulty levels, various topics, and problem sets\u003cbr\u003e SQL problems are categorized by core type.\u003cbr\u003e And it provides a wide range of problems from low to high difficulty by type. \u003cbr\u003eThis structure allows you to build your skills gradually and focus on learning your weaker types.\u003cbr\u003e Finally, you will be able to further strengthen your application skills through problem sets that allow you to practice a variety of types comprehensively.\u003cbr\u003e\u003cbr\u003e ★ Who needs this book?\u003cbr\u003e - For those who have some basic grammar skills and want to develop practical skills\u003cbr\u003e - People preparing for SQL coding tests\u003cbr\u003e - Those who prefer to learn by solving real-world problems\u003cbr\u003e - Anyone who is using SQL or needs to use it but wants to quickly learn the parts they are lacking \u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e August 11, 2025\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 416 pages | 173*230*30mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791165923273\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 1165923270 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893388410922,"sku":"139960","price":39.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/6a9c43811b5ea6827e4ee7ea459036b9.jpg?v=1765399733","url":"https:\/\/librairie.coreenne.fr\/en\/products\/139960","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}