Course MS E2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Imprimer Retour

Goal

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. This Writing Queries Using Microsoft SQL Server 2008 Transact-SQL course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Prerequisites

Before attending this course, students must have:

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

Content

  • Getting Started with Databases and Transact-SQL in SQL Server 2008
  • Querying and Filtering Data
  • Grouping and Summarizing Data
  • Joining Data from Multiple Tables
  • Working with Subqueries
  • Modifying Data in Tables
  • Querying Metadata, XML, and Full-Text Indexes
  • Using Programming Objects for Data Retrieval
  • Using Advanced Querying Techniques

Course Language

FR

Course material

  • Official Microsoft MS 2778 Coursebook

Duration

3 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.