Request for consultation
Have a specific question or not sure where to start? Fill out the form below and we'll put you in touch with our best rockstar consultant to answer your questions
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.
- Building on the longstanding success of this proven text, the Ninth Edition introduces basic SQL commands in a real-world context using a running case, which explores how a business might use SQL to manage orders, parts, customers, and sales reps.
- A new continuing case problem appears in each chapter throughout the book.
- New cases are used in the end-of-chapter exercises and cases.
- Critical thinking questions and exercises that challenge students to use problem-solving and analytical skills appear in each case.
- To illustrate that fundamental principles and practices remain valid regardless of which database environment is used, the authors include numerous examples of the latest versions of Oracle®, Microsoft® Access®, and SQL Server.
- This invaluable reference introduces SQL programming using straightforward instruction, hands-on exercises, and a strong foundation in real-world business scenarios.
- Review questions, exercises, and hands-on projects conclude each chapter to reinforce learning and provide practice applying key concepts. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.
2. Database Design.
3. An Introduction to SQL.
4. Single-Table Queries.
5. Multiple-Table Queries.
6. Updating Data.
7. Database Administration.
9. Embedded SQL.
Appendix A: SQL Reference.
Appendix B: "How do I" Reference.
Appendix C: Answers to Odd-Numbered Review Questions.