Data Manipulation and Transactions in SQL Server

This course is part of Microsoft SQL Server Professional Certificate

Instructor: Microsoft

Access provided by EMAAR MISR

2,920 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.3

(25 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.

4.3

(25 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

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 assignments5 plugins

8 videosTotal 33 minutes

Data Manipulation and Transactions in SQL Server2 minutes
The Significance of SQL Server in Managing Data1 minute
Installing and Setting Up SQL Server and SSMS6 minutes
Transitioning from SQL to T-SQL1 minute
Demo on Basic T-SQL Commands5 minutes
The Role of DML in Managing Data1 minute
Creating a Database and Inserting Data7 minutes
Modify and Retrieve Data in SQL Server using SSMS6 minutes

11 readingsTotal 110 minutes

Course Structure and Learning Outcomes10 minutes
Course Accessibility Information10 minutes
Overview of SQL Server and SSMS10 minutes
Setting up SQL Server and SSMS10 minutes
Connecting and Exploring the SSMS User Interface10 minutes
Overview of T-SQL Syntax and Commands10 minutes
Practice Basic T-SQL Commands10 minutes
Overview of SQL DML Operations10 minutes
Practicing Creating a Database and Populating it with TechHealth Data10 minutes
Executing DML Commands in SSMS10 minutes
Writing and Executing UPDATE, DELETE, and SELECT Queries in SQL Server10 minutes

4 assignmentsTotal 120 minutes

Understanding DML Operations in SQL Server30 minutes
Basics of SQL Server and SSMS30 minutes
Understanding T-SQL Basics30 minutes
Understanding Database Creation and DML Concepts30 minutes

5 pluginsTotal 75 minutes

Set Your Learning Goals15 minutes
Discussing SQL Server Applications in Real-World Scenarios15 minutes
Discuss Your Experience with T-SQL15 minutes
Discussing DML in a Business Context15 minutes
Reflecting on DML Execution Benefits15 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 assignments3 plugins

4 videosTotal 23 minutes

Ensuring Data Integrity1 minute
Starting and Testing Transactions in SSMS7 minutes
Implementing Transaction Control in SQL Server5 minutes
Implementing ACID Compliant Transactions in SSMS8 minutes

8 readingsTotal 80 minutes

Introductions to Transactions and ACID Properties10 minutes
Writing and Running Basic Transactions in SSMS10 minutes
SQL Server Transaction Management Techniques in SSMS10 minutes
Screencast Code File: Order Processing Database10 minutes
Managing Transaction and Handling Errors at TechHealth10 minutes
Ensuring ACID Compliance in SQL Server using SSMS10 minutes
Screencast Code File: Bank Demo Database10 minutes
Design ACID-Compliant Transactions in SSMS10 minutes

3 assignmentsTotal 90 minutes

ACID Properties in SQL Transactions30 minutes
Fundamentals of Transactions30 minutes
Transaction Handling in SQL Server30 minutes

3 pluginsTotal 45 minutes

Analyzing Business Scenarios for Transactions15 minutes
Best Practices in Transaction Management15 minutes
Discussing ACID Compliance in Real-World Data Scenarios15 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 assignments3 plugins

4 videosTotal 27 minutes

Addressing Concurrency in Data Management1 minute
Simulating and Observing Concurrency Issues9 minutes
Implementing Isolation Levels6 minutes
Detecting and Resolving Deadlocks and Blocking Transactions9 minutes

6 readingsTotal 60 minutes

Basics of Concurrency in SQL Server10 minutes
Simulating Concurrent User Scenarios10 minutes
Understanding Isolation Levels and their Role in SQL Server Transactions10 minutes
Testing Isolation Levels to Prevent Concurrency Issues10 minutes
Managing Concurrency Conflicts10 minutes
Simulating and Resolving Concurrency Conflicts10 minutes

3 assignmentsTotal 90 minutes

Addressing Concurrency Conflicts30 minutes
Understanding Concurrency Concepts30 minutes
Isolation Levels and their Effects30 minutes

3 pluginsTotal 45 minutes

Exploring Concurrency in TechHealth's Context15 minutes
Choosing the Right Isolation Level for Business Needs15 minutes
Reflecting on Concurrency Management Practices15 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 labs3 plugins

5 videosTotal 21 minutes

Advanced Transaction Management1 minute
Implementing Advanced Techniques4 minutes
Transforming Transaction Management with AI1 minute
Implementing AI-Driven Transaction Enhancements6 minutes
AI-Assisted Transaction Analysis and Optimization7 minutes

6 readingsTotal 60 minutes

Advanced SQL Server Transaction Techniques10 minutes
Designing and Testing Advanced Transactions10 minutes
Integrating GenAI into SQL Transactions10 minutes
Accessing GitHub for Copilot10 minutes
Evaluating and Optimizing SQL Transaction Scenarios10 minutes
Wrapping Up and Looking Ahead10 minutes

3 assignmentsTotal 90 minutes

Evaluating Transaction Effectiveness30 minutes
Advanced Transaction Handling30 minutes
GenAI and Transaction Optimization30 minutes

2 ungraded labsTotal 120 minutes

Applying GenAI to Simplify Transaction Logic60 minutes
Diagnosing and Optimizing Complex Transactions Using AI Support60 minutes

3 pluginsTotal 45 minutes

Exploring Advanced Transaction Scenarios15 minutes
Forecasting AI-Driven Transaction Strategies15 minutes
Breaking Down Transaction Complexity15 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

4.3 (7 ratings)

Microsoft

239 Courses2,006,470 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

4.3

25 reviews

5 stars
60%
4 stars
20%
3 stars
12%
2 stars
4%
1 star
4%

Showing 3 of 25

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.

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.

View more reviews