Data Manipulation and Transactions in SQL Server

This course is part of Microsoft SQL Server Professional Certificate

Instructor: Microsoft

Access provided by Willis Towers Watson

5,291 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

34 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

34 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

13 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the Microsoft SQL Server Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 4 modules in this course

Build on your foundational SQL knowledge by learning data manipulation techniques in SQL Server. This course focuses on using INSERT, UPDATE, and DELETE statements to modify database contents while maintaining data integrity through proper transaction management. You'll learn to implement transaction control mechanisms, understand isolation levels, and prevent common concurrency issues. Through practical examples, you'll implement error handling strategies and explore the principles of ACID compliance essential for reliable database operations. The course also demonstrates how generative AI can help optimize complex SQL operations and troubleshoot transaction issues. By the end, you'll confidently perform data modifications while ensuring database consistency—crucial skills for any database professional.

This module will introduce you to the fundamental principles of SQL Server, a critical tool in relational database management. It will guide you through the installation and setup of SQL Server and SSMS, allowing you to create databases and execute basic Data Manipulation Language (DML) operations such as CREATE, INSERT, UPDATE, and DELETE. You will develop the skills necessary to interact with and manipulate TechHealth Analytics' datasets using T-SQL, gaining a solid foundation in database management.

What's included

8 videos11 readings4 assignments

8 videos Total 34 minutes

Data Manipulation and Transactions in SQL Server 2 minutes
The Significance of SQL Server in Managing Data 2 minutes
Installing and Setting Up SQL Server and SSMS 7 minutes
Transitioning from SQL to T-SQL 2 minutes
Demo on Basic T-SQL Commands 5 minutes
The Role of DML in Managing Data 2 minutes
Creating a Database and Inserting Data 8 minutes
Modify and Retrieve Data in SQL Server using SSMS 7 minutes

11 readings Total 110 minutes

Course Structure and Learning Outcomes 10 minutes
Course Accessibility Information 10 minutes
Overview of SQL Server and SSMS 10 minutes
Setting up SQL Server and SSMS 10 minutes
Connecting and Exploring the SSMS User Interface 10 minutes
Overview of T-SQL Syntax and Commands 10 minutes
Practice Basic T-SQL Commands 10 minutes
Overview of SQL DML Operations 10 minutes
Practicing Creating a Database and Populating it with TechHealth Data 10 minutes
Executing DML Commands in SSMS 10 minutes
Writing and Executing UPDATE, DELETE, and SELECT Queries in SQL Server 10 minutes

4 assignments Total 120 minutes

Basics of SQL Server and SSMS 30 minutes
Understanding T-SQL Basics 30 minutes
Understanding Database Creation and DML Concepts 30 minutes
Understanding DML Operations in SQL Server 30 minutes

This module will instruct you on maintaining data consistency and integrity through transaction management in SQL Server. You will understand ACID properties and implement transaction control statements to ensure data reliability and performance, particularly within TechHealth's systems.

What's included

4 videos8 readings3 assignments

4 videos Total 23 minutes

Ensuring Data Integrity 2 minutes
Starting and Testing Transactions in SSMS 7 minutes
Implementing Transaction Control in SQL Server 6 minutes
Implementing ACID Compliant Transactions in SSMS 9 minutes

8 readings Total 80 minutes

Introductions to Transactions and ACID Properties 10 minutes
Writing and Running Basic Transactions in SSMS 10 minutes
SQL Server Transaction Management Techniques in SSMS 10 minutes
Screencast Code File: Order Processing Database 10 minutes
Managing Transaction and Handling Errors at TechHealth 10 minutes
Ensuring ACID Compliance in SQL Server using SSMS 10 minutes
Screencast Code File: Bank Demo Database 10 minutes
Design ACID-Compliant Transactions in SSMS 10 minutes

3 assignments Total 90 minutes

Fundamentals of Transactions 30 minutes
Transaction Handling in SQL Server 30 minutes
ACID Properties in SQL Transactions 30 minutes

You will analyze concurrency challenges in multi-user environments, distinguish between isolation levels and their impact on data access, and implement appropriate isolation strategies to avoid conflicts. This module prepares you to handle concurrency management techniques within TechHealth’s database system.

What's included

4 videos6 readings3 assignments

4 videos Total 27 minutes

Addressing Concurrency in Data Management 1 minute
Simulating and Observing Concurrency Issues 9 minutes
Implementing Isolation Levels 7 minutes
Detecting and Resolving Deadlocks and Blocking Transactions 9 minutes

6 readings Total 60 minutes

Basics of Concurrency in SQL Server 10 minutes
Simulating Concurrent User Scenarios 10 minutes
Understanding Isolation Levels and their Role in SQL Server Transactions 10 minutes
Testing Isolation Levels to Prevent Concurrency Issues 10 minutes
Managing Concurrency Conflicts 10 minutes
Simulating and Resolving Concurrency Conflicts 10 minutes

3 assignments Total 90 minutes

Understanding Concurrency Concepts 30 minutes
Isolation Levels and their Effects 30 minutes
Addressing Concurrency Conflicts 30 minutes

You will dive into advanced transaction techniques and how Generative AI (GenAI) can automate, simplify, and enhance transaction logic, optimizing SQL Server workflows for improved performance and decision-making within TechHealth Analytics.

What's included

5 videos6 readings3 assignments2 ungraded labs

5 videos Total 22 minutes

Advanced Transaction Management 1 minute
Implementing Advanced Techniques 5 minutes
Transforming Transaction Management with AI 2 minutes
Implementing AI-Driven Transaction Enhancements 6 minutes
AI-Assisted Transaction Analysis and Optimization 8 minutes

6 readings Total 60 minutes

Advanced SQL Server Transaction Techniques 10 minutes
Designing and Testing Advanced Transactions 10 minutes
Integrating GenAI into SQL Transactions 10 minutes
Accessing GitHub for Copilot 10 minutes
Evaluating and Optimizing SQL Transaction Scenarios 10 minutes
Wrapping Up and Looking Ahead 10 minutes

3 assignments Total 90 minutes

Advanced Transaction Handling 30 minutes
GenAI and Transaction Optimization 30 minutes
Evaluating Transaction Effectiveness 30 minutes

2 ungraded labs Total 120 minutes

Applying GenAI to Simplify Transaction Logic 60 minutes
Diagnosing and Optimizing Complex Transactions Using AI Support 60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(9 ratings)

Microsoft

287 Courses 2,317,051 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
65.71%
4 stars
17.14%
3 stars
8.57%
2 stars
2.85%
1 star
5.71%

Showing 3 of 34

Reviewed on Sep 11, 2025

This is another very well structured course. The course material is very insightful, this course has allowed me to use a new perspective on my existing work and improve my productivity.

Reviewed on Oct 18, 2025

It's a very good course. However, it's isn't well explanatory. It is not a beginners course, rather an intermediate course. Anyways, Kudos to the Microsoft Team for this masterpiece.

View more reviews