Prentice Hall

Business



Introduction to SQL Server 2005 & SQL Server 2005 CD Package
James T. Perry, University of San Diego
Gerald V. Post, University of the Pacific

ISBN-10: 0136133983
ISBN-13: 9780136133988

Publisher: Prentice Hall
Copyright: 2007
Format: Kit/Package/ShrinkWrap
Published: 09/26/2006

Suggested retail price: $90.27
Buy from myPearsonStore



For database management courses and courses devoted exclusively to Microsoft's SQL Server 2005.

 

Students need a big-picture introduction to SQL Server 2005 and they need specific examples and steps.  This concise book covers all of the topics students need in a course covering SQL Server 2005 while using numerous step-by-step techniques with a rich set of databases to provide students with practical experience.


Students need a big-picture introduction to SQL Server 2005 and they need specific examples and steps.  This concise book covers all of the topics students need in a course covering SQL Server 2005 while using numerous step-by-step techniques with a rich set of databases to provide students with practical experience.

 

Do you emphasize a balance between theory and application?

  • Mix of database theory and application steps in every one of the 14 chapters -- Emphasis is placed on the student working through step-by-step examples derived from a continuing company "Redwood Realty" featured in every chapter.
    • Pg. 146-147

Do you prefer exercises that allow students to follow the same companies as they apply what they've learned from each chapter and build upon the material?

  • Hands-on Exercises conclude each chapter and involve "Redwood Realty" and three additional ongoing company databases---"The Coffee Merchant", "Rowing Ventures" , and "Broadcloth Clothing." Built-in safeguards always allow the student to reload a fresh, correct database with each chapter.
    • Pg. 194-198

Do you focus on SQL in the course?

  • Extensive Coverage of SQL Language-- Covers seven of the first fourteen chapters to give students considerable practice in the creation and manipulation of queries.
    • Pg. 49

Do you cover both Windows and Web-based applications?

  • Covers both Windows and Web-based forms and applications using Visual Studio (Chapters 8 & 14).

 

OTHER POINTS OF DISTINCTION:

End of Chapter Material Includes:

 
Do you want students to have review questions to test their understanding of the content?
   •  Set of review questions at the end of each chapter includes:
          -  True/False Questions
          -  Fill-In Questions
          -  Multiple Choice Questions

          -  Four Hands-On Exercises using SQL Server 2005

 

What software and resources do you want available for your students?

    •  Student CD includes:
          -  SQL Server 2005
          -  A Version of Visual Studio 2005
          -  SQL Server 2005 tools, data files, scripts, and other data required to create every table and populate them for every chapter.

1. Introduction Relational Database Systems and SQL Server 2005

2. Overview of SQL and Interfacing with SQL Server

3. Creating, Modifying, Renaming, and Deleting Database Tables

4. Modifying Data and Auditing Table Operations

5. Querying a Database

6. Creating Multiple Queries and Views

7. Using SQL Extensions and Stored Procedures

8. Creating Database Forms with Visual Studio

9. Customizing Forms

10. Creating and Modifying Reports

11. Building an Integrated Application

12. Maintaining Database Security

13. Database Administration

14. Creating Web-based Forms with Microsoft ASP.NET

James T. Perry is a Professor of Information Systems in the School of Business at the University of San Diego. He holds a Ph.D. in computer science from the Pennsylvania State University and a Bachelor of Science in mathematics from Purdue University. He is the co-author of over 80 textbooks and trade books covering topics such as database management systems, the Internet, accounting information systems, Microsoft Office, electronic commerce, and the Oracle database management system. Some of his most popular books have been translated into Chinese, Dutch, French, and Korean.

 

Jim’s prior teaching appointments, spanning over 30 years, include the Information Systems Department at San Diego State University and the Computer Science Department at the University of Nebraska. He has also worked as a computer security consultant to various private and governmental organizations including the Jet Propulsion Laboratory. He was a consultant on the Strategic Defense Initiative (“Star Wars”) project and served as a member of the computer security oversight committee. When he is not writing or teaching, Jim can be found refereeing rowing regattas throughout California.

 

Gerald V. Post is a Professor of management information systems at the University of the Pacific. He has a Ph.D. in economics and statistics from Iowa State University and a Bachelor degree in mathematics and economics from the University of Wisconsin-Eau Claire. He is the author of textbooks in Database Management and Management Information Systems. He has published dozens of professional papers in many journals including Communications of the ACM, Management Information Systems Quarterly, and Decision Sciences.

 

Jerry has taught MIS and Database classes for over twenty years. He has developed several database applications for commercial businesses. When he is not writing, you can find him riding his bike or chasing his dogs through the hills.

View a Sample Chapter PDF:

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.

This package contains:

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.


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