Follow Us :

MS2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Course_Reference: 
2778
PreRequisites: 

Before attending this course, students must have:

  • Knowledge of data and intergrity concepts.
  • Core Windows Server skills.
  • Relational database design skills.
  • Programming skills.
Audience: 

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. 

Objectives: 

After completing this course you should 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 summarise 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.

Module 1: Getting Started with Databases and Transact-SQL in SQLServer 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
 

 

Description: 

This 3-day instructor led course provides students wuth the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Additions Info: 
Encrypted pdf

Software Vendor

IT Technical

Business Skills