SQL has become the standard language for accessing information in relational databases. It is becoming increasingly important as a means of enabling personal computer users to use data stored on mainframes and workstations through client/server networks. This book guides readers step-by-step through the basic vocabulary and functions of the language and describes how to use it to develop applications. It covers the fundamentals of database design, security and data integrity. This updated second edition also includes two chapters specifically on implementing SQL in the workplace. These chapters contain explicit solutions, ready-to-use code and general strategies for common business database challenges.
"synopsis" may belong to another edition of this title.
The Practical SQL Handbook explains Structured Query Language (SQL) simply, without being condescending and deeply without being obscure. From its early chapters about relational database theory to its superb coverage of transaction management, this book is informative and easy to follow.
The authors begin by explaining how to design efficient data structures, an important part of database management. From there, they discuss how to populate a database with pieces of data and then explain how to construct queries that extract needed information. Throughout, the text is filled with statements, code and output--and even common SQL errors. You ought to be able to follow along on any ANSI SQL 92-compliant system as you read this book.
Later chapters cover reports, joins, views, subqueries and security. The authors explain each from a practical point of view, as demonstrated by a section on common database tasks (how to specify decimal precision, for example). A good glossary exists in the back of this book, and a comprehensive table documents the differences among Sybase, Microsoft, Informix and Oracle SQL command sets. The companion CD-ROM contains the Sybase SQL Anywhere Studio software, which ordinarily requires a 15-MB download marathon. --David Wall
The best selling guide to learning SQL
The Practical SQL Handbook is the best-selling guide to learning SQL, the standard language for accessing information in relational databases. This book not only teaches SQL as it has been established by ANSI standards committees but also as the language is used to solve real business problems.
You'll learn step-by-step the basic vocabulary and functions of the language and the processes and issues involved in developing robust applications. This book provides a thorough grounding in the basics of database design, security, and integrity. You will learn SQL pragmatically, by creating a sample database and then working through dozens of examples with it.
Fully updated to cover the ANSI SQL '92 standard, the third edition of The Practical SQL Handbook includes a cookbook of specific solutions, ready-to-use code, and general strategies for common business database challenges.
"About this title" may belong to another edition of this title.
£ 6.16 shipping from U.S.A. to United Kingdom
Destination, rates & speedsSeller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. 2nd. Used book that is in clean, average condition without any missing pages. Seller Inventory # 4309110-75
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.8. Seller Inventory # G0201626233I3N00
Quantity: 1 available
Seller: BookHolders, Towson, MD, U.S.A.
Condition: Good. [ No Hassle 30 Day Returns ][ Ships Daily ] [ Underlining/Highlighting: NONE ] [ Writing: NONE ] [ Edition: second ] Publisher: Addison-Wesley (C) Pub Date: 11/1/1993 Binding: Paperback Pages: 496 second edition. Seller Inventory # 6653129
Quantity: 1 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00077617827
Quantity: 1 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00077638785
Quantity: 1 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Acceptable. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00077523745
Quantity: 1 available
Seller: HPB-Red, Dallas, TX, U.S.A.
paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_424884029
Quantity: 1 available