书籍 Getting Started with SQL的封面

Getting Started with SQL

Thomas Nield

出版时间

2016-02-28

ISBN

9781491938614

评分

★★★★★

标签

编程

书籍介绍

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs. You'll also learn how to: Explore relational databases, including lightweight and centralized models Use SQLite and SQLiteStudio to create lightweight databases in minutes Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY Join tables to get a more complete view of your business data Build your own tables and centralized databases by using normalized design principles Manage data by learning how to INSERT, DELETE, and UPDATE records.

用户评论
用 SQLite 当作后端,SQLiteStudio 做前端,在 Windows 系统上以几个样例数据库进行实操学习。我粗略对比这是 O'Reilly SQL 里最轻薄的教材,所需的软件也最轻量。百来页的内容覆盖了最常见的概念和操作,可以快速翻看学习。缺点目前有二:1.代码没有标记行号,所以经常把一段代码重复印刷来讲解不同的行.. 2. 一些语句的最后没有加分号 ; ,可能会导致新手困惑。这书适合新手程序员入门,或者不怎么写代码但是需要学习 SQL 的人快速入门。
Rudimentary…
SQL入门书,简单实用,基本的两个概念,join 和group,讲解清晰。作者认为join 操作是SQL的核心要点,完全同意。
sql入门书,中规中矩
入门还行
还行。帮妹子准备 SQL 面试扫了眼 3-8 章,核心语法都讲到了,并选择性地避开了 Union 和子查询这种比较鸡肋的 topic,感觉应付面试够用了。唯一的缺点是全书使用的是 sqlite 做范例。
非常入门的一本sql书,清晰明了,逻辑通畅。如果是做商业分析的话适合再配一本内容更丰富的书。可以去牛客网刷题加上自己做几个sql项目。不适合想学习database的人
一百来页
不到两小时读完,非常基础,其实本来是想看index, cursor, trigger的相关用法,但是这本书里没有提到。权当复习了。 从书本身的角度来讲,结构是很好的,讲了最基础的几个query语句用法,讲得也很清楚,但是好像没有讲字段修改那几个alter语句。 之后准备读high performance那本