SQL For Dummies - Softcover

Taylor, Allen G.

Softcover

ISBN 10: 0764504150 ISBN 13: 9780764504150

Publisher: For Dummies, 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

Review

This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. Some sections show several screen shots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some readers from the technical content.

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: For Dummies
• Publication date: 1998
• ISBN 10: 0764504150
• ISBN 13: 9780764504150
• Binding: Paperback
• Language: English
• Edition number: 3
• Number of pages: 408