ITC 222 SQL
MW I0:00 Am to 12:15 PM
ITC 220 with a 2.0 or higher or permission
This course provides a hands-on introduction to the SQL database programming language.
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.
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.
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.
T-SQL Fundamentals, Itzik Ben-Gan, Microsoft Press, ISBN 978-07356-5814-1
Assignments will be posted in Canvas.The book is primarily for reference. Additional materials will be provided for stored procedures and Triggers
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.
|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|