Not Another SQL Manual
Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities — the domain of database gurus who possess enlightenment beyond that of ordinary mortals. This book sweeps away the database mystique. In this book, you will:
Get to the roots of databases.
Find out how a DBMS is structured.
Discover the major functional components of SQL.
Build a database.
Protect a database from harm.
Operate on database data.
Determine how to get the information you want out of a database.
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. 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.
Contents at a Glance
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: Retrieving Data
Chapter 6: Manipulating Database Data
Chapter 7: Specifying Values
Chapter 8: Advanced SQL Value Expressions
Chapter 9: Zeroing In on the Data You Want
Chapter 10: Relational Operators
Chapter 11: Delving Deep with Nested Queries
Chapter 12: Recursive Queries
Chapter 13: Providing Database Security
Part IV: Controlling Operations
Chapter 14: Protecting Data
Chapter 15: Using SQL Within Applications
Part V: SQL in the Real World
Chapter 16: ODBC and JDBC
Chapter 17: SQL:2003 and XML
Part VI: Advanced Topics
Chapter 18: Cursors
Chapter 19: Persistent Stored Modules
Chapter 20: Error-Handling
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
Download this manual:
http://bebasupload.com/y2gr93lp3dba/SQLforDummie5thEdition.rar.html
Register a free account first at bebasupload.com then copy-paste the link.
