(WINTER 2010)

This course provides students with the knowledge and skills required how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. This course covers the following topics: create a Reporting Services report, enhance a Reporting Services report, configure report publishing and execution settings, implement subscriptions for reports, administer Reporting Services, implement custom Reporting Services applications. Prerequisites: Before attending this course, students must have experience navigating the Microsoft Windows Server environment, and exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.

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.