TY - BOOK AU - AU - Afyouni,Hassan A. AU - Shellman,Mark AU - Pratt,Philip J. AU - Last,Mary Z. TI - A guide to SQL SN - 9780357361689 (pbk) AV - QA76.73.S67 S545 2021 U1 - 005.756 G94 23 PY - 2021/// CY - Australia, Boston, MA PB - Cengage Learning, Inc. KW - SQL (Computer program language) N1 - Includes index; 1. Introduction to Kim Tay Pet Supplies and StayWell Student Accommodation Databases 2. Database Design Fundamentals 3. Creating Tables 4. Single-Table Queries 5. Multiple-Table Queries 6. Updating Data 7. Database Administration 8. Functions, Procedures, and Triggers Appendix A: SQL Reference Appendix B: How Do I Reference Appendix C: The 10 Commandments of Writing Queries; COECS; Bachelor of Science in Computer Science; COECS; Bachelor of Science in Computer Engineering; COECS; Bachelor of Science in Information Technology N2 - A GUIDE TO SQL, Tenth 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 ER -