SQL For Dummies
Tags:For Dummies, SQL; 902 views ; Comments: No Responses
SQL For Dummies
by Allen G. Taylor
- Paperback: 432 pages
- Publisher: For Dummies; 6 edition (August 14, 2006)
- Language: English
- ISBN-10: 047004652X
- ISBN-13: 978-0470046524
Book 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
Table of Contents
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.
About the Author
Allen G. Taylor is a 30-year veteran of the computer industry and the author of 24 books, including Crystal Reports 10 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL Weekend Crash Course. He lectures internationally on databases, networks, innovation, and entrepreneurship. He also teaches database development through a leading online education provider and teaches digital electronics and computer architecture at Portland State University. He teaches computer hardware via distance learning at the International Institute for Information Science & Technology in Shanghai, China. For the latest news on Allen?? activities, check out www.DatabaseCentral.Info. You can contact Allen at allen.taylor@ieee.org.
Popularity: 17% [?]
Related eBooks - Up | Down
Oracle DBA SQL Quick Reference...
Oracle DBA SQL Quick Reference by Charlie Russel (Author) # Paperback: 560 pages # Publisher: Prentice Hall PTR (June 26, 2003) # Language: English # ISBN-10: 0131403036 # ISBN-13: 978-0131403031 Product DescriptionDownload
(1 votes, average: 5.00 out of 5)
Loading ...Tags:DBA, Oracle, SQL; 8 views ; Comments: No Responses
Red Hat Enterprise Linux 4 For Dummies...
Red Hat Enterprise Linux 4 For Dummies by Terry Collings # Paperback: 408 pages # Publisher: For Dummies (April 15, 2005) # Language: English # ISBN-10: 0764577131 # ISBN-13: 978-0764577130 Product DescriptionDownload
(1 votes, average: 3.00 out of 5) Loading ...Tags:For Dummies, linux, Red-Hat; 52 views ; Comments: One Response
Ajax For Dummies...
Ajax For Dummies by Steve Holzner Ph.D. (Author) # Paperback: 384 pages # Publisher: For Dummies (March 13, 2006) # Language: English # ISBN-10: 0471785970 # ISBN-13: 978-0471785972 Product DescriptionDownload
(1 votes, average: 4.00 out of 5) Loading ...Tags:AJAX, For Dummies; 466 views ; Comments: No Responses
YouTube For Dummies...
YouTube For Dummies by Doug Sahlin (Author), Chris Botello (Author) # Paperback: 408 pages # Publisher: For Dummies (July 30, 2007) # Language: English # ISBN-10: 0470149256 # ISBN-13: 978-0470149256 Book DescriptionDownload
(1 votes, average: 4.00 out of 5) Loading ...Tags:For Dummies, YouTube; 19 views ; Comments: No Responses
AutoCAD 2005 For Dummies...
AutoCAD 2005 For Dummies by Mark Middlebrook (Author) # Paperback: 432 pages # Publisher: For Dummies (May 14, 2004) # Language: English # ISBN-10: 0764571389 # ISBN-13: 978-0764571381 Product DescriptionDownload
(No Ratings Yet) Loading ...Tags:AutoCAD, For Dummies; 571 views ; Comments: No Responses
AutoCAD 2004 for Dummies...
AutoCAD 2004 for Dummies by Mark Middlebrook (Author) # Paperback: 408 pages # Publisher: For Dummies (May 2, 2003) # Language: English # ISBN-10: 0764540459 # ISBN-13: 978-0764540455 Product DescriptionDownload
(1 votes, average: 3.00 out of 5) Loading ...Tags:AutoCAD, For Dummies; 57 views ; Comments: No Responses
AutoCAD 2008 3D Modeling Workbook For Du...
AutoCAD 2008 3D Modeling Workbook For Dummies by Lee Ambrosius (Author) # Paperback: 366 pages # Publisher: For Dummies; Pap/DVD edition (August 13, 2007) # Language: English # ISBN-10: 0470097639 # ISBN-13: 978-0470097632 Product DescriptionDownload
(1 votes, average: 4.00 out of 5) Loading ...Tags:AutoCAD, For Dummies; 66 views ; Comments: No Responses
Sams Teach Yourself SQL in 21 Days...
Sams Teach Yourself SQL in 21 Days by Ron Plew (Author), Ryan Stephens (Author) # Paperback: 864 pages # Publisher: Sams; 4 edition (October 25, 2002) # Language: English # ISBN-10: 0672324512 # ISBN-13: 978-0672324512Download
(No Ratings Yet) Loading ...Tags:Sams, SQL, Teach-Yourself; 124 views ; Comments: No Responses
Leave a Reply