BN.com Gift Guide

Sams Teach Yourself SQL in 21 Days

Overview

Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (1) from $59.00   
  • Used (17) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$59.00
Seller since 2014

Feedback rating:

(320)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.

Read More Show Less

Product Details

  • ISBN-13: 9780672324512
  • Publisher: Sams
  • Publication date: 10/28/2002
  • Series: Sams Teach Yourself Series
  • Edition number: 4
  • Pages: 837
  • Product dimensions: 9.18 (w) x 7.54 (h) x 1.22 (d)

Meet the Author

Ryan K. Stephens is president and CEO of Perpetual Technologies, Inc., an information technology consulting and training firm in Indianapolis, Indiana. He has specialized in Oracle databases and SQL for more than 10 years, working as an Oracle programmer/analyst and Oracle database administrator. Ryan is a Certified Oracle Professional and is also an adjunct professor at Indiana University-Purdue University in Indianapolis, where he teaches SQL, PL/SQL, UNIX, Oracle Designer, Oracle Forms, and Oracle database administration. Ryan resides in Indianapolis with his wife Tina and their children Daniel, Autumn, and Baby Stephens.

Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc. in Indianapolis, Indiana. Ron is a Certified Oracle Professional, and his duties include Oracle database consulting and training. Ron is an adjunct professor at Indiana University-Purdue University in Indianapolis, where he teaches SQL and various database courses. He holds a Bachelor of Science degree in business management/administration from Indiana Institute of Technology in Fort Wayne, Indiana. Ron also serves in the Indiana Army National Guard, where he is the programmer/analyst for the 433rd Personnel Detachment. Ron's hobbies include golf, chess, and collecting Indianapolis 500 racing memorabilia. He shares ownership of Plew's Indy 500 Museum with his brothers, Mark and Dennis; his sister, Arleen; and mother, Betty. Ron lives in Indianapolis with his wife Linda. Ron and Linda have 4 children and 10 grandchildren.

Read More Show Less

Table of Contents

Introduction 1
Week 1 At a Glance 5
Day 1 Getting Started with SQL 7
Day 2 Introducing the Query 25
Day 3 Expressions, Conditions, and Operators 39
Day 4 Molding Data with Built-in Functions 79
Day 5 Clauses in SQL Queries 129
Day 6 Joining Tables 161
Day 7 Embedding Subqueries into Queries 189
Week 2 At a Glance 217
Day 8 Database Normalization 219
Day 9 Creating and Maintaining Tables 231
Day 10 Controlling Data Integrity 255
Day 11 Manipulating Data 273
Day 12 Controlling Transactions 295
Day 13 Dates and Time in SQL 309
Day 14 Creating Views 329
Week 3 At a Glance 351
Day 15 Creating Indexes on Tables to Improve Performance 353
Day 16 Streamlining SQL Statements for Improved Performance 371
Day 17 Database Security 393
Day 18 Exploring the Data Dictionary (System Catalog) 415
Day 19 Stored Procedures, Triggers, and Embedded SQL 441
Day 20 New Objects in the Latest Standard: SQL3 467
Day 21 Using SQL to Generate SQL Statements 479
Bonus Week: At a Glance 505
Bonus Day 1 Debugging Your SQL Statements 507
Bonus Day 2 Creating Complex SQL Queries 527
Bonus Day 3 Using Oracle SQL[superscript *] Plus to Satisfy Reporting Needs 547
Bonus Day 4 An Introduction to Oracle PL/SQL 585
Bonus Day 5 An Introduction to Transact-SQL 615
Bonus Day 6 Embedding SQL in Application Programming 637
Bonus Day 7 Using MySQL on a UNIX-based System 665
App. A: Answers 679
App. B: Code Examples to Create Tables 733
App. C: Code Examples to Populate Tables 741
App. D Using MySQL for Exercises 753
App. E: Bonus Exercises 757
App. F: Glossary of Common SQL Commands 763
App. G ASCII Table 771
App. H: Resources 777
Index 781
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

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

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