(FALL 2009)

Writing Queries Using MS SQL Server 2008 Transact-SQL (Microsoft Course 2778) (Section 1) I&C SCI X450.40  (2.5)

This course provides students with the concepts of relational databases and the powerful Transact-SQL queries for Microsoft SQL Server 2008. In this class students will learn the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata. In addition, the advanced features of Transact-SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Topics in this course include: group and summarize data, join data from multiple tables, write queries that retrieve and modify data by using subqueries, learn data manipulation language, query text fields with full-text search, use various techniques when working with complex queries. Prerequisites: Basic knowledge of database system.

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).