SQL Queries for Mere Mortals A Hands-On Guide to Data Manipulation in SQL

ISBN-10: 0321444434
ISBN-13: 9780321444431
Edition: 2nd 2008
List price: $74.99
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: Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

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.

Add to cart
Study Briefs
History of Western Art Online content $4.95 $1.99
Add to cart
Study Briefs
History of World Philosophies Online content $4.95 $1.99
Add to cart
Study Briefs
American History Volume 1 Online content $4.95 $1.99
Add to cart
Study Briefs
History of Western Music Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $74.99
Edition: 2nd
Copyright year: 2008
Publisher: Addison Wesley Professional
Publication date: 9/24/2007
Binding: Mixed Media
Pages: 672
Size: 7.25" wide x 9.50" long x 1.25" tall
Weight: 2.2
Language: English

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL.SQL Queries for Mere Mortalswill help new users learn the foundations of SQL queries, and will prove to be an essential reference guide for intermediate and advanced users. The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is a Microsoft MVP and the author of several popular books, including Microsoft� Office Access� 2003 Inside Out and Building Microsoft� Access� Applications.

Foreword
Preface
About the Authors
Introduction
Are You a Mere Mortal?
About This Book
What This Book Is Not
How to Use This Book
Reading the Diagrams Used in This Book
Sample Databases Used in This Book
"Follow the Yellow Brick Road"
Relational Databases and SQL
What Is Relational?
Topics Covered in This Chapter
Types of Databases
A Brief History of the Relational Model
Anatomy of a Relational Database
What's in It for You?
Where Do You Go from Here?
Summary
Ensuring Your Database Structure Is Sound
Topics Covered in This Chapter
Why Is This Chapter Here?
Why Worry about Sound Structures?
Fine-Tuning Fields
Fine-Tuning Tables
Establishing Solid Relationships
Is That All?
Summary
A Concise History of SQL
Topics Covered in This Chapter
The Origins of SQL
Early Vendor Implementations
". . . And Then There Was a Standard"
Evolution of the ANSI/ISO Standard
Commercial Implementations
What the Future Holds
Why Should You Learn SQL?
Summary
SQL Basics
Creating a Simple Query
Topics Covered in This Chapter
Introducing SELECT
The SELECT Statement
A Quick Aside: Data versus Information
Translating Your Request into SQL
Eliminating Duplicate Rows
Sorting Information
Saving Your Work
Sample Statements
Summary
Problems for You to Solve
Getting More Than Simple Columns
Topics Covered in This Chapter
What Is an Expression?
What Type of Data Are You Trying to Express?
Changing Data Types: The CAST Function
Specifying Explicit Values
Types of Expressions
Using Expressions in a SELECT Clause
That "Nothing" Value: Null
Sample Statements
Summary
Problems for You to Solve
Filtering Your Data
Topics Covered in This Chapter
Refining What You See Using WHERE
Defining Search Conditions
Using Multiple Conditions
Nulls Revisited: A Cautionary Note
Expressing Conditions in Different Ways
Sample Statements
Summary
Problems for You to Solve
Working with Multiple Tables
Thinking in Sets
Topics Covered in This Chapter
What Is a Set, Anyway?
Operations on Sets
Intersection
Difference
Union
SQL Set Operations
Summary
Inner Joins
Topics Covered in This Chapter
What Is a JOIN?
The Inner Join
Uses for Inner Joins
Sample Statements
Summary
Problems for You to Solve
Outer Joins
Topics Covered in This Chapter
What Is an Outer Join?
The Left/Right Outer Join
The Full Outer Join
Uses for Outer Joins
Sample Statements
Summary
Problems for You to Solve
Unions
Topics Covered in This Chapter
What Is a Union?
Writing Requests with Union
Uses for Union
Sample Statements
Summary
Problems for You to Solve
Subqueries
Topics Covered in This Chapter
What Is a Subquery?
Subqueries as Column Expressions
Subqueries as Filters
Uses for Subqueries
Sample Statements 394 Summary
Problems for You to Solve
Summarizing and Grouping Data
Simple Totals
Topics Cover

×
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.

×