SQL All–in–One For Dummies

Want to be a database diva or the office′s information oracle? Do it with SQL — here′s how!
SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you′re new to SQL or an old hand who wants to supercharge your database, find help in one of these minibooks!
The overview — Books I and II give you the nitty–gritty about SQL, relational databases, and the System Development Life Cycle
If you have queries — learn the fine points of making SQL retrieve exactly what you want from the database and no more
Safety first — discover the tools SQL provides to protect your vital data and handle any errors that occur
Integrating SQL with other languages — understand how SQL works with Visual Basic, Java, C++, and XML
Turbocharge your database — fine–tune and optimize your databases to keep them performing optimally
Visit the companion Web site at www.dummies.com/go/sqlaiofd2e to download a zip file that contains all the sample code used in this book
Open the book and find:
Details of how SQL works
SQL data types
Why the System Development Life Cycle matters
Directions for structuring SQL queries
Tips for protecting your database from user errors
Sample applications you can use
Ways to track down and eliminate bottlenecks
Definitions of common SQL terms
8 Books in 1
SQL Concepts
Relational Database Development
SQL Queries
Data Security
SQL and Programming
SQL and XML
Database Tuning Overview
Appendices

Spis treści:
Introduction.
Book I: SQL Concepts.
Chapter 1: Understanding Relational Datab ases.
Chapter 2: Modeling a System.
Chapter 3: Getting to Know SQL.
Chapter 4: SQL and the Relational Model.
Chapter 5: Knowing the Major Components of SQL.
Chapter 6: Drilling Down to the SQL Nitty–Gritty.
Book II: Relational Database Development.
Chapter 1: System Development Overview.
Chapter 2: Building a Database Model.
Chapter 3: Balancing Performance and Correctness.
Chapter 4: Creating a Database with SQL.
Book III: SQL Queries.
Chapter 1: Values, Variables, Functions, and Expressions.
Chapter 2: SELECT Statements and Modifying Clauses.
Chapter 3: Querying Multiple Tables with Subqueries.
Chapter 4: Querying Multiple Tables with Relational Operators.
Chapter 5: Cursors.
Book IV: Data Security.
Chapter 1: Protecting Against Hardware Failure and External Threats.
Chapter 2: Protecting Against User Errors and Conflicts.
Chapter 3: Assigning Access Privileges.
Chapter 4: Error Handling.
Book V: SQL and Programming.
Chapter 1: Database Development Environments.
Chapter 2: Interfacing SQL to a Procedural Language.
Chapter 3: Using SQL in an Application Program.
Chapter 4: Designing a Sample Application.
Chapter 5: Building an Application.
Chapter 6: Understanding SQL′s Procedural Capabilities.
Chapter 7: Connecting SQL to a Remote Database.
Book VI: SQL and XML.
Chapter 1: Using XML with SQL.
Chapter 2: Storing XML Data in SQL Tables.
Chapter 3: Retrieving Data from XML Documents.
Book VII: Database Tuning Overview.
Chapter 1: Tuning the Database.
Chapter 2: Tuning the Environment.
Chapter 3: Finding and Eliminating Bottlenecks.
Book VIII: Appendices.
Appendix A: SQL:2008 Reserved Words.
Appendix B: Glossary.
Index.

Nota biograficzna:
Allen G. Taylor lectures nationally on databases, innovation, and entrepreneurship, and teaches database development in ternationally through a leading online education provider. Among his more than 20 books are all editions of SQL For Dummies and Database Development For Dummies.

Okładka tylna:
Want to be a database diva or the office′s information oracle? Do it with SQL — here′s how!
SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you′re new to SQL or an old hand who wants to supercharge your database, find help in one of these minibooks!
The overview — Books I and II give you the nitty–gritty about SQL, relational databases, and the System Development Life Cycle
If you have queries — learn the fine points of making SQL retrieve exactly what you want from the database and no more
Safety first — discover the tools SQL provides to protect your vital data and handle any errors that occur
Integrating SQL with other languages — understand how SQL works with Visual Basic, Java, C++, and XML
Turbocharge your database — fine–tune and optimize your databases to keep them performing optimally
Visit the companion Web site at www.dummies.com/go/sqlaiofd2e to download a zip file that contains all the sample code used in this book
Open the book and find:
Details of how SQL works
SQL data types
Why the System Development Life Cycle matters
Directions for structuring SQL queries
Tips for protecting your database from user errors
Sample applications you can use
Ways to track down and eliminate bottlenecks
Definitions of common SQL terms
8 Books in 1
SQL Concepts
Relational Database Development
SQL Queries
Data Security
SQL and Progr amming
SQL and XML
Database Tuning Overview
Appendices