- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
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.
Contents
1. Introduction to KimTay 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
