- Course Title and Number
- ITC 224 Database Programming
- Credits
- 5
- Times
- MW 1:00 PM to 3:10 PM
- Prerequisites
- ITC 110, ITC 222
- Course Overview
- This course has changed and is differant than the outline published with the course on the course schedules page of the SCCC webseite. This course explores developing, testing and deploying database solutions. Currently, it is focused on SQL Server 2005, but this could be adapted as technologies change. The course will be scenario and case driven.
- ADA
- If you need course adaption or accomodation because of a disability, if you have emergancy medical information, or if you need special arrangements if the building must be evacuated, please make an appointment with your instructor as soon as possible
- Instructor
- Steve Conger
- Office Location
- BE1144A
- Office Phone
- 206.587.5458
- Office Hours
- See Schedule
- sconge@sccd.ctc.edu
- Web page
- http://seattlecentral.edu/faculty/sconge
- 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
- Create a plan for developing, testing and deploying database application solutions an
- Develop performance baselines and benchmarking strategies
- Develop application solutions to support business needs
- Test applications for business requirements, security and performance
- Research and Utilize relevant resources
- Work effectively in groups
- Methods of Instruction
- This course will be driven by a quarter long project. The goal of the project is to create a database application that involves application layer of stored procedures, views and functions, security policies and structures, and other features such as xml, http endpoints and CLR (Common language Runtime).
- Textbook
- None though I recommendProgramming SQL Server 2005Hamelton, O'Reilly Press
- Assignments and Schedule
- Primarily there will be the quarter long project. This will be done in groups. I will also have frequent short quizzes on concepts and terms.Below is a list of topics the project will cover, though not necessarily in the order we will cover them
- Topics
- Developing a testing plan for the application
- Security and Schemas
- Stored procedures, triggers, functions SQL and CLR
- http Endpoints
- importing data into the database
- Disaster recovery planning
- Building Reports
- Grading and Attendance
- Attendence is critical. 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 absence as you can. The project will be worth 100 points. I will provide a breakdown of all the requirements and what they are worth when I present the project scenario itself. The short quizzes will be worth 10 points each. Your total grade will be all the points from the project plus the points from the quizzes divided by the total number of possible points. (The total possible points will be 20 points less than the actual total--You can miss two quizzes without any penalty.)