Introduction to Databases Project Manual / Edition 1

Paperback (Print)
Rent from
(Save 75%)
Est. Return Date: 12/01/2014
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 94%)
Other sellers (Paperback)
  • All (11) from $1.99   
  • New (3) from $30.70   
  • Used (8) from $1.99   


You can get there

Introduction to Databases Project Manual offers a wealth of easy-to-read, practical, up-to-date activities that reinforce fundamental database design and management concepts. You'll also learn to develop the core competencies and skills you'll need in the real world, such as how to:
* Install SQL Server 2005
* Read and create an ERD
* Design and implement a database
* Use DDL and DML commands
* Use and monitor transactions
* Manage security principles, permissions, and backups
* Design data environments
* Use replication

With five to seven projects per chapter ranging from easy to more advanced, Introduction to Databases Project Manual is ideal for both traditional and online courses that are oriented toward strengthening database management skills.

Introduction to Databases Project Manual is an excellent companion to Gillenson's Introduction to Databases (ISBN: 978-0-470-10186-5).

Wiley Pathways helps you achieve your goals

Not every student is on the same path, but every student wants to succeed. The Information Technology series in the new Wiley Pathways imprint helps you achieve your goals. The books and project manuals in this series—Introduction to Databases, Introduction to Programming Using Visual Basic, Introduction to Operating Systems, Networking Basics, Windows Network Administration, Network Security Fundamentals, and PC Hardware Essentials—offer a coordinated information technology curriculum. Learn more at

Read More Show Less

Product Details

  • ISBN-13: 9780470114100
  • Publisher: Wiley
  • Publication date: 3/16/2007
  • Series: Wiley Pathways Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 312
  • Product dimensions: 8.54 (w) x 10.91 (h) x 0.70 (d)

Meet the Author

Frank Miller
Frank Miller
Frank Miller is one of the seminal creative talents who sparked today's onslaught of motion pictures featuring comic book characters and concepts. He single-handedly re-defined the presentation of comic book characters and heroic fiction with his grand-daddy of graphic novels, The Dark Knight Returns. Then his graphic novels turned box-office hits, including 300 and Sin City, proved that success does not always come wrapped in spandex.
Read More Show Less

Table of Contents

1. Introducing to Data and Data Management
1.1 Identifying Business Data
1.2 Identifying Human Data Sources
1.3 Installing SQL Server 2005 Evaluation Edition
1.4 Learning About SQL Server Management Studio
1.5 Identifying Key Management Areas

2. Introducing Databases and Database Management Systems
2.1. Comparing Database Models
2.2 Identifying DBMS Architecture and Components
2.3 Reviewing Server Hardware Resources
2.4 Investigating SQL Server Databases
2.5 Identifying Application Requirements

3. Data Modeling
3.1 Understanding Data Modeling Concepts
3.2 Recognizing Entities, Attributes, and Identifiers
3.3 Recognizing Relationships
3.4 Reading an ERD
3.5 Creating an ERD
3.6 Viewing Basic Database Objects

4. Designing a Database
4.1. Recognizing Key Concepts
4.2 Converting Relationships
4.3 Reviewing a Normalized Database
4.4 Recognizing Normalization Errors
4.5 Normalizing Data

5. Implementing a Database
5.1 Understanding Terms and Concepts
5.2 Identifying Solution Requirements
5.3 Creating a Database
5.4 Creating Tables, Part 1
5.5 Setting Table Constraints
5.6 Creating Tables, Part 2

6. Understanding the SQL Language
6.1 Understanding Terms and Concepts
6.2 Investigating Help Resources
6.3 Comparing Command Environments
6.4 Using the SELECT Statement
6.5 Using DDL Commands
6.6 Using DML Commands

7. Data Access and Manipulation
7.1 Understanding Data Access
7.2 Retrieving Data
7.3 Using Advanced Data Retrieval
7.4 Using Batches and Scripts
7.5 Recognizing and Correcting Errors

8. Improving Data Access
8.1 Understanding Data Access
8.2 Investigating Resources and Configuration Settings
8.3. Monitoring Performance
8.4. Recognizing Bottlenecks
8.5. Using Views and Indexes
8.6. Using Procedures and Functions

9. Database Administration
9.1 Understanding Administration
9.2 Understanding Roles and Responsibilities
9.3 Matching Lifecycle Requirements
9.4 Resolving Administration Issues
9.5 Managing "As-needed" and Periodic Tasks

10. Transactions and Locking
10.1 Understanding Transactions and Locking
10.2 Understanding Transaction Types
10.3 Understanding Transaction Isolation and Locking
10.4 Using Transactions
10.5 Monitoring Transactions and Clearing Blocked Transactions

11. Data Access and Security
11.1 Understanding Data Access and Security
11.2 Designing for Security
11.3 Understanding Your Security Environment
11.4 Managing Security Principals
11.5 Managing Permissions
11.6 Managing Backups

12. Supporting Database Applications
12.1 Understanding Support Configurations
12.2 Designing Data Environments
12.3 Working in a Distributed Environment
12.4 Using Distributed Queries
12.5 Using Replication
12.6 Understanding Data Issues

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)