Prentice Hall

Information Technology



Absolute Beginner's Guide to Databases
John Petersen

ISBN-10: 078972569X
ISBN-13: 9780789725691

Publisher: Que Publishing
Copyright: 2002
Format: Paper; 336 pp
Published: 03/05/2002

Suggested retail price: $29.99
Buy from myPearsonStore



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.



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.

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.

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.

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.

This title is a member of the Absolute Beginner's Guide, which also contains the titles below . You can also visit the Absolute Beginner's Guide page.

    Appropriate for all introductory-level courses in computing.

    Absolute Beginner's Guide to Computer Basics, Second Edition gives students all the information and guidance they need to effectively use any personal computer system, as well as common peripherals ranging from CD burners and digital cameras to PDAs. Author Michael Miller is a long-time expert on teaching introductory computing topics. This easy-to-use resource uses the Absolute Beginners Guide “teacher” style to guide students through every essential technique and skill, one step at a time. Miller shows students how to set up their computer hardware, navigate and use the Windows XP desktop, work with essential software programs, and more. Miller also provides a complete introduction to using the Internet, from connectivity to Web browsing, searching to e-commerce, email, instant messaging, chat, weblogs, downloading, and more. The book contains equally thorough coverage of digital media, one of todays hottest topics for beginning users—including burning CDs, using MP3 players, editing photos, and more. Users will also learn how to keep their computer systems up and running, and how to troubleshoot common computer problems. Miller explains each concept in easy-to-understand language, with step-by-step instructions, helpful illustrations, practical guidance, and real-world advice.

  • 0789731754Absolute Beginner's Guide to Computer Basics, 2/E
    Miller
    © 2004 | Que Publishing | Paper; 408 pages | Instock
    ISBN-10: 0789731754 | ISBN-13: 9780789731753
    Brief Description | Buy from myPearsonStore

  • 0789733706Absolute Beginner's Guide to Cooking
    Roussou
    © 2005 | Que Publishing | Paper; 384 pages | Instock
    ISBN-10: 0789733706 | ISBN-13: 9780789733702
    Buy from myPearsonStore

  • 0789728958Absolute Beginner's Guide to Creating Web Pages, 2/E
    Stauffer
    © 2003 | Que Publishing | Paper; 384 pages | Instock
    ISBN-10: 0789728958 | ISBN-13: 9780789728951
    Buy from myPearsonStore

  • 078972569XAbsolute Beginner's Guide to Databases
    Petersen
    © 2002 | Que Publishing | Paper; 336 pages | Instock
    ISBN-10: 078972569X | ISBN-13: 9780789725691
    Buy from myPearsonStore

    • PLEASE PROVIDE COURSE INFORMATION

    PLEASE PROVIDE

  • 0789729113Absolute Beginner's Guide to Networking, 4/E
    Habraken
    © 2003 | Que Publishing | Paper; 504 pages | Instock
    ISBN-10: 0789729113 | ISBN-13: 9780789729118
    Brief Description | Buy from myPearsonStore

    • Even if you've never opened the case on your PC, the Absolute Beginner's Guide to PC Upgrades will show you how you can add hardware components, upgrade peripherals, and keep current on new version of your operating system and applications.

  • 0789724170Absolute Beginner's Guide to PC Upgrades
    Lee & Hudspeth
    © 2000 | Que Publishing | Paper; 592 pages | Instock
    ISBN-10: 0789724170 | ISBN-13: 9780789724175
    Brief Description | Buy from myPearsonStore

    • Appropriate for all introductory courses on project management, and as a supplement in courses on Microsoft Project or courses that prepare students for PMP certification.

    Absolute Beginner's Guide to Project Management gives students all the information and guidance they need to effectively manage and lead a successful project from start to finish. This easy-to-use resource uses the Absolute Beginners Guide “teacher” style to guide students through every essential technique and skill, one step at a time. Long-time project manager and consultant Greg Horine emphasizes the common elements of successfully managed projects, and shares lessons learned from both successful and failed projects. Horine focuses on the skills and qualities needed by effective project managers in todays environment, including the increasingly popular “servant leadership” approach. He covers emerging and accelerating project trends ignored by many books, including IT project management issues, multi-vendor projects, outsourcing, virtual teams, multi-cultural teams, quality management, and risk management. Along the way, Horine covers the entire project lifecycle, showing how to build project budgets and schedules, make project presentations, manage vendors, address project changes while protecting quality, and more. The book also contains a full chapter on using Microsoft Project to support project management.

  • 0789731975Absolute Beginner's Guide to Project Management
    Horine
    © 2005 | Que Publishing | Paper; 336 pages | Instock
    ISBN-10: 0789731975 | ISBN-13: 9780789731975
    Brief Description | Buy from myPearsonStore

  • 0789730456Absolute Beginner's Guide to Upgrading and Fixing Your PC
    Miller
    © 2004 | Que Publishing | Paper; 408 pages | Instock
    ISBN-10: 0789730456 | ISBN-13: 9780789730459
    Buy from myPearsonStore

    • Appropriate for all introductory courses in wireless networking.

    Absolute Beginner's Guide to Wi-Fi Wireless Networking gives students all the information and guidance they need to effectively set up and use any Wi-Fi wireless network. This easy-to-use resource uses the Absolute Beginners Guide “teacher” style to guide students through every essential technique and skill, one step at a time. Students will learn how to choose and set up wireless networking equipment; set up computers and PDAs to connect with wireless networks; find hotspots and access points; and much more. Coverage also includes: Wi-Fi standards and protocols, Internet connectivity, and detailed, step-by-step coverage of wireless security. Davis explains each concept in easy-to-understand language, with step-by-step instructions, helpful illustrations, practical guidance, and real-world advice.

  • 0789731150Absolute Beginner's Guide to Wi-Fi Wireless Networking
    Davis
    © 2004 | Que Publishing | Paper; 312 pages | Instock
    ISBN-10: 0789731150 | ISBN-13: 9780789731159
    Brief Description | Buy from myPearsonStore

    • Appropriate for all introductory- to intermediate-level courses in word processing with WordPerfect 12.

    Absolute Beginner's Guide to WordPerfect 12 gives students all the information and guidance they need to master WordPerfect 12 and use it for virtually any common word processing task. Laura Acklen—host of the Webs #1 WordPerfect tips site—explains each WordPerfect concept and technique in easy-to-understand language, with step-by-step instructions, helpful illustrations, practical guidance, and real-world advice. Students who are upgrading from older versions of WordPerfect will master its powerful new features quickly and efficiently. Coverage includes: getting started; creating and working with documents; basic editing and formatting; using WordPerfects Writing Tools; working with paragraphs, pages, and styles; using tables, lists, and outlines; adding graphics, sharing data, creating mail merges, using WordPerfects Legal Tools, and more.

  • 0789732424Absolute Beginner's Guide to WordPerfect 12
    Acklen
    © 2005 | Que Publishing | Paper; 432 pages | Instock
    ISBN-10: 0789732424 | ISBN-13: 9780789732422
    Brief Description | Buy from myPearsonStore

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.


Copyright ©2009 Pearson Education. All rights reserved. Legal Notice | Privacy Policy | Permissions