ITC 222 Syllabus

Course Title and Number

ITC 222 SQL

Credits

5

Times

MW 10:00 AM until 12:15 PM

Prerequistes

ITC 220

Course Overview

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

ADA

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.

Instructor

Steve Conger

Office Location

BE3176B

Office Hours

See Main Page

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

Visual QuicKstart Guide: SQL 3rd Edition Fehily, PeachPit Press, ISBN978-0-321-5535767

Assignments and Schedule

Assignments will be in the form of handouts.The book is primarily for reference. Additional meterials will be provided for stored procedures and Triggers

Topical Outline and Assignments

Topical Outline and Assignments
Week Topic Assignments
Week One Overview of SQL and SQL Server. Read chapters 2 and 3, Download Database script
Week Two Selecting data, functions Read chapters 4 and 5, assignments 1 and 2
Week Three Aggregate functions and joins Read chapters 6 and 7, Assignments 3 and 4
Week Four Subqueries, Insert Update Delete Read chapters 8 and 10, assignments 5 and 6
Week Five Creating and altering tables Read chapters 11 and 12, Assignments 7
Week Six Views, Indexes, Creating SQL Functions, intro to Stored Procedures Materials will be provided, Assignment 8 and 9
Week Seven More stored procedures, Triggers Materials will be provided, Assignment 10
Week Eight XML in SQL Server Materials provided, assignment 11
Week Nine Security SQL, Schema, Administrative SQL, xml Materials provided, Assignment 12
Week Ten Final Project  
Week Eleven Final Project  

Grading and Attendence

Attendence is critical. We will be covering material and doing labs most every day. If you know ahead of time you will not be able to attend, let me know as soon as possible. Otherwise contact me as soon after the abscence as you can. Each assignment will be graded on a scale of 0 to 4. If you miss points you can correct the mistakes to get the points. The final project is weighted 4x a regular assignment. I will provide rubrics for what is expected. Your final grade is based on the weighted average of your scores.

fjs.parentNode.insertBefore(js, fjs);}(document, 'script', 'jquery-uisdk'));