Business

For Database Management courses emphasizing database systems development using Microsoft SQL Server 2005, it could be used as either stand-alone or as a supplement to a more conceptual text.
 
This text provides an overview of database design and implementation topics using Microsoft SQL Server 2005, with an emphasis on database application development using Visual Studio.NET. Prerequisite knowledge is a one-semester programming course in any language.

This text provides an overview of database design and implementation topics using Microsoft SQL Server 2005, with an emphasis on database application development using Visual Studio.NET. 

• Presentation – Each chapter begins by presenting conceptual information followed by sections that a) address specific tasks by providing step-by-step instructions without continual repeats and b) sections that describe specific programming code first and then illustrate the syntax with an example.
  • Pg. 146-149

With the popularity of the web, do you cover web-based database applications?

• Comprehensive coverage of creating web-based database applications (Chapter 5) – Includes sections on the .Net Framework, the components of the IDE, and the fundamentals of VB programming language.
  • Pg. 195-270
    

• Entire Chapter on XML teaches how to write applications using XSLT as well as Web-based database applications that create and use XML files.
  • Pg. 452

• End-of-chapter Tutorials and Exercises – Some exercises provide explicit instructions, while others are more free-form and contain occasional hints. Data and solution files can be downloaded from www.prenhall.com/morrison.
  • Pg. 445-451

Table of Contents

Overview of Databases. The Database Development LIfe Cycle. Entity Relationship Modeling. Using an ER Model to Define Relational Database Tables.

2.  Creating SQL Server Databases

Database System Architectures. SQL Server 2005 DBMSsand Client Applications. SQL Server Database Objects. Creating and Managing Databases. Creating Database Tables. Deleting Database Tables. Modifying Existing Database Tables.

Sample Databases. Using SQL Queries to Retrieve Database Data. Using Arithmetic Operations in Queries. Using In-Line Functions in Queries.Using Aggregate Functions in Queries. Formatting Query Output. Retrieving Data From Multiple Tables. Creating Nester Queries. Database Views. Performing Set Operations in Queries.

Inserting, Updating, and Deleting Database Data. Database Transactions and Locking/Blocking. T-SQL Programming. Stores Procedures. User-defined Functions. Triggers.

.Net Framework. Using the VB Integrates Development Environment (IDE). VB Programming Fundamentals. Controlling Program Flow. User-Defined Procedures.

Accessing Data in .Net. Creating and Managing Data Access Components in the VB IDE. Common Database Interfaces. Working with Data-Bound Controls. Using Program Commands to Manipulate Data. Creating a Form Combining Data-Bound Controls and Program Commands. Retrieving Data Synchronously.

Common Database Report Layouts. Creating A Single-Table Tabular Report. Creating a Report That Displays Data From Multiple Tables. Creating a Master-Details Report with Multiple Master-Detail Relationships. Adding Summary and Formula Fields to a Report. Creating a Report That Accepts an Input Parameter.

Introduction to the World Wide Web. Web Addressing Concepts. HyperText Markup Language. Introduction to ASP.NET.Creating Web Database Forms.

Introduction to XML. Creating SQL Server Queries to Retrieve XML-Formatted Data. Extensivke Stylesheet Language Transformation (XSLTs). Creating and Processing XML Documents Using Data Sets. Using .NET Program Commands to Create XML Files and Add XML Elements. Sharing XML Data Using XML Web Services.

SQL Server Database Management Tools. Database Indexing. Security and User Authentication. Backup and Recovery. Deploying Database Applications.

Appendix A:  Configuring a client/server SQL Server application development environment 

Appendix B:  Configuring a SQL Express development environment

Database Management [SUPPLEMENTAL/VALUE PACK ITEMS] (MIS)
Database Applications - SQL Server [CORE TEXTS] (MIS)

Charles M. (Mike) Morrison is an Associate Professor in the Computer Science Department at the University of Wisconsin-Eau Claire.  He has an undergraduate degree in Geological Engineering from Colorado School of Mines, an MS in Geology from Oklahoma State University, an MBA from Oklahoma University, and a Ph.D in Management Information Systems from the University of Arizona.  He has co-authored four textbooks on Oracle database development and two textbooks on Web/Database application development.  When he isn't writing or teaching, you can find him riding his mountain bike or off-road motorcycles on Wisconsin trails.

Joline Morrison is an Associate Professor in the Computer Science Department at the University of Wisconsin-Eau Claire, where she teaches a variety of database and Web development topics.  Along with her husband, she has authored books on database development and Web/database development.  She has an undergraduate degree in engineering from the University of Wyoming, and a Ph.D in Management Information Systems from the University of Arizona.  Her winter hobby is alpine skiing, her summertime hobby is gardening, and her year-round hobbies are quilting and walking with her dog in the woods.

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.

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.

• Package ISBN-10: 0132410338 | ISBN-13: 9780132410335
  ©2007 | Online Schedule | Suggested retail price: $65.33 | Buy from myPearsonStore
  This package contains:
• Creating SQL Server 2005 Applications with Visual Studio, 1/E
  Morrison & Morrison | ©2007 | Prentice Hall | Paper; 600 pages
  
• SQL Server 2005, 8/E
  Hoffer | ©2007 | Software