Visual Introduction to SQL

ISBN-10: 0471412767

ISBN-13: 9780471412762

Edition: 2nd 2002 (Revised)

List price: $85.00 Buy it from $21.68
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

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.
New Starting from $87.80
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $85.00
Edition: 2nd
Copyright year: 2002
Publisher: John Wiley & Sons, Incorporated
Publication date: 11/26/2001
Binding: Paperback
Pages: 304
Size: 7.50" wide x 9.25" long x 0.75" tall
Weight: 1.430
Language: English

Foreword
Preface
Introducing SQL
Kinds of Database Systems
Relational Concepts
Tables, Rows, and Columns
Keys
An Example Table
The Visual Approach
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
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
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
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
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
Creating and Destroying Tables
Creating a Table
Disallowing NULL Values
Requiring Unique Values in a Column
Destroying (Dropping) Tables
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
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
Granting and Revoking Privileges
Granting Privileges
Granting Privileges on Views
Passing Privileges On: The GRANT Option
Revoking Privileges
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
The Example Database
List of Examples
The Example Database
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×