A guide to SQL /
Mark Shellman, Gaston College, Hassan Afyouni, Ed.D., e-conn Chief Information Officer, Philip J. Pratt, Grand Valley State University, Mary Z. Last.
- Tenth edition.
- xvi, 287 pages : colored illustrations ; 24 cm
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
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.
College of Engineering and Computer Studies Bachelor of Science in Computer Science College of Engineering and Computer Studies Bachelor of Science in Computer Engineering College of Engineering and Computer Studies Bachelor of Science in Information Technology