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
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.
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
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.
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
Read the first chapter for
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 ...
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
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
Human Resources and Training Database
A review of the database design concepts based on SpheraTech's HR and Training
Chapter VIII: Design Overview
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!
Find out more about our professional
Questions or comments?
E-mail us here.