SQL For Dummies, 7th Edition
By Allen G. Taylor
Publisher: Wiley / For Dummies
Final Release Date: January 2010
Pages: 456

Demystify database management systems with this fun and friendlyguide to SQL

The secret is SQL, and once you get the hang of that, you canbuild relational databases and get valuable information into andout of them with ease. Here's how to structure a databasemanagement system with SQL, implement the design, protect yourdata, access and work with it, maintain your database, and muchmore, using the newest version of SQL.

  • Down to data basics — learn what a relational database isand what goes into designing a good one

  • SQL secrets revealed — get an overview of SQL fundamentalsand 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 needusing different queries

  • Guarding your stuff — protect your data from theft,accidental or malicious corruption, and loss due to equipmentfailure

  • Getting SQL to play nice — use Open DataBase Connectivity(ODBC) to solve the problems of combining SQL with otherlanguages

  • XML is your friend — communicate with other applicationsusing XML with SQL

  • Eliminating errors — understand what SQL is trying to tellyou 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 relationaloperators

  • Tips on using XML data with SQL

  • Common threats to your data

Learn to:

  • Create relational databases with powerful data retrievalcapacity

  • Use SQL with XML and Access® 2010

  • Structure a database management system and implement databasedesign

  • Work with all the core SQL features

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $29.99
Formats:  ePub, Mobi, PDF