A Guide to SQL (MindTap Course List)

Master today's SQL programming principles and learn how to most effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last's A GUIDE TO SQL, Tenth Edition. This edition's leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today's actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps. This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world's most popular open source, free database, as well as Oracle® and Microsoft® SQL Server. In addition, MindTap digital learning solution is available to help you strengthen your SQL skills. A Guide to SQL Table of Contents Preface About the Authors Module 1: Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases Introduction What Is a Database? The KimTay Pet Supplies Database StayWell Student Accommodation Database Module Summary Key Term Case Exercises Module 2: Database Design Fundamentals Introduction Database Concepts Functional Dependence Primary Keys Database Design Normalization Diagrams for Database Design Module Summary Key Terms Review Questions Case Exercises Module 3: Creating Tables Introduction Creating and Running SQL Commands Creating a Database Creating a Table Using Data Types Using Nulls Adding Rows to a Table Viewing Table Data Correcting Errors in a Table Saving SQL Commands Creating the Remaining Database Tables Describing a Table Module Summary Key Terms Review Questions Case Exercises Module 4; Single-Table Queries Introduction Constructing Simple Queries Sorting Using Functions Nesting Queries Grouping Nulls Summary of SQL Clauses, Functions, and Operators Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 5: Multiple-Table Queries Introduction Querying Multiple Tables Comparing Joins, IN, and EXISTS Set Operations ALL and ANY Special Operations Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 6: Updating Data Introduction Creating a New Table from an Existing Table Changing Existing Data in a Table Adding New Rows to an Existing Table Autocommit, Commit, and Rollback Transactions Changing and Deleting Existing Rows Changing a Value in a Column to Null Changing a Table’s Structure Dropping a Table Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Module 7: Database Administration Introduction Creating and using Views Using a View to Update Data Dropping a View Security Indexes System Catalog Integrity Constraints in SQL Module Summary Key Terms Review Questions Case Exercises Module 8: Functions, Procedures, and Triggers Introduction Using SQL in a Programming Environment Using Functions Concatenating Columns Stored Procedures Using MySQL Error Handling Using Update Procedures Selecting Multiple Rows with a Procedure Using PL/SQL in Oracle Using T-SQL in SQL Server Using a Trigger Module Summary Key Terms Review Questions Case Exercises KimTay Pet Supplies StayWell Student Accommodation Appendix A: SQL Reference Appendix B: How Do I Reference Appendix C: The 10 Commandments of Writing Queries Index A Guide to SQL, 8th Edition continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on students learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter. - Publisher. A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle® and Microsoft® Access®, and SQL Server throughout the text