Taylor A.G. SQL For Dummies

8th ed. — Wiley, 2013. — 480 p. — ISBN: 1118607961, 9781118607961.Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don′t be daunted by database development anymore – get SQL For Dummies, 8th Edition , and you′ll be on your way to SQL stardom.Getting Started with SQL.
Relational Database Fundamentals.
SQL Fundamentals.
The Components of SQL.
Using SQL to Build Databases.
Building and Maintaining a Simple Database Structure.
Building a Multitable Relational Database.
Storing and Retrieving Data.
Manipulating Database Data.
Handling Temporal Data.
Specifying Values.
Using Advanced SQL Value Expressions.
Zeroing In on the Data You Want.
Using Relational Operators.
Delving Deep with Nested Queries.
Recursive Queries.
Controlling Operations.
Providing Database Security.
Protecting Data.
Using SQL within Applications.
Taking SQL to the Real World.
Accessing Data with ODBC and JDBC.
Operating on XML Data with SQL.
Advanced Topics.
Stepping through a Dataset with Cursors.
Adding Procedural Capabilities with Persistent Stored Modules.
Handling Errors.
Triggers.
The Part of Tens.
Ten Common Mistakes.
Ten Retrieval Tips.
Appendix: SQL: 2011 Reserved Words.