SQL For Dummies® - Softcover

Taylor, Allen G.

Softcover

ISBN 10: 0764504150 ISBN 13: 9780764504150

Publisher: John Wiley & Sons, 1998

Synopsis

Become your own database guru and master the art and craft of SQL (structured query language) to access, manage, and manipulate data in a variety of relational database software programs. Get the inside tour of the major components of SQL with a copy of SQL For Dummies, 3rd Edition, by programming pro Allen Taylor. Whether you′re seeking a friendly summary of basic SQL commands and statements –– or you′re looking for advanced advice on database security, error handling, nested queries, ODBC, and dynamic SQL –– you′ll find what you need in this book′s easy–to–follow steps and examples, all written in clear, concise language. Invoke the power of SQL without headaches and hassles as you progress from relational database fundamentals to building your own databases, retrieving data, controlling operations, and transferring data across a company intranet or the worldwide Internet.

SQL For Dummies, 3rd Edition, also includes a glossary of important terms and three appendixes that cover reserved words in SQL–92, multilevel SQL subsets, and SQL implementation in Microsoft SQL Server 7.0. And, of course, this handy SQL reference includes the popular Part of Tens, where you can get the high–end lowdown on what to do, and what not to do, in designing, building, and using a relational database.

About this title

About the Author

About the Author Allen G. Taylor, a 30–year computer veteran, has written ten books and numerous articles on database topics. He is a visiting assistant professor of computer science at Lewis and Clark College in Portland, or, and is a frequent speaker on computer–industry issues at national conferences.

From the Back Cover

"Taylor writes in a breezy, entertaining style that SQL novices will find inviting." Amazon.com

Covers Microsoft SQL Server 7

Find Out How to Use SQL for Effective Database Communication Handle SQL like a native speaker in no time! Written by a 30–year computer veteran, SQL For Dummies^®, 3rd Edition, explains how to use this powerful language to create, manipulate, and manage relational databases. Get an insider's tour of relational databases and client–server systems, work your way up to sophisticated commands and statements, and check out the coverage of SQL–related products such as Microsoft SQL Server 7.

Inside, find helpful advice on how to:

• Find out about SQL components Data Definition Language, Data Manipulation Language, and Data Control Language
• Understand fundamental SQL commands and data types
• Extract data from many different data sources using ODBC (Open DataBase Connectivity)
• Create tables, views, schemas, and indices for easy data access
• Manage databases using SQL server
• Use SQL to transfer or retrieve information from the Internet or an intranet
• Enhance databases with popular development tools, such as Borland's C++Builder and IntraBuilder

Edition details

• Publisher: John Wiley & Sons
• Publication date: 1998
• Language: English
• ISBN 10: 0764504150
• ISBN 13: 9780764504150
• Binding: Paperback
• Edition number: 3
• Number of pages: 408