Providing Technology Training and Mentoring For Modern Technology Adoption
This instructor-led course provides students with the necessary knowledge to work with the data in SQL Server 2008R2. They will learn how to use the built in tools included with SQL Serverto construct queries, do tuning,analyze a query and it’s performance along with how to modify existing data, perform joins, create indexes and work with XML.The new features are discussed and their impact is explained.
After completing this course, students will be able to:
This course is intended for Power Users and IT Professionals that are called on to work with SQL Server in the retrieving, or modifying of data and need a good foundation to perform those functions. This would include those users that develop reports and need to create Data Sets that work efficiently.
Before attending this course, students should have:
Lab : The Toolsets
Lab : Data Types and New T-SQL Language Features
Lab : Single Table Queries
Lab : Joining Multiple Tables
Lab : Subqueries, Common Table Expressions and Ranking Functions
Lab : Indexing
Lab : Query Tuning
Lab : Data Modification, Transactions and Error Processing
Lab : Stored Procedures and Triggers