SQL For Dummies - Softcover

Taylor, Allen G.

Softcover

ISBN 10: 0764540750 ISBN 13: 9780764540752

Publisher: For Dummies, 2003

Synopsis

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them.

Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities – the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique.

Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value in SQL For Dummies, 5th Edition; even if you have some experience designing and creating databases, you may discover a few things you didn't know about.

Here's just a sampling of some of the things you'll find covered in SQL For Dummies, 5th Edition:

• Exploring relational database and SQL fundamentals
• Building and maintaining a simple database structure
• Building a multiple relational database
• Manipulating database data
• Examining SQL nuts and bolts: values, expressions, operators, and queries
• Providing database security and protecting your data
• Exploring ODBC and JDBC, and using SQL with XML
• Moving beyond the basics: cursors, persistent stored modules, and error-handling
• Top Ten lists on common SQL mistakes and retrieval tips

Plain and simply, databases are the best tools ever invented for keeping track of the things you care about. After you understand databases and can use SQL to make them do your bidding, you wield tremendous power. SQL For Dummies, 5th Edition, can get you well on your way to harnessing the power of databases.

About this title

About the Author

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, Second Edition. He lectures internationally on astronomy, databases, innovation, and entrepreneurship. He also teaches database development and Crystal Reports through a leading online education. For the latest news on Allen's activities, check out DatabaseCentral.Info or his blog at moontube.wordpress.com.

From the Back Cover

Discover how SQL:2003 handles images, XML files, and more

Use SQL to build databases, keep them safe, and access their information

Relationships are everything, especially when it comes to databases – so if you work with them, form a relationship with this book. It helps you use SQL to build databases, protect them from corruption, store and retrieve what you need, handle nonrelational data, and even swap information with nondatabase applications using XML.

The Dummies Way

• Explanations in plain English
• "Get in, get out" information
• Icons and other navigational aids
• Tear-out cheat sheet
• Top ten lists
• A dash of humor and fun

Edition details

• Publisher: For Dummies
• Publication date: 2003
• ISBN 10: 0764540750
• ISBN 13: 9780764540752
• Binding: Paperback
• Language: English
• Edition number: 5
• Number of pages: 432