IT 221 Syllabus

Course Title and Number

IT 221 SQL




On line



IT 120

Course Overview

This course provides a hands-on introduction to the SQL database programming language


Students with documented disabilities requesting class accommodations, requiring special arrangements in case of building evacuation, or have emergency medical information the instructor should know about are asked to contact the disability support services office (DSS) in Rm. 1112. Once the disability is verified with DSS you will be given a letter of accommodation that should be to handed to your instructor.


Steve Conger

Office Location

BE3176 I

Office Hours

You can contact me through canvas email. I will also post an open zoom session for questions each week.


Web Site

Educational Philosophy

The pre-Socratic Philosopher Heraklitos said, "it rests by changing." By this he meant that the normal state of things is constant change. This has never been more true than today. Though, the course focuses on particular software, it has a broader purpose: Software changes constantly. The most important skills to learn, are the techniques for learning new skills, new software, and learning how to generalize the skills you've learned in order to apply them to new situations. These are the skills that will keep you afloat in stream of constantly changing technology.

Student Outcomes and competencies

Methods of Instruction

There are texts and videos for each assignment. In addition we can use the discussion boards. I will have an open zoom session for questions each week.


The Text book is included as PDF files. You can access them through Pages here in Canvas. 

Assignments and Schedule

Assignments are from the book and will be posted in Canvas. 

Topical Outline and Assignments

Creating tables
Retrieving data
Joining tables
Sub Queries
Advanced queries
Creating and altering objects
Administrative SQL

Grades and Attendance

Attendance is critical. There will be new material covered every day. However, I do not grade on attendance and daily lecture materials are posted on the blog. The daily assignments are worth 80% of the whole, the midterm and final are worth 20%. Daily assignments are worth 10 points each. The midterm and final are worth 25 points each. Each assignment has a rubric for grading.

Percent Grade
90 to 100 4.0
85 to 89 3.5
80 to 84 3.0
75 to 89 2.5
70 to 74 2.0
65 to 69 1.5
60 to 64 1.0