SQL: a Beginner's Guide (eBook)

This fully revised, self-paced learning tool lays out all the necessary steps to quickly and easily start writing SQL programs Thoroughly updated to reflect the most recent ANSI/ISO standard, SQL: A Beginner's Guide, Fourth Edition will get you up-and-running with SQL programming right away. Clear tutorials, annotated code, and proven instructional tools guide you to easily performing queries and modifications, building databases, creating and reviewing embedded statements, troubleshooting system- and data-related problems, and much more. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. The book also covers new features, including SQL/XML and the long-awaited temporal support. Code examples are provided throughout along with notes on using them with the latest RDBMS software versions such as MySQL 5.7, SQL Server 2014, and Oracle Database 12 c . Platform-neutral coverage; all skills can be applied to any database product, and any SQL version Features hands-on exercises and self-tests that reinforce basic knowledge "Ask the Expert" sections throughout are filled with bonus information and useful tips This easy-to-follow guide enables readers to begin working with SQL - the core language for working with relational databases. Concepts are carefully explained and illustrative examples are provided to help clarify them. Exercises are also included to provide readers with practical experience. Essential SQL Skills Made EasyFully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features. Designed for Easy Learning: Key Skills & Concepts-Lists of specific skills covered in the chapter Ask the Expert-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 Tips-Helpful reminders or alternate ways of doing things Cautions-Errors and pitfalls to avoid Self-Tests-Chapter-ending quizzes to test your knowledge Annotated Syntax-Example code with commentary that describes the programming techniques being illustrated Essential SQL Skills Made Easy Fully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features. Designed for Easy Learning: Key Skills & Concepts—Lists of specific skills covered in the chapter Ask the Expert—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 Tips—Helpful reminders or alternate ways of doing things Cautions—Errors and pitfalls to avoid Self-Tests—Chapter-ending quizzes to test your knowledge Annotated Syntax—Example code with commentary that describes the programming techniques being illustrated Fully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features. -- Provided by publisher "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"--Resource description page