Microsoft Training Courses - Microsoft SQL Training

Introduction

During this course, candidates will learn the skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Pre-Requisites

Prior to attending this course, candidates are recommended to have Windows server skills, programming skills, database design skills and an understanding of data integrity concepts.

Who Should Attend

This course is for database administrators, developer and engineers who are responsible for query writing.

Course Objectives

Upon completion of this course, candidates should gain knowledge on:

• Using SQL Server Management Studio and SQLCMD
• Creating reports
• NULL values and SELECT statements
• Working with grouped data
• Combining results sets
• Writing basic and correlated subqueries
• Common table expressions
• Writing joins for multiple tables
• Inserting, modifying and deleting data in tables
• Working with transactions
• Querying metadata, XML data and full-text indexes
• Distributed queries
• Triggers and user-defined functions
• Creating a hierarchy
• Using set-based queries and different data types
• Execution plans

Course Outline

The units in this course include:

• Introduction to Databases and Transact-SQL in SQL Server 2008
• Querying Metadata, XML, and Full-Text Indexes
• Using Programming Objects for Data Retrieval
• Filtering & Querying Data
• Summarising & Grouping Data
• Joining Data from Multiple Tables
• Modifying Data in Tables
• Advanced Querying Techniques
• Subqueries