- Course Title and Number
- ITC 224 Database Programming
- Credits
- 5
- Times
- TTH 9:40 to 12:50 PM
- Prerequisites
- ITC 220, ITC 172
- Course Overview
- This course uses Visual Basic and ADO or some other language, (C# perhaps) to develop business tier modules and user interfaces for databases. It can involve COM and Active X programming or other current technologies.
- ADA
- If you need course adaption or accommodation because of a disability, if you have
emergency 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
- BE3176B
- Office Phone
- 206.587.5458
- Office Hours
- See main page
- Email
- 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
- Diagram and navigate n-tier database architectures
- Follow naming conventions
- Create simple business level objects to validate and manipulate data
- Create user interfaces to allow the users to view and manipulate data
- Document code internally and externally
- Locate and use sources of relevant information
- Work together effectively in teams
- Methods of Instruction
- There will be some lecture to convey concepts and provide examples. Daily assignments will provide practice. There will be
a midterm and final.
- Textbook
- SQL Server 2008 Step by Step Mike Hotek, Microsoft, ISBN:0-7356-2604-9
- Assignments and Schedule
- Assignments will be made available on-line
- Topical Outline
- Importing data using integration services(Chapter 24)
- )wnership schema and security (Chapter 18 and bits of other chapters)
- Defining views. procedures, triggers and functions (Chapters 11, 12, 13, 14)
- Creating and implementing testing
- Creating CLR procedures and functions (Chapters 12, 13, 14)
- Using XML (both storing and retreiving)
- Creating application prototypes
- Creating reports using Reporting services(Chapter 25)
- Grading and Attendance
- Attendence is critical. We will be covering material and doing labs most every day. Assignments are worth 10 points each