深入浅出SQL（影印版） PDF下载

编辑推荐

　　“这本书不是让SQL变得容易，而是让SQL变得有挑战性，变得有趣，变得好玩。本书甚至回答了那个老问题：如何讲解无关联子查询而不会因此失去活下去的愿望？本书是正确的学习途径——快速、活泼、而且看上去很酷。”

　　　　　　　　　　　　——Andrew Cumming，《SQL Hacks》的作者，sqlzoo.net的管理员

　　“有些书你会买，有些你会保存，有些你会放在案头，感谢O’Reilly和Head First团队开创了终极的Head First（深入浅出）系列。这个系列的书籍会被逐页翻阅，变得皱皱巴巴并被随身携带。《深入浅出SQL》在我的书堆的**。”

　　　　　　　　　　　　　　——Bill Sawyer，ATG培训经理，Oracle

　　作者介绍：Lynn is a fiction writer stuck in a technical book writers body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it.

　　After going back to school to get a Masters in computer science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. ；

内容简介

你将从本书学到什么？

　　在如今的世界，数据就是力量，但是成功的真正秘诀却是管理你的数据的力量。《深入浅出SQL》带你进入SQL语言的心脏地带，从使用INSERT和SELECT这些基本的查询语法到使用子查询（subquery）、连接（join）和事务（transaction）这样的核心技术来操作数据库。到读完本书之时，你将不仅能够理解高效数据库设计和创建，还能像一个专家那样查询、归一（normalizing）和联接数据。你将成为数据的真正主人。

　　为什么本书看起来如此不同？

　　我们认为你的时间如此宝贵以至于不应该花费在为新概念伤脑筋上面。《深入浅出SQL》用*的认知科学和学习理论打造多感官的学习体验，它运用丰富的视觉形式激发你的大脑工作，而不是密密麻麻的文字让你看了昏昏欲睡。

作者简介

暂无

深入浅出SQL（影印版） PDF下载

Intro
　Who iS this book for?
 We know what you’re thinking
　Metacognition
　Bend your brain into submission
　Readmc
　The technical review team
　Acknowledgments
1 Data and Tables: A place for everything 
 Defining your data
 Look at your data in categories
　Whats in a database?
　Your database viewed through x-ray specs
　Databases contain connected data
　Tables Up Close
　Take command!
 Setting the table: the CREATE TABLE statement
 Creating a more complicated table
 Look how easy it is to write SQL
 Create the mycontacts table, finally
 Your table is ready
 Take a meeting with some data types
 Your table, DESCribed
 You can	 recreate an existing table or database!
 Out with the old table, in with the new
 To add data to your table, youll use the INSERT statement
 Create the INSERT statement
 Variations on an INSERT statement
 Columns without values
 Peek at your table with the SELECT statement
 SQL Exposed: Confessions of a NULL
 Controlling your inner NULL
 NOT NULL appears in DESC
 Fill in the blanks with DEFAULT
 Your SQL Toolbox
2 The SELECT Statement: Gifted data retrieval 
　Date or no date?
　A better SELECT
　What the * is that?
 How to query your data types
 More punctuation problems
 Unmatched single quotes
 Single quotes are special characters
　INSERT data with single quotes in it
 SELECT specific columns to limit results
 SELECT specific columns for faster results
 Combining your queries
 Finding numeric values
 SmComparison Operators
 Finding numeric data with Comparison Operators
 Text data roping with Comparison Operators
 To be OR not to be
　The difference between AND and OR
　Use IS NULL to find NULLs
　Saving time with a single keyword: LIKE
　The call of the Wild(card)
　Selecting ranges using AND and comparison operators
　Just BETWEEN us... theres a better way
　After the dates, you are either IN...
　... or you are NOT IN
　More NOT
　Your SQL Toolbox
3 DELETE and UPDATE: A change will do you good 
　Clowns are scary
　Clown tracking
　The clowns are on the move
　How our clown data gets entered
　Bonzo, weve got a problem
　Getting rid of a record with DELETE
　Using our new DELETE statement
　DELETE rules
　The INSERT-DELETE two step
　Be careful with your DELETE
　The trouble with imprecise DELETE
　Change your data with UPDATE
　UPDATE rules
　UPDATE is the new INSERT-DELETE
　UPDATE in action
　Updating the clowns movements
　UPDATE your prices
　All we need is one UPDATE
　YOur SQL Tbolbox
4 Smart Table Design: Why be normal? 
　Two fishy tables
　A table is all about relationships
　Atomic data
　Atomic data and your tables
　Atomic data rules
　Reasons to be normal
　The benefits of normal tables
　Clowns aren	 normal
　Halfway to 1NF
　PRIMARY KEY rules
　Getting to NORMAL
　Fixing Gregs table
　The CREATE TABLE we wrote
　Show me the
　Time-saving command
　The CREATE TABLE with a PRIMARY KEY
　1, 2, 3... auto incrementally
　Adding a PRIMARY KEY to an existing table
　ALTER TABLE and add a PRIMARY KEY
　Your SQL Toolbox
5 ALTER: Rewriting the past 
6 Advanced SELECT: Seeing your data with new eyes 
7 Multi-table Database Design: Outgrowing your table 
8 Joins and Multi-table Operations: Can’t we all just get along? 
9 Subqueries: Queries Within Queries 
10 Outer Joins, Self Joins, and Unions: New maneuvers 
11 Constraints, Views, and Transactions: Too many cooks spoil the database 
12 Security: Protecting your assets