Friday, May 18, 2012
 Managing Data using DML

Managing Data Using DML

In this module, you will learn the following:

  • Introduce database components involved in data access
  • Introduce concepts of Transact -SQL and Procedural SQL as tools to access and manipulate data
  • Discuss transactional management concepts
 Profiler and Execution Plan

Profiler and Execution Plan

In this demonstration you will see how to:

  • Provide tracing within SQL Server
  • Review the execution plan for simple queries
  • Compare execution plan to the trace profiler
  • Review execution plan
 Working with DML Statements

Working with DML Statements

In this demonstration you will see how to:

  • Generate a query
  • Declare and use variables and row constructors
  • Aggregate summary data 
  
Managing SQL Server 2008 Data using DML and using SQL Server Profiler and Execution Plans

In this module you will be introduced to database components involved in data access and the concepts of Transact -SQL and Procedural SQL as tools to access and manipulate data, and transactional management concepts will be discussed.

HOME   |   Automation   |   Scripts & Tools   |   Article Library   |   Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM