Writing Queries Using Microsoft SQL Server Transact-SQL

Course details

About this Course This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.

Objectives

At Course Completion

After completing this course, students will be able to:

• Describe the uses of and ways to execute the Transact-SQL language.
• Use querying tool.
• Write SELECT queries to retrieve data.
• Group and summarize data by using Transact-SQL.
• Join data from multiple tables.
• Write queries that retrieve and modify data by using subqueries.
• Modify data in tables.
• Query text fields with full-text search.
• Describe how to create programming objects.
• Use various techniques when working with complex queries.

Prerequisites

• Knowledge of data integrity concepts.
• Core Windows Server skills.
• Relational database design skills.
• Programming skills.

Module

• Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
• Module 2: Querying and Filtering Data
• Module 3: Grouping and Summarizing Data
• Module 4: Joining Data from Multiple Tables
• Module 5: Working with Subqueries
• Module 6: Modifying Data in Tables
• Module 7: Querying Metadata, XML, and Full-Text Indexes
• Module 8: Using Programming Objects for Data Retrieval
• Module 9: Using Advanced Querying Techniques