It's Raining Books Sale
 
 

Recently Viewed clear list


Original Essays | September 18, 2014

Lin Enger: IMG Knowing vs. Knowing



On a hot July evening years ago, my Toyota Tercel overheated on a flat stretch of highway north of Cedar Rapids, Iowa. A steam geyser shot up from... Continue »
  1. $17.47 Sale Hardcover add to wish list

    The High Divide

    Lin Enger 9781616203757

spacer
Qualifying orders ship free.
$14.95
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Database- Design

Absolute Beginner's Guide to Databases

by

Absolute Beginner's Guide to Databases Cover

 

Synopses & Reviews

Publisher Comments:

Absolute Beginner's Guide to Databases brings 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.

About 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.

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.

Product Details

ISBN:
9780789725691
Author:
Petersen, John
Publisher:
Que
Subject:
Database Management - General
Subject:
Database management
Subject:
Information Storage & Retrieval
Subject:
Data Modeling & Design
Subject:
System Administration - Storage & Retrieval
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Absolute Beginner's Guides
Publication Date:
March 2002
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Pages:
336
Dimensions:
9 x 7.3 x 1 in 499 gr

Other books you might like

  1. Student Solutions Manual for... Used Trade Paper $6.95
  2. Introductory Algebra for College Stu... Used Hardcover $10.50
  3. The Writer's Presence: A Pool of... Used Trade Paper $2.50
  4. Common Sense Economics: What... Used Hardcover $9.95
  5. Lincoln at Gettysburg: The Words... Used Trade Paper $4.50
  6. The New Joys of Yiddish Used Hardcover $14.95

Related Subjects

Computers and Internet » Artificial Intelligence » General
Computers and Internet » Database » Design
Computers and Internet » Internet » Information
Computers and Internet » Software Engineering » Software Management

Absolute Beginner's Guide to Databases Used Trade Paper
0 stars - 0 reviews
$14.95 In Stock
Product details 336 pages QUE - English 9780789725691 Reviews:
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.