
10-minute SQL at your fingertips
Description
Book Introduction
Even after 21 years and five revised editions, it remains one of the best-selling books in the programming category on Amazon in the United States.
Someone once said, "It's not the strongest who survive, but the survivors who are strong." In the IT market, where new technologies emerge daily, and amidst the cutthroat competition on Amazon, where hundreds of programming books are released daily, the reason this introductory SQL book has remained so beloved by readers for so long is because of its unique appeal.
Someone once said, "It's not the strongest who survive, but the survivors who are strong." In the IT market, where new technologies emerge daily, and amidst the cutthroat competition on Amazon, where hundreds of programming books are released daily, the reason this introductory SQL book has remained so beloved by readers for so long is because of its unique appeal.
- You can preview some of the book's contents.
Preview
index
Translator's Preface
Author's Preface
Acknowledgements
How to Get the Most Out of This Book for SQL Beginners
Chapter 1: Understanding SQL
Chapter 2: Importing Data
Chapter 3 Sorting the Imported Data
Chapter 4 Data Filtering
Chapter 5 Advanced Data Filtering
Chapter 6 Filtering Using Wildcard Characters
Chapter 7: Creating Calculated Fields
Chapter 8: Using Data Manipulation Functions
Chapter 9 Data Summary
Chapter 10: Data Grouping
Chapter 11: Using Subqueries
Chapter 12 Table Joins
Chapter 13: Creating Advanced Table Joins
Chapter 14: Combining Queries
Chapter 15: Inserting Data
Chapter 16: Updating and Deleting Data
Chapter 17: Creating and Manipulating Tables
Chapter 18 Using Views
Chapter 19: Using Stored Procedures
Chapter 20: Managing Transaction Processing
Chapter 21: Using the Cursor
Chapter 22 Advanced Data Manipulation Options
Appendix A Sample Table Script
Appendix B Using Oracle Live SQL
Appendix C SQL Grammar
Appendix D Using SQL Data Types
Appendix E SQL Reserved Words
Appendix F Challenge Answers
Author's Preface
Acknowledgements
How to Get the Most Out of This Book for SQL Beginners
Chapter 1: Understanding SQL
Chapter 2: Importing Data
Chapter 3 Sorting the Imported Data
Chapter 4 Data Filtering
Chapter 5 Advanced Data Filtering
Chapter 6 Filtering Using Wildcard Characters
Chapter 7: Creating Calculated Fields
Chapter 8: Using Data Manipulation Functions
Chapter 9 Data Summary
Chapter 10: Data Grouping
Chapter 11: Using Subqueries
Chapter 12 Table Joins
Chapter 13: Creating Advanced Table Joins
Chapter 14: Combining Queries
Chapter 15: Inserting Data
Chapter 16: Updating and Deleting Data
Chapter 17: Creating and Manipulating Tables
Chapter 18 Using Views
Chapter 19: Using Stored Procedures
Chapter 20: Managing Transaction Processing
Chapter 21: Using the Cursor
Chapter 22 Advanced Data Manipulation Options
Appendix A Sample Table Script
Appendix B Using Oracle Live SQL
Appendix C SQL Grammar
Appendix D Using SQL Data Types
Appendix E SQL Reserved Words
Appendix F Challenge Answers
Publisher's Review
Three features of "10-Minute SQL".
· 10 minutes a day, 22 days to become a SQL master
Explains the core grammar of SQL in an easy-to-understand manner in short breaths.
· Concise but systematic examples
There is a well-structured practice data that allows you to feel the essence of SQL.
· Feels like learning multiple DBMSs in one go
Introduces common grammar without being limited to a specific DBMS, but also pays attention to differences between DBMSs.
The Korean version (revised edition) provides:
· Provides a method for practicing on an online site (Oracle Live SQL)
You can start practicing right away by simply accessing the site and setting up data without having to install a complex DBMS.
· Challenge solutions provided as an appendix
Provides answers and implementation results for supplementary practice assignments added for the first time in the revised edition.
· 10 minutes a day, 22 days to become a SQL master
Explains the core grammar of SQL in an easy-to-understand manner in short breaths.
· Concise but systematic examples
There is a well-structured practice data that allows you to feel the essence of SQL.
· Feels like learning multiple DBMSs in one go
Introduces common grammar without being limited to a specific DBMS, but also pays attention to differences between DBMSs.
The Korean version (revised edition) provides:
· Provides a method for practicing on an online site (Oracle Live SQL)
You can start practicing right away by simply accessing the site and setting up data without having to install a complex DBMS.
· Challenge solutions provided as an appendix
Provides answers and implementation results for supplementary practice assignments added for the first time in the revised edition.
GOODS SPECIFICS
- Publication date: October 16, 2020
- Page count, weight, size: 320 pages | 172*225*30mm
- ISBN13: 9788966262687
- ISBN10: 8966262686
You may also like
카테고리
korean
korean