Picture 1 of 1
Picture 1 of 1
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation - GOOD
US $3.86
Condition:
Shipping:
Located in: Montgomery, Illinois, United States
Delivery:
Estimated between Mon, Jul 1 and Sat, Jul 6 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:266830872832
Item specifics
- Condition
- Brand
- Unbranded
- Book Title
- SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipu
- MPN
- Does not apply
- ISBN
- 9780201433364
- Subject Area
- Computers
- Publication Name
- Sql Queries for Mere Mortals : a Hands-On Guide to Data Manipulation in Sql
- Publisher
- Addison Wesley Professional
- Item Length
- 9.3 in
- Subject
- Programming Languages / Sql, Databases / General
- Publication Year
- 2000
- Series
- For Mere Mortals Ser.
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.1 in
- Item Weight
- 27.4 Oz
- Item Width
- 7.1 in
- Number of Pages
- 528 Pages
About this product
Product Information
Now there's a practical, hands-on guide to SQL for millions of beginning-to-intermediate database users who desperately need to create fast, accurate, effective queries -- whether they have formal database training or not. The authors begin by introducing the fundamental concepts underlying relational databases and SQL. They then introduce the absolute basics of SQL, including the SELECT statement, creating expressions, and applying filters. Next, they introduce techniques for solving one of the most common problems database users encounter: drawing data from multiple tables at once. The book includes detailed coverage of grouping, totaling, and summarizing data; using SQL to update, insert, and delete data; and more. In the final section, Hernandez and Viescas introduce "thinking out of the box" techniques that allow users to solve a wide variety of complex SQL problems. Most chapters end with sample problems, solutions, and result sets -- all based on a library of five real-world databases included on the accompanying CD-ROM.
Product Identifiers
Publisher
Addison Wesley Professional
ISBN-10
0201433362
ISBN-13
9780201433364
eBay Product ID (ePID)
1805384
Product Key Features
Number of Pages
528 Pages
Language
English
Publication Name
Sql Queries for Mere Mortals : a Hands-On Guide to Data Manipulation in Sql
Publication Year
2000
Subject
Programming Languages / Sql, Databases / General
Type
Textbook
Subject Area
Computers
Series
For Mere Mortals Ser.
Format
Trade Paperback
Dimensions
Item Height
1.1 in
Item Weight
27.4 Oz
Item Length
9.3 in
Item Width
7.1 in
Additional Product Features
LCCN
00-044749
Dewey Edition
21
Target Audience
Scholarly & Professional
Illustrated
Yes
Dewey Decimal
005.75/6
Lc Classification Number
Qa76.73.S67h48 2000
Table of Content
Foreword. Preface and Acknowledgments. About the Authors. Introduction. Are You a Mere Mortal? About This Book. How to Use This Book. Reading the Diagrams Used in This Book. Sample Databases Used in This Book. "Follow the Yellow Brick Road". I. RELATIONAL DATABASES AND SQL. 1. What Is "Relational?" Topics Covered in This Chapter. Types of Databases. A Brief History of the Relational Model. In the Beginning . . .. Relational Database Software. Anatomy of a Relational Database. Tables. Fields. Records. Keys. Views. Relationships. What's in It for Me? "Where Do I Go from Here?" 2. Ensuring Your Database Structure Is Sound. Topics Covered in This Chapter. Why Is This Chapter Here? Why Worry about Sound Structures? Fine-tuning Fields. What's in a Name? (Part One). Smoothing Out the Rough Edges. Resolving Multipart Fields. Resolving Multivalued Fields. Fine-tuning Tables. What's in a Name? (Part Two). Ensuring a Sound Structure. Resolving Unnecessary Duplicate Fields. Identification Is the Key. Establishing Solid Relationships. Establishing a Deletion Rule. Setting the TYpe of Participation. Setting the Degree of Participation. Is That All? 3. A Concise History of SQL. Topics Covered in This Chapter. The Origins of SQL. Early Vendor Implementation. ". . . And Then There Was a Standard". Evolution of the ANSI/ISO Standard. Other SQL Standards. Commercial Implementations. What the Future Holds. Why Should You Learn SQL? II. SQL BASICS. 4. Creating a Simple Query. Topics Covered in This Chapter. Introducing SELECT. The SELECT Statement. Major Clauses in a SELECT Statement. A Quick Aside: Data vs. Information. Translating Your Request into SQL. Expanding the Field of Vision. Eliminating Duplicate Rows. Sorting Information. First Things First: Collating Sequences. Let's Now Come to Order. Saving Your Work. Sample Statements. Problems for You to Solve. 5. Getting More Than Simple Columns. Topics Covered in This Chapter. The SELECT Clause: Take Two. Specifying Explicit Values. Moving Beyond Basic Information. What Is an Expression? What Are You Trying to Express? Data Types in SQL. Types of Expressions. Concatenation. Mathematical. Date And Time Arithmetic. Using Expressions in a SELECT Clause. A Brief Digression: Value Expressions. That "Nothing" Value--NULL. Introducing Null. Sample Statements. Problems for You to Solve. 6. Filtering Your Data. Topics Covered in This Chapter. Refining What You See Using WHERE. The WHERE Clause. Using A WHERE Clause. Defining Search Conditions. Comparison. Range. Set Membership. Pattern Match. Null. Excluding Rows with NOT. Using Multiple Conditions. Introducing AND and OR. <
Copyright Date
2000
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:266830872832
Shipping and handling
Item location:
Montgomery, Illinois, United States
Ships to:
Canada, Mexico, United States
Excludes:
Africa, Asia, Barbados, Bermuda, Central America and Caribbean, Europe, French Guiana, French Polynesia, Greenland, Guadeloupe, Libya, Martinique, Middle East, New Caledonia, Oceania, Reunion, Russian Federation, Saint Pierre and Miquelon, South America, Southeast Asia, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free shipping | United States | Economy Shipping (USPS Media MailTM) | Estimated between Mon, Jul 1 and Sat, Jul 6 to 43230 |
| US $4.95 | United States | Standard Shipping (DGM SmartMail Expedited) | Estimated between Fri, Jun 28 and Mon, Jul 1 to 43230 |
| US $10.95 | United States | Expedited Shipping (FedEx 2Day®) | Estimated between Thu, Jun 27 and Fri, Jun 28 to 43230 |
| Handling time |
|---|
| Will usually ship within 1 business day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales Tax for an item #266830872832
Sales Tax for an item #266830872832
Seller collects sales tax for items shipped to the following states:
| State | Sales Tax Rate |
|---|
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Popular categories from this store
Seller feedback (6,021,452)
a***a (171)- Feedback left by buyer.
Past month
Verified purchase
This is an outstanding seller to deal with. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money. Packaged and shipped well shows seller has concern for the products he sells to arrive in excellent condition. The seller is friendly and communicates timely with his customers. I highly recommend this seller and would do business again anytime. Thank you.
5***u (3417)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
z***z (603)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
Product ratings and reviews
More to explore :
- Study Study Guides Prep,
- TV Guide Magazines,
- Science Study Guides & Test Prep,
- Study Guides & Test Prep,
- Mathematics Study Study Guides Prep,
- TV Guide Magazines 1980-1999,
- Collector's Edition TV Guide Magazines,
- History Study Study Guides Prep,
- Biology Study Guides & Test Prep,
- Christianity Study Guides & Test Prep