Transaction Management in SQL Server and C#
What you'll learn
- Build consistent database applications in C# and SQL Server
- Manage SQL transactions on the database
- Ensure the data integrity of the database
- Handle database errors and exceptions in C# and SQL Server
- Create SQL Server database, tables and stored procedures and connect with C# applications
- Understand the importance of transaction management
Course content
- Preview08:36
- 11:37Schedules and Serializablility
- 10:50Concurrency Control
- 06:37Deadlock
- 09:15Crash Recovery
- 04:54Transaction Support in SQL
- 10 questionsQuiz
Requirements
- Be familiar with SQL
- Be familiar with C#
Description
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program.
A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing a transaction on that table. It is important to control these transactions to ensure the data integrity and to handle database errors.
In this course, we are going to dive deeply into transaction control mechanism.
You will learn everything you need to build your concrete and consistent database applications using C# and SQL Server.
Who this course is for:
- Developers who want to build application when transaction management is critical
- Developers who want to ensure the data integrity of the database and to handle database errors
- Developers who is curious about diving deeply into transaction control mechanism
- Developers who are curious about connecting SQL Server database with C# applications
- Developers who are curious about stored procedures in SQL Server database engine
Instructor
![Husam Nujaim](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 61 Reviews
- 1,645 Students
- 3 Courses
I am a computer programmer, 3D designer and games developer. I have a bachelor degree in Information Technology. Moreover, I have concrete work experience in IT industries. I have done many IT projects that apply software engineering principles and artificial intelligence such as: Face Recognition System, Image Processing, Intelligent Remoting System, Distributed Accounting Systems and many 3D games using Unity3D game engine such as Infinite Runner game and RPG games. What's more, I have been teaching programming languages for 3 years. I am the founder of SimpleSoft company, providing software solutions and IT assistance to customers.