- ITC 226 Database Administration
- Credits
- 5
- Times
- TTTH1:00 to 4:00 PM
- Prerequisites ITC 222
- ITC 222
- Course Overview
- This course provides practice with administrative activities, security and backup on a Relational Database Management System, using Administrative SQL and whatever tools the specific Relational Database Management System (RBMS) offers.
- 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
- 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
- Develop and implement a database monitoring plan
- Analyze monitored data
- Back up and recover data
- Plan and implement data integrity checks
- Plan and manage physical resource requirements
- Audit database systems
- Gather and document database security requirements
- Implement and enforce security requirements
- Work effectively in a team
- Locate and use sources of relevant informatio
- Methods of Instruction
- There will be some lecture, but the emphasis will be on hands-on practice with the SQL Server. We will be working our way through as many labs as possible. We will also do two scenarios which will attempt to take the material from the labs and put them into practice. We will also have 10 minute daily quizes which will come from the lesson reviews in the textbook
- Textbook
- SQL Server 2005 Implementation and Maintenance Self Paced Training Kit,Microsoft Press ISBN 0-7356-2271-x
- Assignments and Schedule
- We will work through as many labs in the book as possible. Below is a check list of topic. (some of these topics will also apply to the ITC 224 class. I placed a (224) beside those topics) It is quite probable that we will not make it through all the topics this summer.
- Grading and Attendance
- 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.