SQL in 10 Minutes, 4th Edition

Name: SQL in 10 Minutes, 4th Edition
ISBN: 9787115313980

Ben FortaPosts & Telecom Press2013

4.2

Chapters: 25
Series: Turing Programming Series
ISBN: 9787115313980

Report an error Find this book

Summary

SQL in 10 Minutes, 4th Edition is a classic introductory book by the technical author Ben Forta. Originally published in English as Sams Teach Yourself SQL in 10 Minutes (4th Edition), the Chinese edition was translated by Zhong Ming and Liu Xiaoxia and published by Posts & Telecom Press in 2013 as part of the Turing Programming Series. The book is organized into 22 short lessons, each designed to take about ten minutes to read, starting from the most basic data retrieval and proceeding through sorting and filtering, filtering with wildcards and LIKE, calculated fields, data manipulation functions, summarizing and grouping, subqueries, the various kinds of table joins, combined queries, inserting, updating, and deleting data, creating and altering tables, and finally views, stored procedures, transaction processing, cursors, and advanced SQL features. The fourth edition updates the examples for major databases including IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache OpenOffice Base, and adds coverage of some database systems; the examples take differences between platforms into account wherever possible and explain incompatibilities where they arise. The appendices provide sample table scripts, an overview of common application environments, and a quick reference to SQL statement syntax, serving both systematic study and day-to-day lookup. It has long been used as a reference textbook for database courses at many universities and is the first book on SQL for many developers.

Editor's review

如果你只想认真学一本 SQL 入门书，这本几乎是最省时间的选择。它最大的优点是“薄而全”：22 课短小紧凑，每课十分钟上下就能读完并跑通示例，一两天即可完成第一轮通读，却已把 SELECT 检索、过滤排序、聚合分组、子查询、联结、增删改、建表、视图、存储过程、事务、游标一路讲到高级特性，知识骨架相当完整。第二，它始终贴着真实工作场景写，示例刻意兼顾 Oracle、SQL Server、MySQL、PostgreSQL、SQLite、DB2 等多种数据库，遇到平台差异会明确提示，学完不会被某一款数据库“绑死”。第三，它不止是教程，附录的语句语法速查与样例表脚本让它成为一本可长期放在手边的查阅手册，写查询想不起语法时翻两页就能用。需要提醒的是，本书定位是语言入门而非数据库设计，索引优化、执行计划、架构范式这些内容基本不谈；部分示例的数据库版本较旧。作为“从零到能写出可用 SQL”的第一本书，它依然值得推荐；后续再搭配 MySQL 实践或更深入的数据库系统教材即可。

Who it's for

A good fit for

完全没有 SQL 基础、希望快速上手的开发者与数据分析新手
需要经常在 MySQL 等数据库中写查询的产品、运营与测试人员
准备数据库相关课程或面试、需要系统梳理语法骨架的学生
已会一点 SQL、想找一本可随时查语法的手册的从业者

Not a good fit for

希望深入数据库设计、索引优化与执行计划调优的进阶读者
只想要某一款数据库（如 SQL Server 专有 T-SQL 深度特性）全面详解的人
需要大数据仓库、分布式 SQL 引擎等现代场景专门内容的人

Reading tips

按课程顺序通读，每课先在示例库上亲手跑一遍语句，再合上书复现。
提前准备 MySQL 或 SQLite 环境，导入附录 A 的样例表脚本，边读边练。
第一遍读完后，用自己熟悉的业务数据建几张表，把书中的联结与分组重写一遍。
把附录 C 的语法速查当作日常查阅入口，遇到报错再回到对应课程复习。

About the publisher

Posts & Telecom Press China · Founded in 1953

Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.

Lesson 1 Understanding SQL
Lesson 2 Retrieving Data
Lesson 3 Sorting Retrieved Data
Lesson 4 Filtering Data
Lesson 5 Advanced Data Filtering
Lesson 6 Filtering with Wildcards
Lesson 7 Creating Calculated Fields
Lesson 8 Using Data Manipulation Functions
Lesson 9 Summarizing Data
Lesson 10 Grouping Data
Lesson 11 Using Subqueries
Lesson 12 Joining Tables
Lesson 13 Creating Advanced Joins
Lesson 14 Combining Queries
Lesson 15 Inserting Data
Lesson 16 Updating and Deleting Data
Lesson 17 Creating and Manipulating Tables
Lesson 18 Using Views
Lesson 19 Using Stored Procedures
Lesson 20 Managing Transaction Processing
Lesson 21 Using Cursors
Lesson 22 Understanding Advanced SQL Features
Appendix A Sample Table Scripts
Appendix B Common SQL Applications
Appendix C SQL Statement Syntax

FAQ

这本书和《MySQL必知必会》有什么区别？

两者同为 Ben Forta 所著、同一套短课式写法。《SQL必知必会》讲标准 SQL 并兼顾 Oracle、SQL Server、MySQL、PostgreSQL 等多种数据库；《MySQL必知必会》则聚焦 MySQL，加入更多 MySQL 特有功能与管理相关内容。想打通用基础选前者，专攻 MySQL 选后者。

零基础、不会任何编程能读懂吗？

可以。本书从“什么是数据库、什么是 SQL”讲起，不预设编程经验，前几课只是简单检索与过滤，门槛很低。只要愿意动手在数据库里敲语句，完全可以自学。

书里的示例能直接在 MySQL 上跑吗？

大部分可以。作者为示例刻意兼顾主流数据库，并注明各平台不兼容之处；配套的样例表脚本可在附录 A 找到。少数函数或语法需按所用数据库版本微调。

第4版和更早的版本差别大吗？

第4版更新了 Oracle、SQL Server、MySQL、PostgreSQL 的示例，并新增对 SQLite、MariaDB、Apache OpenOffice Base 等系统的覆盖，代码示例改为彩色排版更易读。若手上是更早版本，核心语法知识差别不大。

读完之后应该学什么？

建议转入真实项目练习，并补充数据库设计、索引与查询优化、事务与锁等内容；可选择数据库系统原理类教材，或针对你所用数据库（如 MySQL）的进阶书继续深入。

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.