Sql For Dummies

Preparing link to download Please wait... Download

E-Book Overview

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 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.

E-Book Content

SQL ® FOR DUMmIES ‰ 5TH EDITION by Allen G. Taylor SQL ® FOR DUMmIES ‰ 5TH EDITION by Allen G. Taylor SQL For Dummies ®, 5th Edition Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030 www.wiley.com Copyright © 2003 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate licensing fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8700. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, e-mail: permcoord [email protected] Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com and related trade dress are trademarks or registered trademarks of Wiley Publishing, Inc., in the United States and other countries, and may not be used without written permission All other trademarks are the property of their respective owners. Wiley Publishing, Inc.,