SQL: A Beginner's Guide 3/e

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

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