Managing SQL Server Data using T-SQL and Stored Procedures

Register Login

Friday, May 18, 2012

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos Managing SQL Server Data

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

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

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.

Privacy Statement

Terms Of Use