Retrieving Data and Running Queries in SQL Server 2005

This course is included in our On-demand training solution.

Overview

To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others

Prerequisites

This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

180 min.

Course Objectives

Retrieving Data and Running Queries in SQL Server 2005

  • retrieve data from a database in a given scenario.
  • modify data from a relational database in a given scenario.
  • use queries to retrieve and modify data in a SQL Server database.
  • retrieve, insert, and convert XML data in SQL Server 2005.
  • create and secure an HTTP endpoint in a given scenario.
  • work with XML data in SQL Server 2005.
  • create and modify an assembly in a given scenario.
  • control SQL Server transactions in a given scenario.
  • manage transactions in SQL Server 2005.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?