Course Name:Microsoft SQL Server 2012 Working with Transact-SQL (T-SQL)
Refer to Exam: Querying Microsoft SQL Server 2012 (70-461)
Class Duration: 2hrs a day, Twice a week
Course Duration: 16 hrs

Course Outline:

• 1- Querying Microsoft SQL Server 2012 with T-SQL
• 2- Creating and Altering Tables and Viewes with T-SQL
• 3- Designing Views, with permissions, new user, new schema
• 4- Creating and Modiifying Contraints and DML Triggers
• 5- Querying Data using Select
• 6- Implementing Sub Queries
• 7- Implementing Data Types
• 8- Implementing Aggregates
• 9- Querying and Managing XML Data
• 10- Creating and Altering Stored Procedures
• 11- Modifying Data with T-SQL
• 12- Combining Datasets
• 13- Working with Functions/li>
• 14- Optimizing Queries
• 15- Managing Transactions
• 16- Row-based vs Set-based Operations, Implementing Error Handling