快速掌握SQL：《Head First SQL》指南

需积分: 0 161 浏览量更新于2024-07-27 收藏 47.88MB PDF 举报

"《Head First SQL》是一本由Lynn Beighley所著，属于著名的技术图书系列——Head First 的一部分，该系列以其创新和易于理解的教学方法而闻名。这本书的目标是帮助读者快速掌握SQL（Structured Query Language）语言，这是一种用于管理和处理关系数据库的标准语言。该书于2007年出版，由O'Reilly Media公司发行，享有版权保护。书中详细讲解了SQL的基础概念，包括查询、数据类型、表和视图的创建与操作、数据库设计、聚合函数、子查询、存储过程和触发器等内容，适合初学者以及有一定编程基础的读者使用。作者运用图形化、互动式的学习方式，将复杂的SQL语法和理论知识以生动有趣的方式呈现，使读者能够在轻松愉快的阅读过程中逐渐理解和掌握。《Head First SQL》不仅适用于个人自学，也常被用作IT教育课程中的教材，它强调实践和动手操作的重要性，鼓励读者通过编写实际的SQL语句来加深对概念的理解。此外，电子版在线资源也在O'Reilly Safari网站上提供，便于读者根据需要随时查阅或学习。本书的创作团队包括Kathy Sierra和Bert Bates，Series Editor是Brett D. McLaughlin，Catherine Nolan担任编辑，Louise Barr负责设计， Sanders Kleinfeld负责生产编辑，Julie Hawks负责索引制作，Andrew Fader负责页面查看。印刷历史显示，这是2007年首次发行的第一版。在版权方面，O'Reilly Media公司的商标受到保护，Head First系列、《Head First SQL》以及相关的商业标识均为O'Reilly Media的注册商标。书中提及的许多制造商和销售商使用的名称和标记，如果被声称是商标，也是他们用于区分产品的重要标志。《Head First SQL》是一本深入浅出的SQL教程，通过其独特的教学方法和丰富的实例，让读者能够有效地学习和掌握这一关键的数据库管理工具。"

table of contents

xxii

The Top Ten Topics (we didn’t cover)

leftovers

Even after all that, there’s a bit more. There are just a few

more things we think you need to know. We wouldn’t feel right about ignoring

them, even though they only need a brief mention. So before you put the book

down, take a read through these short but important SQL tidbits.

Besides, once you’re done here, all that’s left is another appendix... and the

index... and maybe some ads... and then you’re really done. We promise!

#1. Get a GUI for your RDBMS 526

#2. Reserved Words and Special Characters 528

#3. ALL, ANY, and SOME 530

#4. More on Data Types 532

#5. Temporary tables 534

#6. Cast your data 535

#7. Who are you? What time is it? 536

#8. Useful numeric functions 537

#9. Indexing to speed things up 539

#10. 2-minute PHP/MySQL 540

ABSOLUTE ACTION ADD ADMIN AFTER AGGREGATE ALIAS ALL ALLOCATE ALTER AND ANY ARE ARRAY AS

ASC ASSERTION AT AUTHORIZATION

BEFORE BEGIN BINARY BIT BLOB BOOLEAN BOTH BREADTH BY

CALL CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHECK CLASS CLOB CLOSE COLLATE

COLLATION COLUMN COMMIT COMPLETION CONNECT CONNECTION CONSTRAINT CONSTRAINTS

CONSTRUCTOR CONTINUE CORRESPONDING CREATE CROSS CUBE CURRENT CURRENT_DATE

CURRENT_PATH CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CYCLE

DATA DATE DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DEPTH

DEREF DESC DESCRIBE DESCRIPTOR DESTROY DESTRUCTOR DETERMINISTIC DICTIONARY DIAGNOSTICS

DISCONNECT DISTINCT DOMAIN DOUBLE DROP DYNAMIC

EACH ELSE END END_EXEC EQUALS ESCAPE EVERY EXCEPT EXCEPTION EXEC EXECUTE EXTERNAL

FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FREE FULL FUNCTION

GENERAL GET GLOBAL GO GOTO GRANT GROUP GROUPING

HAVING HOST HOUR

IDENTITY IGNORE IMMEDIATE IN INDICATOR INITIALIZE INITIALLY INNER INOUT INPUT INSERT

INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION ITERATE

JOIN

KEY

LANGUAGE LARGE LAST LATERAL LEADING LEFT LESS LEVEL LIKE LIMIT LOCAL LOCALTIME

LOCALTIMESTAMP LOCATOR

MAP MATCH MINUTE MODIFIES MODIFY MODULE MONTH

NAMES NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NONE NOT NULL NUMERIC

OBJECT OF OFF OLD ON ONLY OPEN OPERATION OPTION OR ORDER ORDINALITY OUT OUTER OUTPUT

PAD PARAMETER PARAMETERS PARTIAL PATH POSTFIX PRECISION PREFIX PREORDER PREPARE

PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC

READ READS REAL RECURSIVE REF REFERENCES REFERENCING RELATIVE RESTRICT RESULT RETURN

RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUTINE ROW ROWS

SAVEPOINT SCHEMA SCROLL SCOPE SEARCH SECOND SECTION SELECT SEQUENCE SESSION

SESSION_USER SET SETS SIZE SMALLINT SOME SPACE SPECIFIC SPECIFICTYPE SQL SQLEXCEPTION

SQLSTATE SQLWARNING START STATE STATEMENT STATIC STRUCTURE SYSTEM_USER

TABLE TEMPORARY TERMINATE THAN THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO

TRAILING TRANSACTION TRANSLATION TREAT TRIGGER TRUE

UNDER UNION UNIQUE UNKNOWN UNNEST UPDATE USAGE USER USING

VALUE VALUES VARCHAR VARIABLE VARYING VIEW

WHEN WHENEVER WHERE WITH WITHOUT WORK WRITE

YEAR

ZONE

剩余585页未读，继续阅读

yyj_lmg

粉丝: 0
资源: 4

快速掌握SQL：《Head First SQL》指南

Head First SQL学习指南：快速掌握SQL基础知识

HeadFirst SQL：轻松掌握数据库精髓

Head First SQL：经典英文完整版电子书分享

head first sql

Head First Sql

Head first SQL

Head First SQL笔记

深入浅出sql head first sql

Head First SQL阅读笔记

Head First SQL 图片版

最新资源