{"product_id":"140069","title":"Oracle SQL PowerUp ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jYGWrynyOK7DR5qVH4GXXyq5CC0TX.png?v=1765078044\" 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 Oracle SQL PowerUp \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\/147953347\/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\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eSQL, do you want to go beyond just writing?\u003cbr\u003e Power up with practice.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \"Oracle SQL Power-Up\" is a practical textbook designed to help you learn how to understand and write SQL on a business-by-business basis, based on real-world project scenarios. \u003cbr\u003eIt covers the entire process of understanding the workflow, analyzing the data structure, and then designing and implementing SQL that fits the purpose.\u003cbr\u003e This book provides over a million real-world examples and guides you through a step-by-step design process to naturally learn how to create and refine complex SQL.\u003cbr\u003e In addition to frequently used joins, it implements scenarios that frequently appear in actual work, such as hierarchical structures (e.g., departments, product classifications), ordering, receipt\/shipping, and sales flows, and you can take your SQL skills to the next level through a total of 13 practical scenarios.\u003cbr\u003e Experience designing and implementing SQL based on workflows. For beginner-intermediate developers who want to take their SQL skills to the next level, this book will serve as a turning point in their development.\u003cbr\u003e\n\u003c\/div\u003e\u003c\/div\u003e\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 \u003cb\u003ePART 01.\u003cbr\u003e Project Preparation\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Section 01 Introduction to the Job\u003cbr\u003e\u003cbr\u003e Section 02 Data Model and Table Data\u003cbr\u003e 2.1. \u003cbr\u003eData Model and Entity Classification\u003cbr\u003e 2.2.\u003cbr\u003e Entity Description\u003cbr\u003e 2.3.\u003cbr\u003e Building table data\u003cbr\u003e\u003cbr\u003e Section 03 Getting to Know Data\u003cbr\u003e 3.1.\u003cbr\u003e goods\u003cbr\u003e 3.2.\u003cbr\u003e burial\u003cbr\u003e 3.3.\u003cbr\u003e mosque\u003cbr\u003e 3.4.\u003cbr\u003e correspondent\u003cbr\u003e 3.5.\u003cbr\u003e Category\u003cbr\u003e 3.6.\u003cbr\u003e department\u003cbr\u003e 3.7.\u003cbr\u003e Common code\u003cbr\u003e\u003cbr\u003e Section 04 Getting to know your work\u003cbr\u003e 4.1.\u003cbr\u003e Orders and ordered products\u003cbr\u003e 4.2.\u003cbr\u003e Incoming and outgoing goods and incoming and outgoing goods\u003cbr\u003e 4.3.\u003cbr\u003e Sales and Products for Sale\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 02.\u003cbr\u003e Project Development\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Section 01 Project Structure\u003cbr\u003e\u003cbr\u003e Section 02 Business Partner Inquiry\u003cbr\u003e\u003cbr\u003e Section 03 Store Search\u003cbr\u003e\u003cbr\u003e Section 04 Employee Inquiry\u003cbr\u003e\u003cbr\u003e Section 05 Common Code Inquiry\u003cbr\u003e\u003cbr\u003e Section 06 Department Inquiry\u003cbr\u003e\u003cbr\u003e Section 07 Category Search\u003cbr\u003e\u003cbr\u003e Section 08 Product Inquiry\u003cbr\u003e\u003cbr\u003e Section 09 Order Inquiry and Order Status\u003cbr\u003e 9.1.\u003cbr\u003e Order Inquiry\u003cbr\u003e 9.2.\u003cbr\u003e Order status\u003cbr\u003e\u003cbr\u003e Section 10: Inquiry and status of receipt\u003cbr\u003e 10.1.\u003cbr\u003e Inquiry on receipt\u003cbr\u003e 10.2.\u003cbr\u003e Incoming status\u003cbr\u003e 10.3.\u003cbr\u003e Shipment Inquiry\u003cbr\u003e 10.4.\u003cbr\u003e Shipping status\u003cbr\u003e\u003cbr\u003e Section 11 Sales Inquiry and Sales Status\u003cbr\u003e 11.1.\u003cbr\u003e Sales Inquiry\u003cbr\u003e 11.2.\u003cbr\u003e Sales status\u003cbr\u003e\u003cbr\u003e Section 12 Data Summary (Aggregation)\u003cbr\u003e 12.1.\u003cbr\u003e Order Summary (by Business Partner)\u003cbr\u003e 12.2.\u003cbr\u003e Sales Summary (by Store)\u003cbr\u003e 12.3.\u003cbr\u003e Order Summary (by Date and Product - Vertical)\u003cbr\u003e 12.4. \u003cbr\u003eInventory Summary (by date and product - vertical)\u003cbr\u003e 12.5.\u003cbr\u003e Sales Summary (by Date and Product - Vertical)\u003cbr\u003e 12.6.\u003cbr\u003e Order Summary (by date and customer - vertical)\u003cbr\u003e 12.7.\u003cbr\u003e Sales Summary (by store by date - vertical)\u003cbr\u003e 12.8.\u003cbr\u003e Quantity in stock compared to order (product)\u003cbr\u003e 12.9.\u003cbr\u003e Sales volume compared to orders (products)\u003cbr\u003e 12.10.\u003cbr\u003e Sales Summary (Sales by Store - Horizontal)\u003cbr\u003e 12.11.\u003cbr\u003e Sales Summary (Sales Quantity and Amount by Store - Horizontal)\u003cbr\u003e\u003cbr\u003e Section 13 Inventory\u003cbr\u003e 13.1.\u003cbr\u003e Inventory Inquiry\u003cbr\u003e 13.2.\u003cbr\u003e Inventory entry\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 Oracle SQL Power-Up is a practical textbook that goes beyond simple SQL grammar learning and guides you through designing and writing SQL within real-world workflows.\u003cbr\u003e This course is designed to help developers overcome the feeling of \"I've learned SQL, but I don't know where to start when it comes to actual work.\" It's designed to help you learn SQL step by step, following project-based scenarios.\u003cbr\u003e \u003cbr\u003eIn particular, this book provides over a million real-world data sets and explains the entire process of creating complex SQL, from purpose to design and implementation.\u003cbr\u003e Rather than simply writing queries, you'll naturally acquire the SQL sensibilities needed for practical work through the process of interpreting business data, reflecting requirements, and deriving optimal results.\u003cbr\u003e\u003cbr\u003e Target audience for this book\u003cbr\u003e\u003cbr\u003e Developers who have mastered SQL grammar but are stuck in practice\u003cbr\u003e After completing basic learning, readers who want to take their skills to the next level\u003cbr\u003e Practitioners who want to understand practical data flow and write SQL\u003cbr\u003e Beginners who want to practice SQL on a project basis\u003cbr\u003e Developers who want to solve complex tasks with a single SQL, but also want to know the process and criteria for judgment.\u003cbr\u003e Practitioners who want to write structurally high-performance SQL\u003cbr\u003e \u003cbr\u003eThis book is largely divided into two parts. Part 1 covers the preparatory phase for understanding the project. Part 2 explains the process by which the development team forms, negotiates requirements with the client, and completes them step by step.\u003cbr\u003e\u003cbr\u003e PART 01.\u003cbr\u003e Project Preparation\u003cbr\u003e This part covers the background of the entire hands-on project and familiarizing yourself with the data structures that will be used to implement SQL in the future.\u003cbr\u003e Based on the familiar business model of a coffee franchise, we examine how data frequently appearing in real-world practice—products, stores, business partners, orders, receipts\/shipments, sales, etc.—are structured.\u003cbr\u003e\u003cbr\u003e Starting with an introduction to the business, we will learn about data modeling perspectives through logical\/physical models.\u003cbr\u003e We focus on intuitively understanding what data is contained in each table and how they are related.\u003cbr\u003e\u003cbr\u003e PART 02.\u003cbr\u003e Project Development \u003cbr\u003eThis part is structured like a real-world project, and is a story-based learning structure that follows the requirements negotiation and implementation process that occurs in the field.\u003cbr\u003e\u003cbr\u003e Manager Lee Hyo-mi and Assistant Manager Song Hae-gyo from the ordering company convey the requirements, and Manager Hong Du-sik, Deputy Manager Yang Hae-gyeong, Manager Byeon Seong-jun, and Assistant Manager Joo Seon-yeong from the development company form a team to implement the requirements and proceed with the project.\u003cbr\u003e\u003cbr\u003e Among these, Manager Byeon Seong-jun and Assistant Manager Joo Seon-yeong are in charge of actual implementation and leading the project, while Deputy Manager Yang Hae-kyung plays an important coordination role as a practical leader who presents technical direction and judgment criteria.\u003cbr\u003e \u003cbr\u003eInitially, you will learn the basics of SQL by implementing simple list search functions for customers, stores, and employees, but you will gradually deal with difficult practical problems such as hierarchical structure processing, complex joins, aggregate functions, window functions, and various aggregate tasks, as well as inventory according to time.\u003cbr\u003e\u003cbr\u003e In this process, Assistant Manager Joo Seon-yeong, who started out as a SQL beginner, quickly grows, and Manager Byun Seong-jun demonstrates advanced SQL implementation capabilities based on practical experience and solid fundamentals.\u003cbr\u003e Readers can also follow this flow and naturally develop practical skills and SQL problem-solving skills.\u003cbr\u003e\u003cbr\u003e As you follow this book, you will find yourself growing like Manager Byun Seong-jun and Assistant Manager Joo Seon-yeong, or even more so. \u003cbr\u003e\n\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 issue:\u003c\/strong\u003e June 27, 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 344 pages | 681g | 190*240*17mm\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 9791195942589\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 1195942583 \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":43893397651498,"sku":"140069","price":38.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/d07f40ba03e14132629cdf74d8faf2e7.jpg?v=1765400153","url":"https:\/\/librairie.coreenne.fr\/en\/products\/140069","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}