Meeting time: T 10:00–11:20

Instructor:Jessen Havill

Office:Olin 208


Office Hours:MWF 1:30-3,T 8:30-9:30, or by appointment (emailme)


In this 1-credit course, we will study the basic principles involved in creating, maintaining, and querying relational databases. We will apply these principles, using the database query language SQL, to several projects involving Denison data.

Required Text

Learning SQL by Alan Beaulieu, 2013

Web Resources

The pages on this course web site ( contain adaily schedulewith reading assignments and projects, as well as links to other potentially useful resources. Bookmarkthedaily schedulepage and refer to itoftenfor updated information.

Outside of class, we will usePiazzafor Q&A and discussion. When you have a question, instead of sending me an email, pleasepost it to Piazza.This way,everyone can benefit from the answer. You are also strongly encouraged toanswer your classmates’questionson Piazza. If will answer them too but, if you see it first, answer it!

Attendance and Other Responsibilities

Since this is a 1-credit class, we will only meet once a week, and the workload expectations are lower than for a“normal”class. However, yourattendanceand active participation are still expected at each class meeting. As you can see below, participation is a significant portion of the grade. Of course, excused absences (sickness, family emergencies, varsity athletic participation) will not be held against you. Such absences should be communicated to mein advance. You are responsible for the content of reading assignments, lectures and handouts, as well as announcements and schedule changes made in classwhether or not you are present. If you must miss a class, be sure to check with me or another student to get what you missed.

Group Projects

Most of the work in this class will involve applying what you learn to build database programs for various offices on campus. More to come...

Academic Integrity

Proposed and developed by Denison students, passed unanimously by DCGA and Denison’s faculty, the Code of Academic Integrity requires that instructors notify the Associate Provost of cases of academic dishonesty, and it requires that cases be heard by the Academic Integrity Board. Further, the code makes students responsible for promoting a culture of integrity on campus and acting in instances in which integrity is violated. Academic honesty, the cornerstone of teaching and learning, lays the foundation for lifelong integrity. Academic dishonesty is intellectual theft. It includes, but is not limited to, providing or receiving assistance in a manner not authorized by the instructor in the creation of work to be submitted for evaluation. This standard applies to all work ranging from daily homework assignments to major exams. Students must clearly cite any sources consulted – not only for quoted phrases but also for ideas and information that are not common knowledge. Neither ignorance nor carelessness is an acceptable defense in cases of plagiarism. It is the student’s responsibility to follow the appropriate format for citations. Students should ask their instructors for assistance in determining what sorts of materials and assistance are appropriate for assignments and for guidance in citing such materials clearly.

You can find further information about Denison’s Code of Academic Integrity on Denison’s web site at

Students found responsible for breaches of academic integrity may earn a failing grade for the course.

Grade Determination

The following relative weights will be used to determine your finalgrade:

  • Projects 80%
  • Participation 20%

Any student who feels he or she may need an accommodation based on the impact of a disability should contact me privately as soon as possible to discuss his or her specific needs. I rely on the Office of Academic Support to verify the need for reasonable accommodations based on documentation on file in their office.

Course Evaluations

At the end of the semester, you will be asked to evaluate this course and the instructor. These evaluations are an important tool for helping Denison faculty achieve and maintain excellence in the classroom; it will also help you reflect on your learning, participation, and effort in the course. A key purpose of course evaluations, then, is to constantly improve the level of teaching and learning at Denison by instructors and students. Your ratings and comments will also be included as one element of an instructor's overall teaching portfolio. Together with peer observations and other means of assessing teaching effectiveness, this portfolio will be considered by the instructor's colleagues and college administrators in making recommendations for contract renewal, tenure, promotion, and salary decisions.

Have a great semester! If you need anything, please let me know.

Jessen Havill 2015