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