Home » Training Courses » Microsoft Certified Training » 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

• Book this course
• Email to a friend
• Download PDF

Course code: 2778

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

Course Objectives:

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.

Course Content

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

Course Pre-requisites:

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

Before attending this course, students must have:

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

 

SQL Server 2005 Database Training Courses Recommended Reading

SQL Server 2005 Database Essentials Step by Step by Solid Quality Learning - buy from amazon

For full course content and pre-requisites download the 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Course PDF

Share This

Silicon Beach Training

See independent Google Places, Free Index and Qype reviews.