Essential Skills--Made Easy!
Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.
Designed for Easy Learning:
Key Skills & Concepts--Lists of specific skills covered in the chapter
Ask the Experts--Q&A sections filled with bonus information and helpful tips
Try This--Hands-on exercises that show how to apply your skills
Notes--Extra information related to the topic being covered
Self-Tests--Chapter-ending quizzes to test your knowledge
Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated
Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified.
Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases
Keywords: SQL, SQL:2006 ANSI/ISO STANDARD, SQL/XML, DATABASE PROGRAMMING, RELATIONAL DATABASE, RDBMS, DATABASE QUERIES, DATABASE TABLES, SUBQUERIES, SQL-INVOKED ROUTINES, SQL TRIGGERS, SQL CURSORS, SQL TRANSACTIONS, MYSQL, SQL DEMYSTIFIED, SQL THE COMPLETE REFERENCE, ORACLE DATABASE 11G SQL, MICROSOFT SILVERLIGHT 2.0 A BEGINNER'S GUIDE, SQL A BEGINNER'S GUIDE, C# 3.0 A BEGINNER'S GUIDE, ASP.NET 3.5 A BEGINNER'S GUIDE, PHP 6 A BEGINNER'S GUIDE, JAVA 7 A BEGINNER'S GUIDE, XML A BEGINNER'S GUIDE,