Prentice Hall

Business



SQL for SQL Server
Bijoy Bordoloi, Southern Illinois University, Edwardsville
Douglas B. Bock, Southern Illinois University, Edwardsville

ISBN-10: 0131132997
ISBN-13: 9780131132993

Publisher: Prentice Hall
Copyright: 2004
Format: Paper; 416 pp
Published: 10/29/2003

Suggested retail price: $86.67
Buy from myPearsonStore



For use as a core text for SQL courses or as a supplemental text for an Introductory Database Management Systems course or an advanced course on Information Systems Implementation.

This text actually explains the features and usage of the SQL server command rather than just listing the note commands. This is truly the first students’ SQL text. In addition, this text offers complete instructors materials on the Companion Website.

  • A features and usage “problem-solving” approach—Follows a real-world approach to satisfying managerial information needed to support decision-making.

    • Teaches students to match SQL coding techniques to different types of management questions.

  • Numerous exercises and examples throughout with solutions to half of the end-of-chapter and end-of-text exercises—Includes 12-18 exercises and 20-30 coding exercises per chapter; additionally, there are end-of-text exercises that supplement each chapter.

    • Provides students with many different exercises and examples to use in learning the material. Enables instructors to use different examples in class to illustrate managerial decision-making, as well as aids in exam preparation.

  • Coverage of Data Definition Language with SQL.

    • Gives students and instructors information for table creation not usually found in other texts on the subject.

  • Numbered SQL coding examples—Lists the result table below the command.

    • Enables students to easily learn how the SQL commands work.

  • Two different databases—Provides a typical business scenario involving employees, projects, and other typical business entities with small datasets for tables. The second covers a hospital scenario with many more tables and relationships and larger datasets.

    • Provides students with real-life scenarios for ease of instruction.

  • Reference format—Includes the syntax of major SQL commands on the inside of the front and back covers.

    • Gives students an easy reference to the command syntax, making this text a “keeper” for future use.



 1. Introduction.


 2. Creating Tables and Indexes.


 3. Single Table Query Basics.


 4. Adding Power to Queries.


 5. Aggregate Row Functions.


 6. Joins.


 7. Subqueries.


 8. Views and Synonyms.


 9. Additional Functions.


10. Stored Procedures and Triggers.


11. SQL Server Database Administration.


12. Embedded SQL.


Appendix A: The Company Database Schema.


Appendix B: The Riverbend Hospital Case.


Appendix C: Solutions to Odd-Numbered Exercises.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson Higher Education representative for pricing and ordering information.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.



Copyright ©2009 Pearson Education. All rights reserved. Legal Notice | Privacy Policy | Permissions