网站首页  软件下载  游戏下载  翻译软件  电子书下载  电影下载  电视剧下载  教程攻略

请输入您要查询的图书:

 

书名 深入浅出SQL(影印版)
分类
作者 (美)贝里
出版社 东南大学出版社
下载
简介
编辑推荐

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

《深入浅出SQL》用最新的认知科学和学习理论打造多感官的学习体验,它运用丰富的视觉形式激发你的大脑工作,而不是密密麻麻的文字让你看了昏昏欲睡。

内容推荐

你将从本书学到什么?

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

目录

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

随便看

 

霍普软件下载网电子书栏目提供海量电子书在线免费阅读及下载。

 

Copyright © 2002-2024 101bt.net All Rights Reserved
更新时间:2025/4/1 4:16:10