SQL that only Kim Dae-ri, the person who quits work at a fast pace, knows and that only I don't
 |
Description
Book Introduction
"SQL: What Manager Kim Knows That Only I Don't" is a must-read introductory book for SQL beginners.
We carefully select only the content that can be used immediately in practice and explain it in the ‘easiest’ and ‘minimum amount’.
Of 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.
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.
We carefully select only the content that can be used immediately in practice and explain it in the ‘easiest’ and ‘minimum amount’.
Of 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.
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.
- You can preview some of the book's contents.
Preview
index
DAY 01. SQL Overview
Story·Humanities student Kim Dae-ri enters databases.
01 What is a database?
- Definition of database
- Characteristics of database management systems (DBMS)
- Database terminology required for using SQL
02 What is SQL?
- Overview of SQL
- Types of SQL
03 Using SQL
- The world of big data
- Using SQL in the Big Data Era
Kim Dae-ri's practice~!
DAY 02. SQL Basics
Story·Humanities student Kim Dae-ri takes his first steps into SQL fundamentals.
01 Importing data
- Get the specified column
- Get all columns
02 Sorting data
- Sort data by one column
- Sorting data by multiple columns
- Sort data in ascending order
- Sort data in descending order
Kim Dae-ri's practice~!
DAY 03. Additional keywords required for SELECT statements
Story·Humanities student Kim Dae-ri learns additional concepts to master the SELECT statement.
01 Keywords frequently used in SELECT statements
- DISTINCT keyword
- ALLIAS (nickname)
Kim Dae-ri's practice~!
DAY 04. Data Condition Cycle Using the WHERE Clause
Story·Humanities student Kim Dae-ri learns data extraction using the WHERE clause.
01 Learn about the WHERE clause
- Filtering numeric and character/date data
- Comparison/arithmetic operators
- Handling NULL values
Kim Dae-ri's practice~!
DAY 05.
Data condition cycle using logical operators
Story·Humanities student Kim Dae-ri learns how to add more than one condition to a WHERE clause.
01 Learn about logical operators AND and OR
- AND operator
- OR operator
02 Learn about logical operators IN and NOT IN
- IN operator
- NOT IN operator
Kim Dae-ri's practice~!
DAY 06.
Data Conditioning Cycle Using Text Mining
Story·Humanities student Kim Dae-ri learns how to extract unstructured data.
01 Text mining
- Filtering using the LIKE operator
- Combine fields
- Remove spaces
Kim Dae-ri's practice~!
DAY 07.
Learn basic functions
Story: Humanities student Kim Dae-ri learns basic functions.
01 Learn character/number/date functions
- Character functions
- Numeric functions
- Date functions
Kim Dae-ri's practice~!
DAY 08.
Using functions
Story·Humanities student Kim Dae-ri learns about various functions.
01 Summarizing numeric data
- COUNT function
- SUM, AVG, MAX, MIN, STDENV, VARIANCE functions
02 Understanding Conditional Statements
- CASE WHEN statement
Kim Dae-ri's practice~!
DAY 09.
Grouping and filtering data
Story·Humanities student Kim Dae-ri learns in-depth data analysis methods that group data.
01 Grouping of data
02 Filtering grouped data
Kim Dae-ri's practice~!
DAY 10.
Merge tables
Story·Humanities student Kim Dae-ri learns data analysis methods that combine two or more tables.
01 Merge Columns
- Inner join
- Outer join
02 Merge Rows
- UNION operator
- UNION ALL operator
Kim Dae-ri's practice~!
DAY 11.
Subquery
Story: Humanities student Kim Dae-ri uses subqueries to create efficient SQL statements.
01 Understanding Subqueries
- Subquery in the FROM clause
- Subquery in WHERE clause
Kim Dae-ri's practice~!
DAY 12.
Data and table manipulation
Story·Humanities student Kim Dae-ri manipulates data and tables directly.
01 Data Manipulation
- Insert data
- Data deletion
- Data modification
02 Table manipulation
- Create table
- Alter and delete tables
Kim Dae-ri's practice~!
Appendix A - Table
Appendix B - Index
Story·Humanities student Kim Dae-ri enters databases.
01 What is a database?
- Definition of database
- Characteristics of database management systems (DBMS)
- Database terminology required for using SQL
02 What is SQL?
- Overview of SQL
- Types of SQL
03 Using SQL
- The world of big data
- Using SQL in the Big Data Era
Kim Dae-ri's practice~!
DAY 02. SQL Basics
Story·Humanities student Kim Dae-ri takes his first steps into SQL fundamentals.
01 Importing data
- Get the specified column
- Get all columns
02 Sorting data
- Sort data by one column
- Sorting data by multiple columns
- Sort data in ascending order
- Sort data in descending order
Kim Dae-ri's practice~!
DAY 03. Additional keywords required for SELECT statements
Story·Humanities student Kim Dae-ri learns additional concepts to master the SELECT statement.
01 Keywords frequently used in SELECT statements
- DISTINCT keyword
- ALLIAS (nickname)
Kim Dae-ri's practice~!
DAY 04. Data Condition Cycle Using the WHERE Clause
Story·Humanities student Kim Dae-ri learns data extraction using the WHERE clause.
01 Learn about the WHERE clause
- Filtering numeric and character/date data
- Comparison/arithmetic operators
- Handling NULL values
Kim Dae-ri's practice~!
DAY 05.
Data condition cycle using logical operators
Story·Humanities student Kim Dae-ri learns how to add more than one condition to a WHERE clause.
01 Learn about logical operators AND and OR
- AND operator
- OR operator
02 Learn about logical operators IN and NOT IN
- IN operator
- NOT IN operator
Kim Dae-ri's practice~!
DAY 06.
Data Conditioning Cycle Using Text Mining
Story·Humanities student Kim Dae-ri learns how to extract unstructured data.
01 Text mining
- Filtering using the LIKE operator
- Combine fields
- Remove spaces
Kim Dae-ri's practice~!
DAY 07.
Learn basic functions
Story: Humanities student Kim Dae-ri learns basic functions.
01 Learn character/number/date functions
- Character functions
- Numeric functions
- Date functions
Kim Dae-ri's practice~!
DAY 08.
Using functions
Story·Humanities student Kim Dae-ri learns about various functions.
01 Summarizing numeric data
- COUNT function
- SUM, AVG, MAX, MIN, STDENV, VARIANCE functions
02 Understanding Conditional Statements
- CASE WHEN statement
Kim Dae-ri's practice~!
DAY 09.
Grouping and filtering data
Story·Humanities student Kim Dae-ri learns in-depth data analysis methods that group data.
01 Grouping of data
02 Filtering grouped data
Kim Dae-ri's practice~!
DAY 10.
Merge tables
Story·Humanities student Kim Dae-ri learns data analysis methods that combine two or more tables.
01 Merge Columns
- Inner join
- Outer join
02 Merge Rows
- UNION operator
- UNION ALL operator
Kim Dae-ri's practice~!
DAY 11.
Subquery
Story: Humanities student Kim Dae-ri uses subqueries to create efficient SQL statements.
01 Understanding Subqueries
- Subquery in the FROM clause
- Subquery in WHERE clause
Kim Dae-ri's practice~!
DAY 12.
Data and table manipulation
Story·Humanities student Kim Dae-ri manipulates data and tables directly.
01 Data Manipulation
- Insert data
- Data deletion
- Data modification
02 Table manipulation
- Create table
- Alter and delete tables
Kim Dae-ri's practice~!
Appendix A - Table
Appendix B - Index
Detailed image
Publisher's Review
Master SQL fundamentals in two weeks, one chapter a day!
It consists of 12 chapters in total, so you can master the basics of SQL in just two weeks.
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.
Like a pair of tongs, it is composed of only the core concepts for practical application!
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.
For those who don't have enough time to learn all the concepts, we'll explain only the most important things to know.
Learn with examples using practical terms and gain a sense of business at the same time!
If you hesitate in the field after learning a lot, the meaning of the time you spent learning will fade.
This book introduces performance indicators used in actual business operations, helping you naturally adapt them to your work.
It consists of 12 chapters in total, so you can master the basics of SQL in just two weeks.
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.
Like a pair of tongs, it is composed of only the core concepts for practical application!
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.
For those who don't have enough time to learn all the concepts, we'll explain only the most important things to know.
Learn with examples using practical terms and gain a sense of business at the same time!
If you hesitate in the field after learning a lot, the meaning of the time you spent learning will fade.
This book introduces performance indicators used in actual business operations, helping you naturally adapt them to your work.
GOODS SPECIFICS
- Date of issue: April 20, 2023
- Page count, weight, size: 228 pages | 150*210*24mm
- ISBN13: 9791193049013
- ISBN10: 1193049016
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)
