HOUSTON COMMUNITY COLLEGE SOUTHWEST Implementing and Maintaining Microsoft SQL Server 2005 Integration Services, Academy ITSC 1091 Date and Time of class: Class CRN: Instructor’s Name: School Site: Phone number:-2- Revised 5/21/07 HOUSTON COMMUNITY COLLEGE • SOUTHWEST COURSE SYLLABUS Implementing and Maintaining Microsoft SQL Server 2005 Integration Services, Academy ITSC 1091 This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2005 Integration Services. Topics address recently identified current events, skills, knowledges, and/or attitudes and behaviors pertinent to the technology or occupation and relevant to the professional development of the student. This course was designed to be repeated multiple times to improve student proficiency. COURSE OBJECTIVE This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses GOALS Students will: • Learn how to develop, deploy, and manage Integration Services packages. • Learn how to debug and implement error handling in an Integration Services package. LEARNING OUTCOMES After completing the course, students will be able to: • Describe SQL Server Integration Services and its tools. • Create an Integration Services package. • Implement control flow in an Integration Services package. • Implement data flow in an Integration Services package. • Implement logging in an Integration Services package. • Debug and implement error handling in an Integration Services package. • Implement checkpoints and transactions in an Integration Services package. • Deploy an Integration Services package. • Manage and secure an Integration Services package. PREREQUISITE Before attending this course, students must have: • Exposure to enterprise data import and export scenarios. • Experience navigating the Microsoft Windows Server environment. • Experience with Microsoft SQL Server, including: • SQL Server Agent. • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE). • SQL Server System tables. • SQL Server accounts (users and permissions).-3- Revised 5/21/07 REQUIRED TEXTBOOK The provided student kit includes a comprehensive workbook and other necessary materials for this workshop. COURSE REQUIREMENTS AND EXPECTATIONS This is a 24-hour instructor guided course. Student will complete hands-on, in-class assignments. ATTENDANCE To fully benefit from the class, students are expected to attend all classes. REQUIREMENTS FOR COURSE COMPLETION CERTIFICATE To receive a Certificate of Completion and be awarded Continuing Education Units, students must meet the following requirements: • Attend at least 80% of scheduled class time • Complete the course lab demonstrating 80% mastery of course concepts or equivalent skills demonstration to instructor. OPPORTUNITIES FOR STUDENT-FACULTY INTERACTION Students are encouraged to ask questions and request clarification or guidance as needed during class. A question and answer period is always provided. OPPORTUNITIES FOR CAREER EXPLORATION Topics relevant to future employment and career exploration opportunities will be presented to the students, including certification and degree prospects. OPPORTUNITIES FOR SUPPLEMENTAL INSTRUCTION Students are informed of instructional aids and resources, including books, other publications, and web sites relevant to the course. SPEAKER FORUM At the discretion of the instructor, speakers may be invited to address the class on pertinent topics. CELL PHONES AND PAGERS Cell phones and pagers can be disruptive during class. Please turn these devices off or set to mute while in the classroom or student lab.-4- Revised 5/21/07 WITHDRAWAL AND REFUND POLICY Please refer to your schedule for withdrawal and refund policy. DISABILITY SERVICES Any student with a documented disability (e.g. physical, learning, psychiatric, vision, hearing, etc.) who needs to arrange reasonable accommodations must contact the Disability Services Office at the respective college at the beginning of each semester. Faculty is authorized to provide only the accommodations requested by the Disability Support Services Office. The Southwest College Disability Services Office phone number is 713-718-7909. COURSE CONTENT Module 1: Introduction to SQL Server 2005 Integration Services Module 2: Developing Integration Services Solutions Module 3: Implementing Control Flow Module 4: Implementing Data Flow Module 5: Implementing Logging Module 6: Debugging and Error Handling Module 7: Implementing Checkpoints and Transactions Module 8: Deploying Packages Module 9: Managing and Securing Packages STUDENT ASSESSMENT Students will develop, and demonstrate to the instructor, how to implement an Integration Services