滿額折
A Visual Introduction To Sql, Second Edition
商品資訊
ISBN13：9780471412762
出版社：John Wiley & Sons Inc
作者：Chappell
出版日：2001/11/12
裝訂／頁數：平裝／304頁
商品簡介
作者簡介
目次
商品簡介
Learn SQL basics quickly with this visual tutorial featuring over 125 graphics SQL (Structured Query Language) is the tool used to access nearly all databases, which means that most software professionals should understand at least the basics. This hands-on tutorial offers an accessible introduction to SQL using over 125 graphics to illustrate the lessons. The book's unique visual approach makes it much easier for the reader to learn SQL. This Second Edition has been updated with new graphics and covers such subjects as the SELECT statement, joins, subqueries, views, granting and revoking privileges, and creating and destroying tables.
作者簡介
DAVID CHAPPELL is Principal of David Chappell & Associates (www.davidchappell.com) in San Francisco, California. David's popular keynotes and seminars have been presented in more than two dozen countries, and his books on enterprise software have been translated into ten languages.
J. HARVEY TRIMBLE Jr. is Managing Director of eBusiness Product Development at Fannie Mae in Washington, D.C. He is responsible for business and product development for the electronic distribution of Fannie Mae's underwriting guidelines and eMortgage capabilities.
J. HARVEY TRIMBLE Jr. is Managing Director of eBusiness Product Development at Fannie Mae in Washington, D.C. He is responsible for business and product development for the electronic distribution of Fannie Mae's underwriting guidelines and eMortgage capabilities.
目次
Foreword.
Preface.
Chapter 1: Introducing SQL.
Kinds of Database Systems.
Relational Concepts.
Tables, Rows, and Columns.
Keys.
An Example Table.
The Visual Approach.
Chapter 2: Elements of the Language.
Ways to Use SQL.
Versions of SQL.
Defining the Language.
Data Types.
The Structure of SQL Statements.
Keywords.
An Example Database.
Organization of the Examples.
Chapter 3: Retrieving Data from a Table: The SELECT Statement.
Selecting Specific Columns in a Table.
Selecting All Columns in a Table.
Selecting Only Some of a Table's Records: The WHERE Clause.
Comparisons in a WHERE Clause.
Combining Predicates in a WHERE Clause.
Using AND.
Using OR.
Using NOT.
Other Uses of WHERE.
BETWEEN and NOT BETWEEN.
LIKE and NOT LIKE.
IN and NOT IN.
IS NULL and IS NOT NULL.
Chapter 4: More on SELECT.
Ordering Selected Data.
Doing Arithmetic with Selected Information.
Using Aggregates.
Finding Maximum and Minimum Values.
Totaling Columns.
Finding Averages.
Counting Records.
Using DISTINCT.
Grouping Selected Data.
More on Grouping: The HAVING Clause.
Chapter 5: Retrieving Data from Several Tables: Joins.
Qualified Names.
What Is a Join?
Restricting the Results of a Join.
Query Diagrams for Joins.
Joining Tables Using the Join Operator.
Manipulating the Results of a Join.
Aliases.
Joins with Three Tables.
The Visual Approach with More Than Two Tables.
Joins with More Than Three Tables.
Retrieving the Same Information in Different Ways.
Using GROUP BY in a Join.
Chapter 6: Queries within Queries: Subqueries.
What Is a Subquery?
Using Comparison Operators with Subqueries.
Using ANY and ALL.
Existence Tests.
Correlated Subqueries.
Using HAVING with Correlated Subqueries.
Chapter 7: Creating and Destroying Tables.
Creating a Table.
Disallowing NULL Values.
Requiring Unique Values in a Column.
Destroying (Dropping) Tables.
Chapter 8: Adding, Modifying, and Deleting Records.
Adding Records to a Table.
Adding Records with Values Only for Some Columns.
Adding Records Using SELECT.
Modifying Records in a Table.
Deleting Records from a Table.
Chapter 9: Views.
Creating Views.
Creating Views Based on One Table.
Creating Views Based on More Than One Table.
Queries Using Views.
Selecting Records from a View.
Adding Records to a View.
Modifying Records in a View.
Deleting Records from a View.
Destroying (Dropping) Views.
Chapter 10: Granting and Revoking Privileges.
Granting Privileges.
Granting Privileges on Views.
Passing Privileges On: The GRANT Option.
Revoking Privileges.
Chapter 11: Advanced Topics.
Indexes.
Creating Indexes.
When to Create Indexes.
Destroying Indexes.
Using Multiple SQL Statements to Solve a Problem.
Outer Joins.
Unions.
Joining a Table with Itself.
Final Thoughts.
Appendix A: The Example Database.
Appendix B: List of Examples.
Appendix C: The Example Database.
Index.
Preface.
Chapter 1: Introducing SQL.
Kinds of Database Systems.
Relational Concepts.
Tables, Rows, and Columns.
Keys.
An Example Table.
The Visual Approach.
Chapter 2: Elements of the Language.
Ways to Use SQL.
Versions of SQL.
Defining the Language.
Data Types.
The Structure of SQL Statements.
Keywords.
An Example Database.
Organization of the Examples.
Chapter 3: Retrieving Data from a Table: The SELECT Statement.
Selecting Specific Columns in a Table.
Selecting All Columns in a Table.
Selecting Only Some of a Table's Records: The WHERE Clause.
Comparisons in a WHERE Clause.
Combining Predicates in a WHERE Clause.
Using AND.
Using OR.
Using NOT.
Other Uses of WHERE.
BETWEEN and NOT BETWEEN.
LIKE and NOT LIKE.
IN and NOT IN.
IS NULL and IS NOT NULL.
Chapter 4: More on SELECT.
Ordering Selected Data.
Doing Arithmetic with Selected Information.
Using Aggregates.
Finding Maximum and Minimum Values.
Totaling Columns.
Finding Averages.
Counting Records.
Using DISTINCT.
Grouping Selected Data.
More on Grouping: The HAVING Clause.
Chapter 5: Retrieving Data from Several Tables: Joins.
Qualified Names.
What Is a Join?
Restricting the Results of a Join.
Query Diagrams for Joins.
Joining Tables Using the Join Operator.
Manipulating the Results of a Join.
Aliases.
Joins with Three Tables.
The Visual Approach with More Than Two Tables.
Joins with More Than Three Tables.
Retrieving the Same Information in Different Ways.
Using GROUP BY in a Join.
Chapter 6: Queries within Queries: Subqueries.
What Is a Subquery?
Using Comparison Operators with Subqueries.
Using ANY and ALL.
Existence Tests.
Correlated Subqueries.
Using HAVING with Correlated Subqueries.
Chapter 7: Creating and Destroying Tables.
Creating a Table.
Disallowing NULL Values.
Requiring Unique Values in a Column.
Destroying (Dropping) Tables.
Chapter 8: Adding, Modifying, and Deleting Records.
Adding Records to a Table.
Adding Records with Values Only for Some Columns.
Adding Records Using SELECT.
Modifying Records in a Table.
Deleting Records from a Table.
Chapter 9: Views.
Creating Views.
Creating Views Based on One Table.
Creating Views Based on More Than One Table.
Queries Using Views.
Selecting Records from a View.
Adding Records to a View.
Modifying Records in a View.
Deleting Records from a View.
Destroying (Dropping) Views.
Chapter 10: Granting and Revoking Privileges.
Granting Privileges.
Granting Privileges on Views.
Passing Privileges On: The GRANT Option.
Revoking Privileges.
Chapter 11: Advanced Topics.
Indexes.
Creating Indexes.
When to Create Indexes.
Destroying Indexes.
Using Multiple SQL Statements to Solve a Problem.
Outer Joins.
Unions.
Joining a Table with Itself.
Final Thoughts.
Appendix A: The Example Database.
Appendix B: List of Examples.
Appendix C: The Example Database.
Index.
購物須知
外文書商品之書封，為出版社提供之樣本。實際出貨商品，以出版社所提供之現有版本為主。部份書籍，因出版社供應狀況特殊，匯率將依實際狀況做調整。
無庫存之商品，在您完成訂單程序之後，將以空運的方式為你下單調貨。為了縮短等待的時間，建議您將外文書與其他商品分開下單，以獲得最快的取貨速度，平均調貨時間為1~2個月。
為了保護您的權益，「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨，請在商品鑑賞期內寄回，且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。