书籍详情

深入浅出SQL(影印版)

深入浅出SQL(影印版)

作者:(美)贝里 著

出版社:东南大学出版社

出版时间:2008-03-01

ISBN:9787564111380

定价:¥98.00

购买这本书可以去
内容简介
  《深入浅出SQL(影印版)》能让你学到什么?在如今的世界,数据就是力量,但是成功的真正秘诀却是管理你的数据的力量。《深入浅出SQL(影印版)》带你进入SQL语言的心脏地带,从使用INSERT和SELECT这些基本的查询语法到使用子查询(subquery)、连接(join)和事务(transaction)这样的核心技术来操作数据库。到读完《深入浅出SQL(影印版)》之时,你将不仅能够理解高效数据库设计和创建,还能像一个专家那样查询、归一(normalizing)和联接数据。你将成为数据的真正主人。为什么《深入浅出SQL(影印版)》看起来如此不同?我们认为你的时间如此宝贵以至于不应该花费在为新概念伤脑筋上面。《深入浅出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
 Acknowledgments
1 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 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... there's 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, 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 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'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 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
猜您喜欢

读书导航