A Visual Introduction to SQL,9780471412762

A Visual Introduction to SQL

by ;
Edition: 2nd
ISBN13: 9780471412762
ISBN10: 0471412767
Format: Paperback
Pub. Date: 2001-11-26
Publisher(s): Wiley
List Price: $97.95

Buy New

Usually Ships in 8 - 10 Business Days.
$93.29
Add to Cart

Buy Used

Usually Ships in 24-48 Hours
$68.00
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $5.50

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Learn SQL quickly with this easy-to-use, visual tutorial Every IT professional needs at least a basic understanding of SQL. A Visual Introduction to SQL, Second Edition provides a unique tool for acquiring this knowledge. By diagramming each query, this book resolves the language' s apparent complexity into simple clarity using an intuitive visual representation. Rather than focusing on a specific vendor' s SQL dialect, the book introduces the essential core of the language, making it useful for anyone. For this new edition of their successful, long-selling book, David Chappell and J. Harvey Trimble Jr. have updated the contents to reflect SQL today. The result is a clear, step-by-step explanation of the current language, with the book' s unique visual approach guiding the way. A Visual Introduction to SQL, Second Edition is useful for all levels: For SQL beginners, the unique graphical approach makes learning this sometimes unfriendly language much easier For those,with some SQL experience, the visual approach makes clear the language' s underlying structure and helps in creating complex queries For regular SQL users, the wealth of examples in this book provides quick, easy-to-reference answers to frequently asked questions No matter what SQL version you use, A Visual Introduction to SQL, Second Edition allows you to quickly grasp both the basic and more advanced features of this important language. Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/

Author Biography

DAVID CHAPPELL is Principal of David Chappell &amp; Associates (www.davidchappell.com) in San Francisco, California. David&#146;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. <BR>

Table of Contents

Foreword vii
Preface ix
Introducing SQL
1(8)
Kinds of Database Systems
1(1)
Relational Concepts
2(3)
Tables, Rows, and Columns
2(2)
Keys
4(1)
An Example Table
5(1)
The Visual Approach
5(4)
Elements of the Language
9(14)
Ways to Use SQL
9(1)
Versions of SQL
10(1)
Defining the Language
11(6)
Data Types
11(3)
The Structure of SQL Statements
14(1)
Keywords
15(2)
An Example Database
17(4)
Organization of the Examples
21(2)
Retrieving Data from a Table: The Select Statement
23(38)
Selecting Specific Columns in a Table
23(4)
Selecting All Columns in a Table
27(3)
Selecting Only Some of a Table's Records: The Where Clause
30(1)
Comparisons in a Where Clause
30(6)
Combining Predicates in a Where Clause
36(8)
Using And
36(3)
Using Or
39(3)
Using Not
42(2)
Other Uses of Where
44(17)
Between and Not Between
44(4)
Like and Not Like
48(5)
In and Not In
53(4)
Is Null and Is Not Null
57(4)
More on Select
61(36)
Ordering Selected Data
61(6)
Doing Arithmetic with Selected Information
67(3)
Using Aggregates
70(15)
Finding Maximum and Minimum Values
70(4)
Totaling Columns
74(3)
Finding Averages
77(2)
Counting Records
79(3)
Using Distinct
82(3)
Grouping Selected Data
85(8)
More on Grouping: The Having Clause
93(4)
Retrieving Data from Several Tables: Joins
97(50)
Qualified Names
97(2)
What Is a join?
99(3)
Restricting the Results of a Join
102(2)
Query Diagrams for Joins
104(3)
Joining Tables Using the Join Operator
107(4)
Manipulating the Results of a Join
111(4)
Aliases
115(5)
Joins with Three Tables
120(12)
The Visual Approach with More Than Two Tables
120(12)
Joins with More Than Three Tables
132(8)
Retrieving the Same Information in Different Ways
132(8)
Using Group By in a join
140(7)
Queries within Queries: Subqueries
147(26)
What Is a Subquery?
147(4)
Using Comparison Operators with Subqueries
151(4)
Using ANY and ALL
155(7)
Existence Tests
162(1)
Correlated Subqueries
162(11)
Using Having with Correlated Subqueries
164(9)
Creating and Destroying Tables
173(12)
Creating a Table
173(9)
Disallowing Null Values
175(1)
Requiring Unique Values in a Column
175(7)
Destroying (Dropping) Tables
182(3)
Adding, Modifying, and Deleting Records
185(20)
Adding Records to a Table
185(15)
Adding Records with Values Only for Some Columns
187(3)
Adding Records Using Select
190(3)
Modifying Records in a Table
193(7)
Deleting Records from a Table
200(5)
Views
205(24)
Creating Views
205(9)
Creating Views Based on One Table
206(5)
Creating Views Based on More Than One Table
211(3)
Queries Using Views
214(12)
Selecting Records from a View
214(5)
Adding Records to a View
219(3)
Modifying Records in a View
222(2)
Deleting Records from a View
224(2)
Destroying (Dropping) Views
226(3)
Granting and Revoking Privileges
229(20)
Granting Privileges
229(14)
Granting Privileges on Views
231(9)
Passing Privileges On: The Grant Option
240(3)
Revoking Privileges
243(6)
Advanced Topics
249(28)
Indexes
249(4)
Creating Indexes
250(2)
When to Create Indexes
252(1)
Destroying Indexes
253(1)
Using Multiple SQL Statements to Solve a Problem
253(12)
Outer Joins
265(6)
Unions
271(2)
Joining a Table with Itself
273(3)
Final Thoughts
276(1)
Appendix A The Example Database 277(2)
Appendix B List of Examples 279(4)
Appendix C The Example Database 283(2)
Index 285

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.