SQL in 10 Minutes, Sams Teach Yourself (5th Edition)
Tags
Summary
SQL in 10 Minutes, Sams Teach Yourself (5th Edition) is a classic introductory SQL book by American technical author Ben Forta, corresponding to the fifth edition of Sams Teach Yourself SQL in 10 Minutes a Day. The Chinese edition is translated by Zhong Ming and Liu Xiaoxia and published by Posts & Telecom Press. The book is organized into "lessons," 22 in total, about 206,000 characters, concise in length and direct in approach. It begins with basic concepts such as databases, tables, columns, and schemas, then moves directly into retrieving data with SELECT, followed in turn by sorting retrieved data (ORDER BY), filtering data with the WHERE clause, advanced data filtering (AND/OR, IN, NOT), filtering with LIKE wildcards, creating calculated fields, using functions to process data, summarizing data (aggregate functions), grouping data (GROUP BY and HAVING), subqueries, joining tables and advanced joins, combining queries (UNION), inserting data, updating and deleting data, creating and manipulating tables, and advanced features such as views, stored procedures, transaction processing, cursors, constraints, indexes, triggers, and database security. The appendices provide sample table scripts, SQL statement syntax, data types, reserved words, and a quick-reference table of common statements. Unlike other database textbooks, this book does not lay out relational algebra, normalization, and other theory but unfolds around query needs in actual work scenarios, striving to let readers with little SQL experience write usable statements as soon as possible; because major DBMSs (such as Oracle, SQL Server, MySQL, PostgreSQL, SQLite, MariaDB, and others) differ in syntax, the examples accommodate multiple implementations and point out dialect differences. Each lesson ends with a summary and challenge questions so readers can practice and consolidate immediately after reading; this "short lesson plus exercises" arrangement also lets it serve as a desk reference. The book's length is moderate, suitable for self-study from zero, and it is often used as a reference in university database courses. This entry corresponds to the Chinese edition of the 5th edition (ISBN 9787115539168), a different edition in the same series as the 2007 3rd edition and the 2013 4th edition.
Editor's review
很多 SQL 教材败在“讲得太全”：理论铺开没完，读者却还没写出第一句查询。这本书反其道而行，一上来就是 SELECT，把排序、过滤、分组、联结、子查询这些日常最需要的招式一课一课过完，每课短小，读完就能上手试验。 本·福达是写了几十本技术书的老手，语言干净利落，几乎不给读者走神的机会；钟鸣、刘晓霞的译文也保持了这种简洁风格。第5版相较旧版全面更新了示例，并在每课末尾加了挑战题，学完不必再另找练习，直接做题对答案就能检验掌握程度。附录里的语句语法、数据类型、保留字和速查表，则让它在读完第一遍之后依然有留在书桌上的理由。 不足之处也要说清：它不教你数据库设计，不讲范式与索引的底层原理，存储过程、游标、触发器这几课只是点到为止，且不同 DBMS 的写法差异容易被快速略过。所以这是一本入口之书，它能带你稳稳踏上 SQL 的第一步，后续的调优和架构仍需别的书来补。 整体而言，篇幅两百余页、豆瓣 9.0 分的口碑，配上不高的门槛，是入门 SQL 时比较稳妥的一本。
Who it's for
A good fit for
- 完全没写过 SQL、想快速上手的编程初学者
- 需要写查询取数的产品、运营与数据分析人员
- 做后端开发但 SQL 基础不牢的程序员用来补课
- 数据库课程的学生，作为教材之外的配套练习书
Not a good fit for
- 想深入数据库原理、范式设计与查询优化的人
- 已有多年 SQL 经验、寻找进阶性能调优内容的读者
- 只想学某一特定数据库（如 Oracle 专项认证）的人
Reading tips
- 先按课序通读，每课读完立刻在本地或在线数据库上敲一遍示例语句。
- 附录A 的样例表脚本建议提前导入，全书示例和挑战题都依赖这套表。
- 遇到存储过程、游标等章节，可结合自己使用的 DBMS 文档对照阅读，注意方言差异。
- 学完后把附录中的常用语句速查表当作日常检索工具，不必强记语法细节。
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.
Contents
- 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 Functions to Process Data
- 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 Advanced SQL Features
- Appendix A Sample Table Scripts
- Appendix B SQL Statement Syntax
- Appendix C SQL Data Types
- Appendix D SQL Reserved Words
- Quick Reference for Common SQL Statements
- Index
FAQ
这本书适合零基础自学吗？
适合。全书从数据库、表、行、列等概念讲起，不预设编程背景，第一课之后就开始写 SELECT，配合每课挑战题可以边读边练。
第5版和第3版、第4版有什么差别？
第5版是《Sams Teach Yourself SQL in 10 Minutes a Day》第5版的新译，更新了全部案例，并在每课末尾增加了挑战题；旧版章节结构相近，但示例数据与内容有所调整。
书里的例子用哪种数据库？
示例尽量兼顾多种主流 DBMS，如 MySQL、SQL Server、Oracle、PostgreSQL、SQLite 等，并会提示不同实现的语法区别，附录A给出通用样例表脚本。
读完能到什么程度？
能熟练写出日常的增删改查、分组汇总、多表联结与子查询，理解视图、事务、约束、索引等概念的基本用法；更深的设计与调优需另找进阶书。
需要先学一门编程语言吗？
不需要。SQL 是独立的声明式查询语言，本书内容不依赖任何编程语言的语法知识，但了解基本的表格数据概念会更顺畅。
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.
