(FALL 2009)

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (SSIS) (MS Course 6235) (Section 1) I&C SCI X450.44  (2.5)

This course provides students with the knowledge and skills to successfully implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. This course covers the following topics: create an Integration Services package, implement control flow implement data flow and logging in an Integration Services, debug and implement error handling, deploy, manage and secure an Integration Services package. Prerequisites: Before attending this course, students must have 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)

Derrick Lam, M.B.A, has taught database courses in Oracle, Sybase, and Microsoft SQL Server at UCI Extension for over 14 years. He has worked with Oracle since 1988 and Sybase and Microsoft SQL Server since 1994. He is a database administrator and application developer for Oracle, Sybase, and Microsoft SQL Server. He currently oversees the UCI Alumni and Donor Database and the UCI Foundation Accounting System, and recently used SQL Server 2005 Integration Services to migrate the UCI Alumni and Donor Database from Sybase to Oracle. He has spoken at conferences on topics related to Data Management, Data Metrics, and Improving the Value of Data. His current assignments include enhancing the design of the UCI Alumni and Donor Database to increase the fundraising value of the data stored in it.