SQL AIO Desk Reference For Dummies

From the Back Cover
Master queries for any SQL database!
Your one-stop guide to building and maintaining relational databases with SQL

If you’re looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you’re a database developer or DBA, you’ll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

Tackle a database development project
Formulate SQL queries
Build database applications
Secure your database
Handle XML data
Tune and optimize a database

About the Author
Allen G. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, Second Edition. He lectures internationally on astronomy, databases, innovation, and entrepreneurship. He also teaches database development and Crystal Reports through a leading online education. For the latest news on Allen’s activities, check out DatabaseCentral.Info or his blog at moontube.wordpress.com.

Related Articles

SQL All-in-One Desk Reference for Dummies

SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.
Book I: SQL Concepts

Book II: Relational Database Development

Book III: SQL Queries

Book IV: Data Security

Book V: SQL and Programming

Book VI: SQL and XML

Book VII: Database Tuning Overview

Book VIII: Appendixes

Crystal Reports 2008 for Dummies

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear.
Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to:

Pull specific information from your database, sort and group it, and find the details you need
Use dynamic or cascading prompts
Troubleshoot and print reports and save time with templates
View reports on your LAN
Write formulas to retrieve specific information
Create and update OLAP reports
Format reports, control page breaks, and even add graphics or Flash files
Enhance your reports with charts and maps
Use Crystal Reports in the enterprise

There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.

SQL for Dummies 9th Edition

Get ready to make SQL easy!

Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more.

SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease.

Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems
Find great examples on the use of temporal data
Jump right in—without previous knowledge of database programming or SQL

As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.

SQL All-In-One For Dummies 3rd Edition

SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

Cope with any issue that arises in SQL database creation and management
Get current on the newest SQL updates and capabilities
Reference information on querying SQL-based databases in the SQL language
Understand relational databases and their importance to today’s organizations

SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.

SQL All-In-One For Dummies 3rd Edition

The latest on SQL databases

SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

Cope with any issue that arises in SQL database creation and management
Get current on the newest SQL updates and capabilities
Reference information on querying SQL-based databases in the SQL language
Understand relational databases and their importance to today’s organizations

SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.