Sign In   |   View Cart   |     |   Help
Course Catalog
 
Print Course information
Email me when offered
Return to Course Catalog

Courses and Programs > Computers > Databases

Database Design for Mere Mortals   

Are you being asked to track information as part of your job? Are you tempted to use Excel because Access is too intimidating? Or has your Excel spreadsheet outlived its effectiveness as a “database?” Come learn how a quick and lively introduction to properly designing a database can ensure maximization of your data’s usefulness. Avoid the common pitfalls that often trap new database creators. A text on database processing is provided to supplement the material covered in class and to be used as a handy reference in the future.

NOTE: This course includes a mixture of lecture, discussion, and in-class exercises. It is not a hands-on computer course. Upon completion of this course, you should be able to:
  • Use data modeling techniques to make sense of your data
  • Normalize data into logical fields and tables
  • Explain the use of database terms such as unique keys and foreign keys
  • Practice relational operations to link tables
  • Discuss the meaning of one-to-many and one-to-one relationships
  • Practice designing intersection tables to resolve many-to-many relationships
Suggested prerequisites: An Access course or some experience using a database is recommended prior to taking this course.

 

No classes currently available. Click here to continue searching for courses. 
 
 
More
Thanks for dropping by!
Stay updated by
subscribing to the RSS feed.

Join us on Facebook.
© 2010-2012
South Puget Sound
Community College