Sams Teach Yourself SQL in 24 Hours, Sixth Edition
Tags
Summary
Sams Teach Yourself SQL in 24 Hours, Sixth Edition is the Chinese translation of the bestselling Sams tutorial Sams Teach Yourself SQL in 24 Hours, published by Posts & Telecom Press as part of its Teach Yourself series. The book has 24 chapters arranged at a pace of one hour per chapter, finishing in a day, and systematically teaches the SQL language to complete beginners. It begins with the definition and history of SQL and the ANSI SQL standard (referenced here as SQL-2011), then gradually covers database and table creation, choosing data types, integrity constraints, normalization and denormalization, and other design-level knowledge; it then moves into the core of data handling: inserting, updating, and deleting data with DML statements, managing transactions, writing queries, filtering data with operators, summarizing, sorting, and grouping, reshaping the presentation of query results, handling dates and times, joining multiple tables, using subqueries, and combining multiple queries. The latter part turns to advanced and operational topics: improving performance with indexes and optimization techniques, managing database users and security, using views and synonyms, querying the system catalog, and discussing SQL extensions in enterprise and Web environments, as well as the important extensions to standard SQL by Oracle and Microsoft SQL Server. Each chapter includes Q&A, a quiz, and a summary, and the appendices at the end include a quick reference to common SQL commands, installation instructions for Oracle and Microsoft SQL, answers to quizzes and exercises, and additional exercises, making it easy to learn by doing and to check your own progress.
Editor's review
这是一本“按小时计费”的 SQL 教程：24 章对应 24 个学习单元，每章篇幅克制，通勤路上或晚饭后读一章就能消化，特别适合怕被大部头劝退的初学者。 它的长处在于“标准 + 差异”的双轨写法。多数入门书只教你一种数据库的语法，而这本在讲清 ANSI SQL 通用规则的同时，反复提示 MySQL、Oracle、SQL Server 在实现上的差别——这是很多初学者第一次换数据库就踩坑的地方，提前知道能少走不少弯路。 结构上也是循序渐进的教科书式安排：先讲数据类型、建表、约束和规格化，把“表该怎么设计”这层地基打稳，再进入查询、连接、子查询、聚合与分组这些日常最常用的操作，最后才谈索引、性能优化、权限与安全、视图和系统目录。每章后面的问与答、测验和练习不是摆设，题目紧扣正文的例子，做一遍就能自查是否真懂。 书末附录相当实用：常用 SQL 命令速查表可以当案头手册，Oracle 与 Microsoft SQL 的安装说明省去初学配置环境的麻烦，测验答案和额外练习则让自学的人不至于卡住没人问。第6版相较上一版做了内容更新，页数与篇幅更精炼，作为一本可通读、可查阅的入门书，性价比不错。
Who it's for
A good fit for
- 零基础想系统学习 SQL 语法与数据库基本概念的自学者
- 计算机、信息管理等相关专业需要配套教材的在校学生
- 已会用 Excel 处理数据、想进一步用 SQL 查库的职场新人
- 需要补足数据库基础后再学 MySQL、Oracle 等具体产品的开发者
- 数据分析、运营、测试等岗位中需要写查询语句的非专职开发人员
Not a good fit for
- 已有多年数据库经验、想深入钻研执行计划与内核的资深 DBA
- 希望专攻某一数据库产品的运维调优、需要大量实战案例的读者
- 只想速成某个 ORM 框架或 BI 工具、不打算学 SQL 语法的人
Reading tips
- 按章节顺序读，每章读完后立刻动手敲一遍书中的示例语句，输入比阅读更能记住语法。
- 提前装好一个可用的数据库环境（书中附录有安装说明），把附录里的示例表建起来，边学边查。
- 重点做每章的测验与练习，做错的题回到对应小节重读，比通读两遍更有效。
- 读完查询与连接章节后，可以找一份公开数据集自己出题练习，把书中的语法迁移到真实数据上。
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
- Chapter 1 Welcome to the World of SQL
- Chapter 2 Defining Data Structures
- Chapter 3 Managing Database Objects
- Chapter 4 The Normalization Process
- Chapter 5 Manipulating Data
- Chapter 6 Managing Database Transactions
- Chapter 7 Introduction to Database Queries
- Chapter 8 Using Operators to Categorize Data
- Chapter 9 Summarizing the Data in Queries
- Chapter 10 Sorting and Grouping Data
- Chapter 11 Restructuring the Appearance of Data
- Chapter 12 Dates and Times
- Chapter 13 Joining Tables in Queries
- Chapter 14 Using Subqueries to Define Unknown Data
- Chapter 15 Combining Multiple Queries into One
- Chapter 16 Using Indexes to Improve Performance
- Chapter 17 Improving Database Performance
- Chapter 18 Managing Database Users
- Chapter 19 Managing Database Security
- Chapter 20 Creating and Using Views and Synonyms
- Chapter 21 Working with the System Catalog
- Chapter 22 Advanced SQL Topics
- Chapter 23 Extending SQL to the Enterprise, the Internet, and the Intranet
- Chapter 24 Extensions to Standard SQL
- Appendix A Common SQL Commands
- Appendix B Installing Oracle and Microsoft SQL
- Appendix C Answers to Quizzes and Exercises
- Appendix D Additional Exercises
- Glossary
FAQ
这本书适合零基础的人看吗？
适合。全书从 SQL 是什么、数据库由哪些对象组成讲起，不预设编程经验；每章篇幅短、配有示例与测验，是典型的初学者教材。但完全没接触过计算机的人仍需先了解基本的表、行、列概念。
这本书讲的是哪个数据库的 SQL？
以 ANSI SQL 标准为主线（书中参照 SQL-2011 标准），同时指出 MySQL、Oracle、Microsoft SQL Server 等主流实现在语法上的差异，并附有 Oracle 和 Microsoft SQL 的安装说明，属于“标准优先、兼顾各家”的写法。
第6版和第5版有什么区别？
两版作者和译者团队基本延续，框架同为 24 章。第6版由人民邮电出版社于 2020 年出版，郝记生、王士喜翻译，页数 327 页，较第5版的 349 页更为精炼，并对标准版本与部分内容做了更新；第5版由井中月、郝记生翻译，2011 年出版。
零基础学到什么程度算学完这本书？
能独立建表并设置主键、外键等约束，写出带条件筛选、聚合汇总、多表连接和子查询的查询语句，理解事务与视图的作用，并能看懂简单的索引与权限设置，基本就达到了本书设定的目标水平。
书里的例子用的是什么数据库和示例数据？
书中使用一套带统一命名规范的示例表（表名以 _TBL 后缀命名并定义主键等约束）贯穿全书，附录提供常用 SQL 命令速查和安装说明，读者可在 MySQL、Oracle 或 SQL Server 上自行建表复现例子。
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.
