Learn T-SQL programming skills for SQL Server database. Topics covered will allow you to write effective data definition and data modification languages for the latest version of SQL Server. This course will provide a thorough understanding of creating data structures, selecting and modifying data, stored procedures, functions, recursive common table expressions, and querying xml data. You will learn how to design and develop database objects on a SQL Server Database Engine; and utilize real world experiences to highlight T-SQL best practices and design patterns.
Note: "Introduction to SQL programming concepts" or basic understanding of primary key, foreign keys, create table definitions, and inserting data into tables. Ability to download and install SQL Server 2008 R2 Enterprise Evaluation Version and Adventworks2008 OLTP sample database.
Course Number: CSE-41133 Credit: 3 units
There are no sections of this course planned for the current quarter. Please contact the Technology department at or firstname.lastname@example.org for information about when this course will be offered again.