Available on Amazon.com


Your First Guide to Database Design
Kindle Edition
Andrew Comeau
 


Other Suggestions:






Microsoft Certified Professional

 

Take control of your data!
Learn new skills for your career!

Increasingly, our lives follow and leave behind a trail of electronic data from credit card and bank transactions to health information to social networking. Today's world is completely dependent on the flow of information and employers are increasingly looking for people with the right technical skills. Understanding how databases work is a major step in effectively working with the data that's important to you and your work. To learn more, check out ...

Your First Guide to Database Design

A clear guide to data organization and database design for both beginners and technology professionals.

Your First Guide to Database Design is a clear, easy-to-use guide to database concepts for both beginners and I.T. professionals who need to know how to organize and store any amount of information on any subject. Whether you're using a desktop database like Microsoft Access or more advanced tools such as SQL Server or MySQL, this book will show you how to create a model for the data, design the database itself and issue the right commands to read and write to your new database. Your First Guide to Database Design uses multiple examples including the Job Search Plus database to present the  principles behind database design in a way that everyone can understand.

Following up on my previous book, Microsoft Access for Beginners, this book moves beyond Access and explains how data is organized regardless of the database software being used. Your First Guide to Database Design demonstrates the entire design process starting with the raw data, organizing it into tables within a relational database and then using Structured Query Language (SQL) to manipulate the data for reports and analysis. The book includes an introduction to SQL to help you understand how to best access and work with your data. Screenshots from actual Microsoft SQL Server and MySQL databases are presented along with instructions on how to get started with free editions of either of these capable database management systems

Click here for the official support page.

Read the first chapter in Adobe PDF format!

Your First Guide to Database Design is the book you're looking for if ...

  • You work with large amounts of information on a regular basis and would like to know how to organize and understand it better. This can be true even if you never work directly with I.T.. Maybe you're an accounting professional trying to make sense of expense data or an administrative assistant who's been asked to put together a database for payroll or employee information. Regardless of your job, an understanding of database concepts will enable you to produce better results and reduce your work in the long-term.
  • You communicate on a regular basis with I.T. professionals and need to do it more effectively. Even if you never design a database yourself, knowing the principles involved goes a long way toward understanding the abilities and limitations of the software you work with. This will save you a lot of misunderstandings when asking for new reports or system enhancements.
  • You want to enhance your career and need a better understanding of software. A promising career can start simply by being the person in the office who can produce results nobody else can. Database design is a valuable skill that will continue to be relevant for many years to come. While reading this book won't add it to your resume immediately, knowing the basics can put you in the position to volunteer for that project that will get you noticed later.
  • You're a hobbyist with a copy of Microsoft Access or another database program and you want to organize your media collection or exercise program.
  • Finally, you are an I.T. professional, maybe even a programmer or software developer, who is still a little fuzzy on the details of database design. Maybe you're just coming back to it after years of doing other work and need a refresher course. Having a reference by your side can be very helpful when working on your latest project.

Your First Guide to Database Design is now available on both Amazon.com and BarnesAndNoble.com!  Read the first chapter for FREE!

You can also download the JobSearch 2010 database
for a preview of one of the examples used.

Click here for the book's official support page with downloads and
other supplemental materials.


Check out the Table of Contents ...

Chapter Subject
   
Chapter I:
Databases: In Theory and Everyday Life
An introduction to how databases are used in everyday life and the various types of electronic databases.

Chapter II: Database Design - The First Steps Basic data modeling - defining the data requirements for a program and organizing data into a logical system of tables.

Chapter III: Database Normalization Continuing with the modeling process started in Chapter II, this chapter shows how to apply some basic rules to eliminate redundant information and help ensure accuracy.

Chapter IV: Creating the Tables A demonstration of how to turn a completed data model into a system of related tables within Microsoft SQL Server.

Chapter V: Reading and Writing the Data An introduction to Structured Query Language (SQL) and a demonstration of how its various commands can be used to read and write to your new database.

Chapter VI: Moving Forward A look at the basics of creating a user-friendly program interface for your new database so that others can more easily enter information and run reports.

Chapter VII : Design Overview -
Human Resources and Training Database
A review of the database design concepts based on SpheraTech's HR and Training database.

Chapter VIII: Design Overview -
Recipe Database
A further review of the concepts using the example of a recipe database used in a small catering business.

Download Your First Guide to Database Design today ... only $9.99!

Formatted for convenient off-line study and available for download on the following sites!

 

 

Amazon.com (Kindle format) - Download and read Your First Guide to Database Design in seconds right on your Kindle or other device with one of Amazon.com's free Kindle reading apps.

Barnes and Noble (Nook) - If you're a fan of the Nook, Your First Guide to Database Design is now available for download straight from Barnes and Noble's site.

Scribd.com (Adobe PDF) - Don't have an e-reader? Your First Guide to Database Design is available in Adobe PDF reader which you can read on any computer or device that has Adobe Reader installed.

 

Your First Guide to Database Design
Andrew Comeau

Now available on Amazon.com and BarnesAndNoble.com!

Click here for the official support page.

Read a free preview of the first chapter.

 


Find out more about our  professional consulting services.

Questions or comments?  E-mail us here.