9780470557419

SQL For Dummies

by
  • ISBN13:

    9780470557419

  • ISBN10:

    0470557419

  • Edition: 7th
  • Format: Paperback
  • Copyright: 2/2/2010
  • Publisher: For Dummies
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $29.99

Summary

Demystify database management systems with this fun and friendly guide to SQL

The secret is SQL, and once you get the hang of that, you can build relational databases and get valuable information into and out of them with ease. Here's how to structure a database management system with SQL, implement the design, protect your data, access and work with it, maintain your database, and much more, using the newest version of SQL.

-Down to data basics learn what a relational database is and what goes into designing a good one

-SQL secrets revealed get an overview of SQL fundamentals and actually build a database

-Data in, data out find out how to add, retrieve, display, delete, or change data in your database

-What's your query? discover how to find what you need using different queries

-Guarding your stuff protect your data from theft, accidental or malicious corruption, and loss due to equipment failure

-Getting SQL to play nice use Open DataBase Connectivity (ODBC) to solve the problems of combining SQL with other languages

-XML is your friend communicate with other applications using XML with SQL

-Eliminating errors understand what SQL is trying to tell you when something goes wrong

Open the book and find:

-Essential database design considerations

-How a database management system differs from a database

-What SQL is and isn't

-Different types of data

-Ten common database blunders

-How to use values, value expressions, and relational operators

-Tips on using XML data with SQL

-Common threats to your data

Learn to:

-Create relational databases with powerful data retrieval capacity

-Use SQL with XML and Access® 2010

-Structure a database management system and implement database design

-Work with all the core SQL features

Learn SQL the fun and easy way no programming experience needed!

SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008.

The latest update of the perennial bestselling SQL For Dummies, which has sold more than 210,000 units in six editions.

SQL is the most popular database language in the world

Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL.

Includes new content on using SQL with XML to power data-driven web sites and using SQL with Access 2010

Whether you're daunted by database development or a system admin star, SQL For Dummies, 7th Dummies will have you working your web site in no time at all.

Author Biography

Allen G. Taylor is a nationally known lecturer and educator in the field of database development. A 30-year veteran of the computer industry, he has written more than 20 books. Through the magic of the Internet, Allen teaches computer architecture both at Portland State University and in Shanghai.

Table of Contents

Introduction.

Part I: Basic Concepts.

Chapter 1: Relational Database Fundamentals.

Chapter 2: SQL Fundamentals.

Chapter 3: The Components of SQL.

Part II: Using SQL to Build Databases.

Chapter 4: Building and Maintaining a Simple Database Structure.

Chapter 5: Building a Multitable Relational Database.

Part III: Storing and Retrieving Data.

Chapter 6: Manipulating Database Data.

Chapter 7: Specifying Values.

Chapter 8: Using Advanced SQL Value Expressions.

Chapter 9: Zeroing In on the Data You Want.

Chapter 10: Using Relational Operators.

Chapter 11: Delving Deep with Nested Queries.

Chapter 12: Recursive Queries.

Part IV: Controlling Operations.

Chapter 13: Providing Database Security.

Chapter 14: Protecting Data.

Chapter 15: Using SQL within Applications.

Part V: Taking SQL to the Real World.

Chapter 16: Accessing Data with ODBC and JDBC.

Chapter 17: Operating on XML Data with SQL.

Part VI: Advanced Topics.

Chapter 18: Stepping through a Dataset with Cursors.

Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules.

Chapter 20: Handling Errors.

Chapter 21: Triggers.

Part VII: The Part of Tens.

Chapter 22: Ten Common Mistakes.

Chapter 23: Ten Retrieval Tips.

Appendix: SQL:2008 Reserved Words.

Index.

Rewards Program

Customer Reviews

Great Service. June 6, 2011
by
This is a truly excellent textbook. It quickly gets into the fundamentals of SQL itself. This textbook covers the core features of the SQL language. I've read several other textbooks on the subject now and I think it compares favorably with most. I received this cheap textbook within days. Seller was good, I give my highest recommendation.
Flag Review
Please provide a brief explanation for why you are flagging this review:
Submit
Your submission has been received. We will inspect this review as soon as possible. Thank you for your input!
SQL For Dummies: 5 out of 5 stars based on 1 user reviews.

Write a Review