SQL For Dummies

SQL For Dummies

3.46 (157 ratings by Goodreads)
  • Electronic book text
By (author) 

List price: US$16.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

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 fundamentalsBuilding and maintaining a simple database structureBuilding a multiple relational databaseManipulating database dataExamining SQL nuts and bolts: values, expressions, operators, and queriesProviding database security and protecting your dataExploring ODBC and JDBC, and using SQL with XMLMoving beyond the basics: cursors, persistent stored modules, and error-handlingTop Ten lists on common SQL mistakes and retrieval tipsPlain 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.show more

Product details

  • Electronic book text | 432 pages
  • John Wiley & Sons Inc
  • FOR DUMMIES
  • United States
  • Revised
  • 5th Revised edition
  • 9780764544873

About Allen G. Taylor

Allen G. Taylor is a database instructor who has written 20 computer books. He operates a Web development company and is much in demand as a speaker.show more

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: Retrieving Data. Chapter 6: Manipulating Database Data. Chapter 7: Specifying Values. Chapter 8: Advanced SQL Value Expressions. Chapter 9: Zeroing In on the Data You Want. Chapter 10: Relational Operators. Chapter 11: Delving Deep with Nested Queries. Chapter 12: Recursive Queries. Chapter 13: Providing Database Security. Part IV: Controlling Operations. Chapter 14: Protecting Data. Chapter 15: Using SQL Within Applications. Part V: SQL in the Real World. Chapter 16: ODBC and JDBC. Chapter 17: SQL:2003 and XML. Part VI: Advanced Topics. Chapter 18: Cursors. Chapter 19: Persistent Stored Modules. Chapter 20: Error-Handling. Part VII: The Part of Tens. Chapter 21: Ten Common Mistakes. Chapter 22: Ten Retrieval Tips. Part VIII: Appendixes. Appendix A: SQL:2003 Reserved Words. Appendix B: Glossary. Index.show more

Rating details

157 ratings
3.46 out of 5 stars
5 15% (23)
4 32% (51)
3 41% (64)
2 9% (14)
1 3% (5)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X