SQL For Dummies

Tags:, ; 1,050 downloads ; 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

047004652x500kw1 SQL For Dummies

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.2ikxlef SQL For Dummies

Popularity: 17% [?]

Note: We do not host these ebook files. If you have any complaint of copyright, please comment or contact us. We'll remove the download link immediatly!
We are pleased to offer you this exciting, new, and entirely free professional resource. Visit our Free Industry resource center today to browse our selection of 600+ complimentary Industry magazines, white papers, webinars, podcasts, and more.
Download Links:
Link1
Depositfiles
Tools to Download Faster
TweetBucks, Linkbee

Related eBooks - Up | Down


SQL Tuning...

SQL Tuning Author: Dan Tow Publisher: O'Reilly Media; 1st edition Publication Date: 2003-12-01 ISBN-10: 0596005733 ISBN-13: 9780596005733 Paperback: 336 Pages A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Tags:, ; 12 downloads ; Comments: 5 Responses

SQL for Dummies...

SQL for Dummies Allen G. Taylor (Author) # Paperback: 432 pages # Publisher: For Dummies; 5 edition (August 8, 2003) # Language: English # ISBN-10: 0764540750 # ISBN-13: 978-0764540752 This is the rare case of a book that can take you from a beginner to ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, ; 12 downloads ; Comments: No Responses

Beginning Oracle SQL...

Beginning Oracle SQL Author: Lex de Haan, Tim Gorman, Karen Morton, Daniel Fink, Inger Jorgensen Publisher: Apress; 1 edition Publication Date: 2009-12-21 ISBN-10: 1430271973 ISBN-13: 9781430271970 Paperback: 459 Pages Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, , ; 5 downloads ; Comments: No Responses

SQL, Second Edition...

SQL, Second Edition by Chris Fehily Paperback: 480 pages Publisher: Peachpit Press; 2 edition (May 22, 2005) Language: English ISBN-10: 0321334175 ISBN-13: 978-0321334176 ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Tags:; 17 downloads ; Comments: No Responses

Data Analysis Using SQL and Excel...

Data Analysis Using SQL and Excel by Gordon S. Linoff Paperback: 645 pages Publisher: Wiley; Pap/Onl edition (October 1, 2007) Language: English ISBN-10: 0470099518 ISBN-13: 978-0470099513 ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, , , ; 76 downloads ; Comments: 6 Responses

Advanced SQL Database Programmer Handboo...

Advanced SQL Database Programmer Handbook By: Burleson, Donald K.; Celko, Joe; Cook, John Paul; Gulutzan, Peter Published By: Rampant TechPress ISBN:097443552X Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks. All names ...
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, , ; 43 downloads ; Comments: No Responses

Microsoft SQL Server 2005 Reporting Serv...

Microsoft SQL Server 2005 Reporting Services For Dummies (For Dummies (Computer/Tech)) (Paperback) by Mark Robinson (Author) # Paperback: 432 pages # Publisher: For Dummies (December 19, 2005) # Language: English # ISBN-10: 076458913X # ISBN-13: 978-0764589133 Product Description
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, ; 180 downloads ; Comments: No Responses

Medical Terminology For Dummies...

Medical Terminology For Dummies (For Dummies (Health & Fitness)) (Paperback) by Beverley Henderson (Author), Jennifer Lee Dorsey (Author) # Paperback: 384 pages # Publisher: For Dummies; 1 edition (December 3, 2008) # Language: English # ISBN-10: 0470279656 # ISBN-13: 978-0470279656 Product Description
Download
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Tags:, , ; 240 downloads ; Comments: No Responses