Wednesday, April 23, 2014
 
  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   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM