Course Details
Writing Queries Using Microsoft SQL Server 2008 Transact
  • Course Length: 2 days
  • Course Price: $0
  • Code: 2778
  • Course Mode: ILT
  • Location Date Time
    Brookfield, WI 2012-06-04 09:00:00
    Brookfield, WI 2012-09-05 09:00:00
    Appleton, WI 2012-07-16 09:00:00
    Appleton, WI 2012-10-29 09:00:00
Prerequisite
Knowledge of data integrity concepts. Core Windows Server skills. Relational database design skills. Programming skills.

In this collection of nine 2-hour courses students will be able to query and modify data in Microsoft SQL Server 2008 using Transact-SQL. Topics covered in the courses within the collection include: Introduction to Transact-SQL in Microsoft SQL Server 2008 Querying and Filtering Data in Microsoft SQL Server 2008 Grouping and Summarizing Data in Microsoft SQL Server 2008 Joining Data from Multiple Tables in Microsoft SQL Server 2008 Modifying Data in Tables in Microsoft SQL Server 2008 Querying XML and Full-Text Indexes in Microsoft SQL Server 2008 Querying Metadata in Microsoft SQL Server 2008 This course also helps prepare you for exam: 70-432: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

  • 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.