SQL For Dummies, 6th Edition

The purpose of this book is to help you build relational databases and get valuable information out of them by using SQL. SQL is the international standard language used around the world to create and maintain relational databases. This edition covers the latest version of the standard, SQL:2003, as augmented in 2005 with a thorough treatment of the use of XML with SQL.

This book doesn’t tell you how to design a database (I do that in Database Development For Dummies, also published by Wiley Publishing, Inc.). Here I assume that you or somebody else has already created a valid design. I then illustrate how you implement that design by using SQL. If you suspect that you don’t have a good database design, by all means, fix your design before you try to build the database. The earlier you detect and correct problems in a development project, the cheaper the corrections will be.

If you need to store or retrieve data from a DBMS, you can do a much better job with a working knowledge of SQL. You don’t need to be a programmer to use SQL, and you don’t need to know programming languages, such as Java, C, or BASIC. SQL’s syntax is like English.

If you are a programmer, you can incorporate SQL into your programs. SQL adds powerful data manipulation and retrieval capability to conventional languages. This book tells you what you need to know to use SQL’s rich assortment of tools and features inside your programs.

TABLE OF CONTENT:
Chapter 01 - Relational Database Fundamentals
Chapter 02 - SQL Fundamentals
Chapter 03 - The Components of SQL
Chapter 04 - Building and Maintaining a Simple Database Structure
Chapter 05 - Building a Multitable Relational Database
Chapter 06 - Manipulating Database Data
Chapter 07 - Specifying Values
Chapter 08 - Using Advanced SQL Value Expressions
Chapter 09 - Zeroing In on the Data You Want
Chapter 10 - Using Relational Operators
Chapter 11 - Delving Deep with Nested Queries
Chapter 12 - Recursive Queries
Chapter 13 - Providing Database Security
Chapter 14 - Protecting Data
Chapter 15 - Using SQL within Applications
Chapter 16 - Accessing Data with ODBC and JDBC
Chapter 17 - Operating on XML Data with SQL
Chapter 18 - Stepping through a Dataset with Cursors
Chapter 19 - Adding Procedural Capabilities with Persistent Stored Modules
Chapter 20 - Handling Errors
Chapter 21 - Ten Common Mistakes
Chapter 22 - Ten Retrieval Tips
Appendix A - SQL 2003 Reserved Words
Appendix B - Glossary

Download Here

Password:ganelon