Course 10368: Managing and Monitoring Transactions in Microsoft SQL Server 2008 R2

Product type
Logo Microsoft Learning

Need more information? Get more details on the site of the provider.

Description

Introduction This two-hour course provides you with the knowledge and skills required to manage and monitor transactions in Microsoft SQL Server 2008 R2.

This course covers the following topics.
  • Describing transactions and lock
  • Managing transactions
  • Managing locks
  • Monitoring transaction and locks
  • Best practices for managing and monitoring transactions in Microsoft SQL Server 2008 R2

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
  • A good general knowledge of database concepts.
  • Experience working with Windows and programming concepts.
  • Understanding of server management concepts such as roles…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Introduction This two-hour course provides you with the knowledge and skills required to manage and monitor transactions in Microsoft SQL Server 2008 R2.

This course covers the following topics.
  • Describing transactions and lock
  • Managing transactions
  • Managing locks
  • Monitoring transaction and locks
  • Best practices for managing and monitoring transactions in Microsoft SQL Server 2008 R2

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
  • A good general knowledge of database concepts.
  • Experience working with Windows and programming concepts.
  • Understanding of server management concepts such as roles and tracing.
  • A basic understanding of XML.
Objectives At the end of the course, students will be able to:
  • Describe transactions and lock.
  • Manage transactions.
  • Manage locks.
  • Monitoring transaction and locks.
  • Describe best practices for managing and monitoring transactions in Microsoft SQL Server 2008 R2.
Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Managing and Monitoring Transactions in Microsoft SQL Server 2008 R2 Module Overview Introducing Transactions and Locks Introducing Transactions and Locks Introduction to Transactions Transaction ACID Properties How SQL Server Modifies Data in a Table What is Locking? Self Test Managing Transactions Managing Transactions Transaction Execution Modes Autocommit Transaction Mode Explicit Transaction Mode Implicit Transaction Mode Transaction Guidelines Self Test Managing Locks Managing Locks Database Concurrency Problems Lockable Resources Types of Locks Lock Compatibility Transaction Isolation Levels Query Hints and Plan Guides Self Test Monitoring Transactions and Locks Monitoring Transactions and Locks Activity Monitor Execution Plans Dynamic Management Views SQL Server Profiler Using Reliability and Performance Monitor Self Test Best Practices Best Practices Lab: Managing and Monitoring Transactions in Microsoft SQL Server 2008 R2 Lab: Managing and Monitoring Transactions in Microsoft SQL Server 2008 R2 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:
  • A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
  • Microsoft® Windows® 2000 or higher
  • Microsoft Internet Explorer 6.0 or higher
  • Adobe Flash 7.0 or higher (1MB disk space needed to install)
  • Microsoft Silverlight 4.0 or higher
  • Microsoft Windows Media Player 7.0 or higher
  • Microsoft XML Core Services 3.0 or higher
  • A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
  • A sound card, and either speakers or headphones (for multi-media audio).
  • Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
  • Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:
  • Microsoft Internet Explorer 6.0 or higher
  • Window-Eyes from GW Micro
  • JAWS from Freedom Scientific
  • MSAA enabled
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.