深入浅出SQL

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

为什么《深入浅出SQL(影印版)》看起来如此不同？

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

(展开全部)

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

为什么《深入浅出SQL(影印版)》看起来如此不同？

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

Intro　Who iS this book for? We know what you’re thinking　Metacognition　Bend your brain into submission　Readmc　The technical review team　Acknowledgments1 Data and Tables: A place for everything Defining your data Look at your data in categories　What's 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't recreate an existing table or database! Out with the old table, in with the new To add data to your table, you'll 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 Toolbox2 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... there's a better way　After the dates, you are either IN...　... or you are NOT IN　More NOT　Your SQL Toolbox3 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, we've 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 Tbolbox4 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't normal　Halfway to 1NF　PRIMARY KEY rules　Getting to NORMAL　Fixing Greg's 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 Toolbox5 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

Intro　Who iS this book for? We know what you’re thinking　Metacognition　Bend your brain into submission　Readmc　The technical review team　Acknowledgments1 Data and Tables: A place for everything Defining your data Look at your data in categories　What's 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't recreate an existing table or database! Out with the old table, in with the new To add data to your table, you'll 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 Toolbox2 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... there's a better way　After the dates, you are either IN...　... or you are NOT IN　More NOT　Your SQL Toolbox3 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, we've 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 Tbolbox4 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't normal　Halfway to 1NF　PRIMARY KEY rules　Getting to NORMAL　Fixing Greg's 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 Toolbox5 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
· · · · · · (收起)