(FALL 2009)

Gain the knowledge and skills needed to maintain a Microsoft SQL Server 2008 database. This course addresses your job as a database administrator after you have set up a database. You'll learn how to manage database files and security, back up and restore databases, monitor SQL Server performance, and troubleshoot database problems. You'll also learn how to transfer data among various data sources and ensure that your database remains available to users. Topics in this course include: manage database files, backup and restore databases, manage security, transfer data into and out of SQL Server, automate administrative tasks, automate administrative tasks, replicate data between SQL Server instances, maintain high availability, monitor SQL Server. Before attending this course, students must have basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases.

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.