Transactions

SQL Server 2016
  • 12 Videos | 1h 4m
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
SQL Server transactions allow you to group together a number of statements to form a single logical unit of work. Explore the various types of transactions, and discover how to implement them in SQL Server 2016.

WHAT YOU WILL LEARN

  • recognize when to use transactions
    demonstrate how to use the BEGIN TRANSACTION statement
    use the COMMIT TRANSACTION to mark the end of a successful implicit or explicit transaction
    use the COMMIT WORK statement to mark the end of a transaction
    use the ROLLBACK TRANSACTION to roll back an explicit or implicit transaction
    use the ROLLBACK WORK statement to roll back a user-specified transaction
  • use the SAVE TRANSACTION statement to set a savepoint within a transaction
    identify DML statement results based on transaction behavior
    determine the role of transactions in high-concurrency SQL Server 2016 databases
    describe explicit transactions
    describe implicit transactions
    describe snapshot isolation and row versioning

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 39 Likes 39  
Likes 8 Likes 8  
Likes 32 Likes 32  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 61 Likes 61  
Likes 34 Likes 34