BIT 275

Students learn the basics of the planning and design of relational databases and the use of the Structured Query Language (SQL). Students gain hands-on experience in implementing database solutions based on criteria obtained during client-programmer role-playing exercises. Topics of study include information design, data tables and the forming of complex queries as well as implementation planning.

Basic Information:

  • Instructor: Oliver Dain
  • Schedule: Tuesday and Thursday 11:00am to 1:05pm
  • Office Hours: Tuesday and Thursday 9:30am to 10:45am or by appointment
  • Oliver's Office: CC2-361
  • Class location: CC1-231
  • Syllabus

Reading Material:

  • Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Michael J. Hernandez, Addison-Wesley, Published 2003, 2nd edition
  • We will not use the optional “SQL Server 2005 for Developers” book.
  • Good SQL reference guides: