{"product_id":"154806","title":"Everyone's SQL ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jYDsmQBhmrQsHO3xNEX5PTCHrUFPn.png?v=1765082042\" 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 Everyone's SQL \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\/64434562\/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 \u003cb\u003eWhat if you need to analyze and process data with SQL for the first time?\u003cbr\u003e The easiest SQL introduction for beginners and non-specialists.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e With the development of the Internet and the rise of social media like Facebook, we have entered an era where everything is told through data.\u003cbr\u003e But data is not a magic wand; it is raw material that must be processed to achieve the desired results.\u003cbr\u003e [Everyone's SQL] is for people who need to analyze and process data with SQL for the first time.\u003cbr\u003e It focuses on the core SQL content most frequently used by non-specialist practitioners, and the examples are also diverse and focused on frequently used content. \u003cbr\u003eIn particular, in the last chapter, you can experience how to use SQL in practice by carrying out a family restaurant sales analysis project in a hypothetical scenario.\u003cbr\u003e Anyone can easily take their first step into data analysis with [Everyone's 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 Chapter 1 Relational Databases and SQL\u003cbr\u003e 01 Now is the era of data\u003cbr\u003e 02 Components and tables of a relational database\u003cbr\u003e\u003cbr\u003e Chapter 2: Creating a Practice Environment\u003cbr\u003e 01 Installing Oracle Database Express\u003cbr\u003e 02 Installing Oracle SQL Developer\u003cbr\u003e 03 Basic Usage of Oracle SQL Developer\u003cbr\u003e\u003cbr\u003e Chapter 3 SELECT: The Basics of Data Retrieval\u003cbr\u003e 01 Basic syntax of SELECT statement\u003cbr\u003e 02 Data retrieval using the WHERE condition clause.\u003cbr\u003e\u003cbr\u003e Chapter 4: Functions: Easily Process Data with Functions\u003cbr\u003e 01 What is a function?\u003cbr\u003e 02 Single-row functions: Calculate and manipulate data values ​​one by one\u003cbr\u003e 03 Group Functions: Summarizing by Group\u003cbr\u003e \u003cbr\u003eChapter 5 ERD: Database Object Design Diagram\u003cbr\u003e 01 Keys and Constraints: Object Property Notation\u003cbr\u003e 02 Relationship: Entity Relationship Notation\u003cbr\u003e\u003cbr\u003e Chapter 6 Joins and Sets: Connecting Multiple Tables\u003cbr\u003e 01 What is Join?\u003cbr\u003e 02 Equi-join: Connecting identical data\u003cbr\u003e 03 Outer Join: Connecting All Data\u003cbr\u003e 04 Self-Join: Connecting to Your Own Data\u003cbr\u003e 05 Set Operators: Connecting with Sets\u003cbr\u003e\u003cbr\u003e Chapter 7 Subqueries: SELECT statements within SELECT statements\u003cbr\u003e 01 What is a subquery?\u003cbr\u003e 02 Single-row subquery\u003cbr\u003e 03 Multi-row subquery\u003cbr\u003e 04 Multi-column subquery\u003cbr\u003e 05 FROM clause subquery: Inline view\u003cbr\u003e\u003cbr\u003e Chapter 8 DML: Inserting\/Updating\/Deleting Data\u003cbr\u003e 01 What is DML?\u003cbr\u003e 02 INSERT: Inserting a row\u003cbr\u003e 03 UPDATE: Updating rows\u003cbr\u003e 04 DELETE: Delete a row\u003cbr\u003e\u003cbr\u003e Chapter 9 Data Integrity and Transactions: Fundamental Rules for Database Operation\u003cbr\u003e 01 Data Integrity and Constraints 4\u003cbr\u003e 02 Transaction: Basic unit of work in data processing\u003cbr\u003e\u003cbr\u003e Chapter 10 DDL: Manipulating Tables and Columns\u003cbr\u003e 01 What is DDL? \u003cbr\u003e02 CREATE: Creating a table\u003cbr\u003e 03 ALTER: Modifying a table\u003cbr\u003e 04 TRUNCATE: Delete table contents\u003cbr\u003e 05 DROP: Delete a table\u003cbr\u003e\u003cbr\u003e Chapter 11: Key Knowledge of Relational Databases\u003cbr\u003e View 01: Virtual Table\u003cbr\u003e 02 Optimizer: Managing Performance Optimization\u003cbr\u003e 03 Index: Data address book for quick search\u003cbr\u003e\u003cbr\u003e Chapter 12: Analyzing New Family Restaurant Sales with Manager Choi\u003cbr\u003e 01 Installing the practice data\u003cbr\u003e 02 Manager Choi's worries\u003cbr\u003e 03 Analyzing Sales\u003cbr\u003e 04 Analyzing demographics\u003cbr\u003e 05 Sales Data Analysis and Organization\u003cbr\u003e\n\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\/TopCate1982\/MidCate008\/198177915.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eInto the book\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e There have been many books explaining SQL grammar, but it has been difficult to find a book that explains how to use and apply it.\u003cbr\u003e Readers who choose this book are likely to want to know what SQL is and how to use it.\u003cbr\u003e The purpose of this book is clear.\u003cbr\u003e 'The vast field of SQL cannot be covered in one book. \u003cbr\u003eTherefore, let's focus on delivering high-priority content that beginners and practitioners can best utilize in a practical environment!'\u003cbr\u003e So, based on my experience, I have compiled the basics and important information you need to know into this book.\u003cbr\u003e I also compiled this book by considering what beginners and practitioners are most curious about when using SQL and how to make it easier to understand.\u003cbr\u003e If this book serves as a guide for readers in learning and utilizing SQL, I consider it to have achieved its purpose.\u003cbr\u003e\u003cbr\u003e Many companies are trying to leverage databases and data.\u003cbr\u003e But we discover that it is never easy.\u003cbr\u003e Data is not a magic wand.\u003cbr\u003e It is just a raw stone that needs to be worked upon to produce the desired result. \u003cbr\u003eSome companies make the unfortunate choice of abandoning the value of raw materials and reverting to the past due to the difficulty of processing them.\u003cbr\u003e When making choices that go against the grain, we must be very serious and careful, and someone must be held accountable.\u003cbr\u003e Conversely, if companies overcome challenges, overcome existing ignorance, and discover meaningful results, they will advance to the next level. SQL is one of the essential tools for processing (manipulating and analyzing) data.\u003cbr\u003e A craftsman's hands may produce a very fine piece of work, but they may not.\u003cbr\u003e I hope this book will help you get a feel for the value and use of tools to achieve your intended results.\u003cbr\u003e\u003cbr\u003e - From [Author's Note]\u003c\/div\u003e\n\u003cdiv\u003e --- From the text\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\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 \u003cb\u003eAnyone with SQL\u003cbr\u003e You can analyze data!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Preparation | Prepare what you need to learn \u003cbr\u003eLearn the concepts of what databases and SQL are and prepare Oracle for learning.\u003cbr\u003e\u003cbr\u003e Basics | Learn Basic SQL\u003cbr\u003e Learn about the basic syntax, functions, ERD, joins, and subqueries of the SELECT statement, a command for outputting data.\u003cbr\u003e We will explain the most basic and frequently used core elements of SQL commands for manipulating and analyzing data.\u003cbr\u003e\u003cbr\u003e Level Up and Leverage | In-Depth SQL Study and Experience Practical Projects\u003cbr\u003e Go one step further and learn the core elements of DML and DDL to manipulate data directly.\u003cbr\u003e Finally, we will proceed with a practical sales analysis project using the SQL grammar we have learned so far.\u003cbr\u003e Explore how you can leverage SQL through your projects.\u003cbr\u003e\n\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 publication:\u003c\/strong\u003e September 21, 2018\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 296 pages | 683g | 183*235*16mm\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 9791160505771 \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":43893454766122,"sku":"154806","price":29.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/e5cda842425228cb944e6f85de88bb63.jpg?v=1765402767","url":"https:\/\/librairie.coreenne.fr\/en\/products\/154806","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}