SQL For Dummies
6th Edition
Published on 11. August 2006
Book
Paperback/Softback
432 pages
978-0-470-04652-4 (ISBN)
Description
See how SQL interfaces with today's environments
Start building and using relational databases with SQL's newest features
The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!
Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML
Start building and using relational databases with SQL's newest features
The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!
Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML
More details
Edition
6., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Edition type
Revised edition
Illustrations
Illustrations
Dimensions
Height: 23.3 cm
Width: 19 cm
Thickness: 24 mm
Weight
644 gr
ISBN-13
978-0-470-04652-4 (9780470046524)
Schweitzer Classification
Other editions
New editions
Allen G. Taylor
SQL For Dummies
Book
01/2010
7th Edition
Wiley
€28.90
Article exhausted; check for reprint
Previous edition
Allen G. Taylor
SQL For Dummies
Book
08/2003
5th Edition
Hungry Minds Inc,U.S.
€27.90
Article exhausted; check for reprint
Person
Allen G. Taylor is a 30-year veteran of the computer industry. He teaches database development internationally through a leading online education provider and has written more than 20 books.
Content
Introduction. Part I: Basic Concepts. Chapter 1: Relational Database Fundamentals. Chapter 2: SQL Fundamentals. Chapter 3: The Components of SQL. Part II: Using SQL to Build Databases. Chapter 4: Building and Maintaining a Simple Database Structure. Chapter 5: Building a Multitable Relational Database. Part III: Storing and Retrieving Data. Chapter 6: Manipulating Database Data. Chapter 7: Specifying Values. Chapter 8: Using Advanced SQL Value Expressions. Chapter 9: Zeroing In on the Data You Want. Chapter 10: Using Relational Operators. Chapter 11: Delving Deep with Nested Queries. Chapter 12: Recursive Queries. Part IV: Controlling Operations. Chapter 13: Providing Database Security. Chapter 14: Protecting Data. Chapter 15: Using SQL within Applications. Part V: Taking SQL to the Real World. Chapter 16: Accessing Data with ODBC and JDBC. Chapter 17: Operating on XML Data with SQL. Part VI: Advanced Topics. Chapter 18: Stepping through a Dataset with Cursors. Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules. Chapter 20: Handling Errors. Part VII: The Part of Tens. Chapter 21: Ten Common Mistakes. Chapter 22: Ten Retrieval Tips. Part VIII: Appendixes. Appendix A: SQL:2003 Reserved Words. Appendix B: Glossary. Index.