(FALL 2009)

Gain the knowledge and skills needed to implement a Microsoft SQL Server 2008 database. You'll learn how to set up a new database and prepare it to be used by individual users or external applications that need to access or manipulate data. Topics include creating database files, creating tables and assigning data types, using XML in a database, setting up and optimizing an index, enforcing data security, implementing stored procedures and functions, ensuring data integrity (constraints, triggers, and XML schemas), manage transactions and locks, and using managed code within the database. Prerequisites: 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 databas

Victor T. Wu, M.S., is a CTO and co-founder of EmpowerTrain, an Irvine-based company that offers high-end training on technologies including Oracle Database, Sun Solaris, Microsoft technologies. He has worked in the information systems field for the past 25 years as developer, information architect, director, and CIO. His expertise includes C++, Java programming, Oracle database and SQL Server development, high availability and performance tuning, Sun Solaris security and system tuning. He is frequently involved in large scale database and system tuning projects in San Francisco, Los Angeles, and San Diego. Wu is a UCLA graduate, Oracle Certified DBA, Oracle Certified Developer and holder of three Oracle Masters. Wu received UC Irvine Extension's Distinguished Instructor Award (2003) and UCLA Extension's Distinguished Instructor Award (2007).