SQL, Third Edition (Visual QuickStart Guide Series) / Edition 3

Paperback (Print)
Rent
Rent from BN.com
$11.20
(Save 75%)
Est. Return Date: 11/01/2014
Used and New from Other Sellers
Used and New from Other Sellers
from $16.36
Usually ships in 1-2 business days
(Save 63%)
Other sellers (Paperback)
  • All (8) from $16.36   
  • New (4) from $28.84   
  • Used (4) from $16.36   

Overview

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.
Read More Show Less

Product Details

  • ISBN-13: 9780321553577
  • Publisher: Peachpit Press
  • Publication date: 6/13/2008
  • Series: Visual QuickStart Guide Series
  • Edition description: Third Edition
  • Edition number: 3
  • Pages: 483
  • Sales rank: 307,140
  • Product dimensions: 6.94 (w) x 8.92 (h) x 1.01 (d)

Meet the Author

Chris Fehily is a writer and consultant living in San Francisco.
Read More Show Less

Table of Contents


Introduction     xi
About SQL     xii
About This Book     xvi
What You'll Need     xx
DBMS Specifics     1
Running SQL Programs     2
Microsoft Access     5
Microsoft SQL Server     10
Oracle     17
IBM DB2     20
MySQL     27
PostgreSQL     30
The Relational Model     33
Tables, Columns, and Rows     34
Primary Keys     38
Foreign Keys     40
Relationships     42
Normalization     45
The Sample Database     51
Creating the Sample Database     57
SQL Basics     61
SQL Syntax     62
SQL Standards and Conformance     65
Identifiers     66
Data Types     68
Character String Types     70
Binary Large Object Type     72
Exact Numeric Types     73
Approximate Numeric Types     75
Boolean Type     76
Datetime Types     77
Interval Types     80
Unique Identifiers     82
Other DataTypes     83
Nulls     84
Retrieving Data from a Table     87
Retrieving Columns with SELECT and FROM     88
Creating Column Aliases with AS     91
Eliminating Duplicate Rows with DISTINCT     93
Sorting Rows with ORDER BY     95
Filtering Rows with WHERE     101
Combining and Negating Conditions with AND, OR, and NOT     105
Matching Patterns with LIKE     114
Range Filtering with BETWEEN     118
List Filtering with IN     121
Testing for Nulls with IS NULL     124
Operators and Functions     127
Creating Derived Columns     128
Performing Arithmetic Operations     130
Determining the Order of Evaluation     133
Concatenating Strings with [double vertical line]     134
Extracting a Substring with SUBSTRING()     137
Changing String Case with UPPER() and LOWER()     140
Trimming Characters with TRIM()     142
Finding the Length of a String with CHARACTER_LENGTH()     147
Finding Substrings with POSITION()     149
Performing Datetime and Interval Arithmetic     152
Getting the Current Date and Time      154
Getting User Information     156
Converting Data Types with CAST()     157
Evaluating Conditional Values with CASE     161
Checking for Nulls with COALESCE()     165
Comparing Expressions with NULLIF()     166
Summarizing and Grouping Data     169
Using Aggregate Functions     170
Creating Aggregate Expressions     171
Finding a Minimum with MIN()     172
Finding a Maximum with MAX()     173
Calculating a Sum with SUM()     174
Calculating an Average with AVG()     175
Counting Rows with COUNT()     178
Aggregating Distinct Values with DISTINCT     179
Grouping Rows with GROUP BY     183
Filtering Groups with HAVING     190
Joins     193
Qualifying Column Names     194
Creating Table Aliases with AS     196
Using Joins     198
Creating Joins with Join or WHERE     200
Creating a Cross Join with CROSS JOIN     204
Creating a Natural Join with NATURAL JOIN     206
Creating an Inner Join with INNER JOIN     210
Creating Outer Joins with OUTER JOIN     235
Creating a Self-Join      247
Subqueries     253
Understanding Subqueries     254
Subquery Syntax     256
Subqueries vs. Joins     257
Simple and Correlated Subqueries     262
Qualifying Column Names in Subqueries     267
Nulls in Subqueries     268
Using Subqueries as Column Expressions     270
Comparing a Subquery Value by Using a Comparison Operator     275
Testing Set Membership with IN     281
Comparing All Subquery Values with ALL     288
Comparing Some Subquery Values with ANY     291
Testing Existence with EXISTS     294
Comparing Equivalent Queries     301
Set Operations     303
Combining Rows with UNION     304
Finding Common Rows with INTERSECT     310
Finding Different Rows with EXCEPT     312
Inserting, Updating, and Deleting Rows     315
Displaying Table Definitions     316
Inserting Rows with INSERT     319
Updating Rows with UPDATE     327
Deleting Rows with DELETE     333
Creating, Altering, and Dropping Tables     337
Creating Tables     338
Understanding Constraints     339
Creating a New Table with CREATE TABLE     341
Forbidding Nulls with NOT NULL     343
Specifying a Default Value with DEFAULT     346
Specifying a Primary Key with PRIMARY KEY     350
Specifying a Foreign Key with FOREIGN KEY     353
Forcing Unique Values with UNIQUE     359
Adding a Check Constraint with CHECK     363
Creating a Temporary Table with CREATE TEMPORARY TABLE     366
Creating a New Table from an Existing One with CREATE TABLE AS     369
Altering a Table with ALTER TABLE     373
Dropping a Table with DROP TABLE     376
Indexes     377
Creating an Index with CREATE INDEX     378
Dropping an Index with DROP INDEX     383
Views     385
Creating a View with CREATE VIEW     386
Retrieving Data Through a View     391
Updating Data Through a View     394
Dropping a View with DROP VIEW     398
Transactions     399
Executing a Transaction     400
SQL Tricks     405
Calculating Running Statistics     406
Generating Sequences     409
Finding Sequences, Runs, and Regions     415
Limiting the Number of Rows Returned      421
Assigning Ranks     430
Calculating a Trimmed Mean     432
Picking Random Rows     433
Handling Duplicates     435
Creating a Telephone List     438
Retrieving Metadata     439
Working with Dates     445
Calculating a Median     451
Finding Extreme Values     453
Changing Running Statistics Midstream     454
Pivoting Results     456
Working with Hierarchies     458
Index     465
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted June 21, 2013

    more from this reviewer

    A great learning and reference tool

    Over the years I've used various books from the Visual QuickStart series, HTML, XML, JavaScript, VBScript, etc. to compliment training material provided by the various companies I've worked for over the years. Each book from the Visual QuickStart series is organized in a way as to build successively from basic to advanced concept, and within each chapter to build on a specific area drilling down through the topic providing an overview, a coding example and it's output, and usage tips. The end result is a great book for learning, and a great reference tool.

    The Visual QuickStart Guide for SQL is no exception to the this tried and true concept. During my "development days" in IT, I've spent a lot of time developing SQL for DB2 in COBOL programs, and later in the various iterations of MS Access, but as my career migrated away from development into more complex world of business analysis and project management those skills became rusty. Rather than acquire one of those 1,200-page "everything you ever wanted to know about SQL" texts or something from the "idiot's" or "dummies" series (which can be useful if you know nothing about the topic), I opted for a format that I was confortable with and trusted, and since my current assignment requires me to employ skills which were once common for me, I've returned to a format that has served me well in the past. SQL, third edition, not only stays true to the Visual QuickStart organization that I've found useful and productive during my career, but provides the quick and easy access to the topics I need to refresh my memory after a considerable absence from the development arts. While I've only had the book a couple of weeks, it has begun to deliver benefits in analyzing the data in several of the legacy DB2 tables with which I'm currently working.

    In closing, SQL, third edition, covers all of the major SQL proprietary variations, provides a good introduction, albeit brief, to relational database concepts, and proceeds to cover basic to advanced SQL coding and formatting specifics. I would recommend SQL, third edition, to both novice and experienced users as both a learning aid and a desk reference. And I would recommend the Visual QuickStart series as an excellent place to start when learning a new development skill; I've found this series quite useful over the course of my career, and have recommended the series to many of my colleagues.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)