ITC 222 Syllabus

ITC 222 Syllabus

Course Title and Number

ITC 222 SQL

Credits

5

Times

MW I0:00 Am to 12:15 PM

Prerequisites

ITC 220 with a 2.0 or higher or permission

Course Overview

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

ADA

Students with documented disabilities who need course accommodations, have emergency medical information, or require special arrangements for building evacuation should contact the instructor within the first two weeks of class.

Please note that Seattle Central is required by law to provide "reasonable accomodations" for students who qualify under the Americans with Disabilities Act. For more information on what this may mean for you or your students, please call Disability Support Services at 206 344-4347.

 

Instructor

Steve Conger

Office Location

BE3175B

Office Hours

by appointment

Email

steven.conger@seattlecolleges.edu

Web Site

http://seattlecentral.edu/faculty/sconge

Educational Philosopy

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 will be some lecture to convey concepts and provide examples. Daily assignments will provide practice. There will be a final Project that summarizes what has been learned.

Textbook

T-SQL Fundamentals, Itzik Ben-Gan, Microsoft Press, ISBN 978-07356-5814-1

Assignments and Schedule

Assignments will be posted in Canvas.The book is primarily for reference. Additional materials will be provided for stored procedures and Triggers

Topical Outline

Grading

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