Introduction to Databases Project Manual / Edition 1

Paperback (Print)
Rent
Rent from BN.com
$16.57
(Save 59%)
Est. Return Date: 05/28/2015
Used and New from Other Sellers
Used and New from Other Sellers
from $4.50
Usually ships in 1-2 business days
(Save 88%)
Other sellers (Paperback)
  • All (9) from $4.50   
  • New (4) from $31.60   
  • Used (5) from $4.50   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$31.60
Seller since 2008

Feedback rating:

(18393)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$31.61
Seller since 2009

Feedback rating:

(11111)

Condition: New
New Book. Shipped from US within 10 to 14 business days. Established seller since 2000.

Ships from: Secaucus, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$32.52
Seller since 2007

Feedback rating:

(23883)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$91.43
Seller since 2008

Feedback rating:

(210)

Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

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 www.wiley.com/go/pathways.

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)

Table of Contents

1 Introduction to Data and Data Management

1.1 Identifying Business Data 2

1.2 Identifying Human Data Sources4

1.3 Installing SQL Server 2005 Evaluation Edition 5

1.4 Learning About SQL Server Management Studio 12

1.5 Identifying Key Management Areas 19

2 Introducing Databases and Database Management Systems

2.1 Comparing Database Models21

2.2 Identifying DBMS Architecture and Components 23

2.3 Reviewing Server Hardware Resources24

2.4 Investigating SQL Server Databases 32

2.5 Identifying Application Requirements 35

3 Data Modeling

3.1 Understanding Data Modeling Concepts39

3.2 Recognizing Entities, Attributes, and Identifiers 40

3.3 Recognizing Relationships and Business Rules 42

3.4 Reading an ERD 45

3.5 Creating an ERD 47

3.6 Viewing Basic Database Objects 50

4 Designing a Database

4.1 Understanding Key Concepts 59

4.2 Converting Relationships 60

4.3 Reviewing a Normalized Database 65

4.4 Recognizing Normalization Errors 69

4.5 Normalizing Data 73

5 Implementing a Database

5.1 Understanding Terms and Concepts 78

5.2 Identifying Solution Requirements 79

5.3 Creating a Database 84

5.4 Creating Tables, Part 1 88

5.5 Setting Table Constraints 91

5.6 Creating Tables, Part 2 96

6 Understanding the SQL Language

6.1 Understanding Terms and Concepts 102

6.2 Identifying Help Resources 104

6.3 Comparing Command Environments 111

6.4 Using the SELECT Command 116

6.5 Using DDL Commands 121

6.6 Using DML Commands 126

7 Data Access and Manipulation

7.1 Understanding Data Access 132

7.2 Retrieving Data 133

7.3 Using Advanced Data Retrieval 138

7.4 Using Batches and Scripts 141

7.5 Recognizing and Correcting Syntax Errors 144

8 Improving Data Access

8.1 Understanding Database Monitoring and Optimization 149

8.2 Investigating Resources and Configuration Settings 151

8.3 Monitoring Performance 163

8.4 Recognizing Bottlenecks 172

8.5 Using Indexes and Views 175

8.6 Using Procedures and Functions 179

9 Database Administration

9.1 Understanding Administration 184

9.2 Understanding Roles and Responsibilities 186

9.3 Matching Life Cycle Requirements 188

9.4 Resolving Administration Issues 190

9.5 Managing "As-Needed" and Periodic Tasks 196

10 Transactions and Locking

10.1 Understanding Transactions and Locking 210

10.2 Understanding Transaction Types 212

10.3 Understanding Transaction Isolation and Locking 219

10.4 Using Transactions 226

10.5 Monitoring Transactions and Clearing Blocked Transactions 231

11 Data Access and Security

11.1 Understanding Data Access and Security 236

11.2 Designing for Access and Security 238

11.3 Understanding Your Security Environment 242

11.4 Managing Security Principals 249

11.5 Managing Permissions 255

11.6 Managing Backups 263

12 Supporting Database Applications

12.1 Understanding Data Configurations 267

12.2 Designing Data Environments 269

12.3 Working in a Distributed Environment 277

12.4 Using Distributed Queries 284

12.5 Using Replication 291

12.6 Understanding Data Issues 299

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)