- Course Title and Number
- ITC 226 Database Administration
- Credits
- 5
- Times
- TTH 1:30 PM to 4:20PM
- Prerequisites
- ITC 220, ITC 172
- 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 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
- 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 information
- Methods of Instruction
- This class will involve presentation as well as hands on excercises. We will divide the topics among small groups. Each group will be responsible for creating a presentation on the topic assigned, a excercise for the class to do, and three questions for a final exam. The students not presenting will be expected to complete and hand in the assignments. I will do the first few presentation and fill in any gaps. I will meet with each group prior to its presentation to help finalize their presentation and excercise.
- 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
- 1. Partitions
- 2. Retrieving and manipulating data (only highlight things not covered earlier)
- 3. Database Snapshots
- 4. Service Broker
- 5. Full text indexing
- 6. Security
- 7. Policy based management
- 8. Data Recovery
- 9. SQL Server Agent
- 10. Dynamic Management views
- 11. High availability
| Week/Day | Topic | Chapters |
|---|---|---|
| Week1 Day 1 | Installing upgrading, configuration (assign topics and groups) | Chapters 1, 2 ,3 |
| Week1 Day 2 | Creating databases tables etc. | Chapters, 4, 5, 6 |
| Week2 Day 1 | Open lab to prepare presentations | |
| Week2 Day 2 | Open lab to prepare presentations | |
| Week3 Day 1 | Partitions | Chapter 7 |
| Week3 Day 2 | Retrieving and manipulating data | Chapters 8,9,10 |
| Week4 Day 1 | Database Snapshots | Chapter 15 |
| Week4 Day 2 | Service broker | Chapter 16 |
| Week5 Day 1 | Full text indexing | Chapter 17 |
| Week5 Day 2 | Security | Chapter 18 |
| Week6 Day 1 | Policy Based Management | Chapter 19 |
| Week6 Day 2 | Data Recovery | Chapter 20 |
| Week7 Day 1 | SQL Server Agent | Chapter 21 |
| Week7 Day 2 | Dynamic management views. | Chapter 22 |
| Week8 Day 1 | High availability, Review, take home final | Chapter 23 |
| Week8 Day 2 | final |
- Grading and Attendance
- Attendence is critical. We will be covering material and doing labs every day. Each presentation is worth 50 points. I will provide you with a rubric to let you know how the points are awarded. Excercises are worth 10 points each and the final is also worth 50 points.