{"product_id":"139155","title":"SQL that only Kim Dae-ri, the person who quits work at a fast pace, knows and that only I don't ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXPBvhNT7DlB9HpWQmq6XDF8SWUyW.png?v=1765073343\" 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 that only Kim Dae-ri, the person who quits work at a fast pace, knows and that only I don't \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\/118500870\/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\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \"SQL: What Manager Kim Knows That Only I Don't\" is a must-read introductory book for SQL beginners.\u003cbr\u003e We carefully select only the content that can be used immediately in practice and explain it in the ‘easiest’ and ‘minimum amount’. \u003cbr\u003eOf course, mastering SQL requires a much broader understanding of concepts, but this book focuses on helping beginners learn SQL to achieve immediate results when they begin working in practice.\u003cbr\u003e It is structured to enable you to handle practical tasks with SQL within two weeks. It provides a fun way to learn what you will learn that day through storytelling, and there are also tips and example solutions that apply practical concepts throughout the text, as if a mentor were kindly explaining it to you.\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 \",\"\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eDAY 01. SQL Overview\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri enters databases.\u003cbr\u003e 01 What is a database?\u003cbr\u003e - Definition of database\u003cbr\u003e - Characteristics of database management systems (DBMS)\u003cbr\u003e - Database terminology required for using SQL\u003cbr\u003e 02 What is SQL?\u003cbr\u003e - Overview of SQL\u003cbr\u003e - Types of SQL\u003cbr\u003e 03 Using SQL \u003cbr\u003e- The world of big data\u003cbr\u003e - Using SQL in the Big Data Era\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 02. SQL Basics\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri takes his first steps into SQL fundamentals.\u003cbr\u003e 01 Importing data\u003cbr\u003e - Get the specified column\u003cbr\u003e - Get all columns\u003cbr\u003e 02 Sorting data\u003cbr\u003e - Sort data by one column\u003cbr\u003e - Sorting data by multiple columns\u003cbr\u003e - Sort data in ascending order\u003cbr\u003e - Sort data in descending order\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 03. Additional keywords required for SELECT statements\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns additional concepts to master the SELECT statement.\u003cbr\u003e 01 Keywords frequently used in SELECT statements\u003cbr\u003e - DISTINCT keyword\u003cbr\u003e - ALLIAS (nickname)\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 04. Data Condition Cycle Using the WHERE Clause\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns data extraction using the WHERE clause.\u003cbr\u003e 01 Learn about the WHERE clause\u003cbr\u003e - Filtering numeric and character\/date data\u003cbr\u003e - Comparison\/arithmetic operators \u003cbr\u003e- Handling NULL values\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 05.\u003cbr\u003e Data condition cycle using logical operators\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns how to add more than one condition to a WHERE clause.\u003cbr\u003e 01 Learn about logical operators AND and OR\u003cbr\u003e - AND operator\u003cbr\u003e - OR operator\u003cbr\u003e 02 Learn about logical operators IN and NOT IN\u003cbr\u003e - IN operator\u003cbr\u003e - NOT IN operator\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 06.\u003cbr\u003e Data Conditioning Cycle Using Text Mining\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns how to extract unstructured data.\u003cbr\u003e 01 Text mining\u003cbr\u003e - Filtering using the LIKE operator\u003cbr\u003e - Combine fields\u003cbr\u003e - Remove spaces\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 07.\u003cbr\u003e Learn basic functions\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story: Humanities student Kim Dae-ri learns basic functions.\u003cbr\u003e 01 Learn character\/number\/date functions\u003cbr\u003e - Character functions\u003cbr\u003e - Numeric functions\u003cbr\u003e - Date functions\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 08.\u003cbr\u003e Using functions\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns about various functions.\u003cbr\u003e 01 Summarizing numeric data\u003cbr\u003e - COUNT function \u003cbr\u003e- SUM, AVG, MAX, MIN, STDENV, VARIANCE functions\u003cbr\u003e 02 Understanding Conditional Statements\u003cbr\u003e - CASE WHEN statement\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 09.\u003cbr\u003e Grouping and filtering data\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns in-depth data analysis methods that group data.\u003cbr\u003e 01 Grouping of data\u003cbr\u003e 02 Filtering grouped data\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 10.\u003cbr\u003e Merge tables\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri learns data analysis methods that combine two or more tables.\u003cbr\u003e 01 Merge Columns\u003cbr\u003e - Inner join\u003cbr\u003e - Outer join\u003cbr\u003e 02 Merge Rows\u003cbr\u003e - UNION operator\u003cbr\u003e - UNION ALL operator\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 11.\u003cbr\u003e Subquery\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story: Humanities student Kim Dae-ri uses subqueries to create efficient SQL statements.\u003cbr\u003e 01 Understanding Subqueries\u003cbr\u003e - Subquery in the FROM clause\u003cbr\u003e - Subquery in WHERE clause\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDAY 12.\u003cbr\u003e Data and table manipulation\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e Story·Humanities student Kim Dae-ri manipulates data and tables directly. \u003cbr\u003e01 Data Manipulation\u003cbr\u003e - Insert data\u003cbr\u003e - Data deletion\u003cbr\u003e - Data modification\u003cbr\u003e 02 Table manipulation\u003cbr\u003e - Create table\u003cbr\u003e - Alter and delete tables\u003cbr\u003e Kim Dae-ri's practice~!\u003cbr\u003e\u003cbr\u003e Appendix A - Table\u003cbr\u003e Appendix B - Index\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\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\/TopCate4159\/MidCate002\/415810752.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\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 \u003cb\u003eMaster SQL fundamentals in two weeks, one chapter a day!\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e It consists of 12 chapters in total, so you can master the basics of SQL in just two weeks.\u003cbr\u003e After examining the situations that need to be learned each day as scenarios, we explain them in an easy-to-understand way so that even beginners can easily approach them.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eLike a pair of tongs, it is composed of only the core concepts for practical application!\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e We've selected and introduced only the most applicable core concepts in the field so that you can quickly learn and use them right away.\u003cbr\u003e For those who don't have enough time to learn all the concepts, we'll explain only the most important things to know.\u003cbr\u003e \u003cbr\u003e\u003cb\u003eLearn with examples using practical terms and gain a sense of business at the same time!\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e If you hesitate in the field after learning a lot, the meaning of the time you spent learning will fade.\u003cbr\u003e This book introduces performance indicators used in actual business operations, helping you naturally adapt them to your work.\u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e \"]\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 April 20, 2023\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 228 pages | 150*210*24mm\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 9791193049013\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 1193049016 \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":43893342666794,"sku":"139155","price":28.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/dd76e2f4d8f399de990bb256f6712048.jpg?v=1765397406","url":"https:\/\/librairie.coreenne.fr\/en\/products\/139155","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}