Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Creating Highly Concurrent SQL Server Applications

When talking about concurrent applications, you think of the physical integrity of data for every transaction. How does a database system enable concurrent accessing of the same database, table, and records? The locking mechanism ensures that the data is consistent and still available for concurrent processing. We cover topics on locking mechanisms, isolation levels, and transactions with paried demos and knowledge checks that offer a real world look and tests the concepts that are discussed.

Description

When you talk about concurrent applications, you think of the physical integrity of data for every transaction. How does a database system enable concurrent accessing of the same database, table, and records? The locking mechanism ensures that the data is consistent and still available for concurrent processing.
In this "Creating Highly Concurrent SQL Server Applications" LearnSmart course, we will cover topics on locking mechanisms, isolation levels, and transactions. This course is be paired with demos that offer a real world look at the concepts that will be discussed, as well as knowledge check at the end of each chapter to help you test your understanding of the concepts that we will be discussing.


Topics Covered Include:
-Role of Transactions
-Locking
-Transaction Isolation Levels

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Creating Highly Concurrent SQL Server Applications: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Creating Highly Concurrent SQL Server Applications"" Course."
  • Role of Transactions
    Introduction
    2:11
    Transactions
    3:54
    Autocommit Transactions
    2:33
    Explicit Transactions
    2:16
    Implicit Transactions
    1:16
    SHOW ME Demonstration: Working with Transactions
    2:16
    Transaction Recovery
    4:45
    Considerations for Transactions
    3:07
    Knowledge Check
    0:36
  • Locking
    Locks Introduction
    2:16
    Concurrency Problems
    3:48
    Locks in SQL Server
    1:23
    Types of Locks
    3:15
    SHOW ME Demonstration: Viewing Locking Information
    2:30
    Management of Locking
    2:20
    Viewing Locking Information
    1:07
    Deadlocks
    2:07
    Knowledge Check
    0:34
  • Transaction Isolation Levels
    Isolation Levels
    3:53
    Read Committed Snapshot
    0:55
    Knowledge Check
    0:32
    Conclusion
    1:39

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor