Absolute Beginner's Guide to Databases

( 1 )

Overview

Absolute Beginner's Guide to Databasesbrings the elements of a database together using easy to understand language, perfect for the true beginner. It not only gives specific hands on practice, but also provides an overview of designing, maintaining and using a database. This book covers what databases are used for, why databases are important, why the design of the database is important, database normalization, keys to solid database design, differences in types of databases, and indexes?what they are, how we use...

See more details below
Other sellers (Paperback)
  • All (23) from $1.99   
  • New (5) from $16.19   
  • Used (18) from $1.99   
Sending request ...

Overview

Absolute Beginner's Guide to Databasesbrings the elements of a database together using easy to understand language, perfect for the true beginner. It not only gives specific hands on practice, but also provides an overview of designing, maintaining and using a database. This book covers what databases are used for, why databases are important, why the design of the database is important, database normalization, keys to solid database design, differences in types of databases, and indexes—what they are, how we use them, and why they are important.

Read More Show Less

Product Details

  • ISBN-13: 9780789725691
  • Publisher: Que
  • Publication date: 3/28/2002
  • Series: Absolute Beginner's Guide Series
  • Pages: 336
  • Product dimensions: 6.60 (w) x 9.00 (h) x 0.80 (d)

Meet the Author

John V. Petersen is president and founder of Main Line Software, Inc., a Philadelphia, Pennsylvania based software application and database design firm. MLSI development platforms include Visual FoxPro, Visual Basic, Access, SQL Server, and Microsoft's newest development platform Visual Studio .NET.

John earned an MBA from the Haub School of Business at St. Joseph's University in 1993. John is currently a 2L at the Rutgers University School of Law. John has presented at many industry events including Microsoft Developer Days and Microsoft Tech-Ed. John's writing projects have included Visual FoxPro 6 Enterprise Development and Hands-On Visual Basic 6 Web Development from Prima Publishing, ADO Jumpstart MSDN Whitepaper, and numerous feature articles on application development and database design issues. John has been an annual recipient of Microsoft's Most Valuable Professional award since 1996.

Read More Show Less

Table of Contents

Introduction.

I. DATABASE BASICS.

1. An Introduction to Databases.

What Is a Database? How Databases Are Used. Typical Database Management Systems Used Today. Key Database Terminology. The Relational Database Model: An Overview. Database-Related Careers. What You Have Learned.

2. The Anatomy of a Real Database.

An Introduction to Microsoft Access. The Sample Northwind Traders Database. What You Have Learned.

II. DESIGNING AND BUILDING YOUR FIRST DATABASE.

3. An Introduction to Database Design.

Your Project: A Time Entry and Billing Database. Determine the Requirements of the Database. Introduction to Database Modeling. Model the Time Entry and Billing Database. What You Have Learned.

4. Database Design Continued: An Introduction to Normalization.

What Does It Mean to Normalize a Database? Steps to Normalize Your Data Model. Denormalize Data-When Does It Make Sense to Break the Rules? Normalization Applied-Review the TEB Database and Refine the Design. What You Have Learned.

5. Using Access to Build the Time Entry and Billing Database.

Automatically Generate the Database from the TEB Model. A Brief Review of the Access Database Designer. Use the Design to Create the Time Entry and Billing Database. What You Have Learned.

III. MAINTAINING YOUR DATABASE-AN INTRODUCTION TO DATABASE INTEGRITY.

6. Maintaining Integrity Through Data Validation Rules.

An Overview of How Validation Rules Work in Databases. Implement Field-Level Rules. Implement Row-Level Rules. What You Have Learned.

7. The Basics of Referential Integrity.

What Is Referential Integrity? Why Maintaining Referential Integrity Is Important. How Referential Integrity Works. What You Have Learned.

IV. USING YOUR DATABASE TO PROVIDE INFORMATION-AN INTRODUCTION TO SQL.

8. SQL Basics.

SQL Overview. Select Statement. Filter Results I: Use the Where Clause. Organize Output I: Use the Order By Clause. Combine Multiple Tables: Use the Join Statement. Combine Multiple Resultsets: Use the Union Clause. What You Have Learned.

9. SQL-Going Beyond the Basics.

Organize Output II: Use the Group By Clause. Use Aggregate Functions. Filter Results II: Use the Having Clause. Filter Results III: Create Parameterized SQL Statements. Modify Data with the Insert, Update, and Delete Statements. What You Have Learned.

10. Making SQL Queries a Part of Your Database.

An Overview of the Access Query Designer. Create Advanced Queries. What You Have Learned.

V. PUTTING YOUR DATABASE TO WORK-BUILDING A SIMPLE ACCESS DATABASE APPLICATION.

11. Building the User Interface Components.

Overview of the Access Form Designer. Create Forms for the TEB Application. Create a Main Menu Form. What You Have Learned.

12. Providing Useful Output: An Introduction to Creating and Designing Reports.

Overview of the Access Report Designer. Create Reports for the TEB Application. Add Report Items to the Main Menu Form. What You Have Learned.

Appendix A. The Structure of the TEB Database.

Appendix B. TEB Referential Integrity Rules.

Appendix C. Glossary.

Appendix D. Database-Oriented Periodicals.

Appendix E. Web-Based Resources.

Index.

Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

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
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted March 13, 2002

    Nice book

    The book takes complex topics and distills them down to a simple and easy to implement level.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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