Do I need prior database experience for Data Manipulation and Transactions in SQL Server?

A basic understanding of SQL queries is recommended. The course builds on foundational SQL concepts and introduces transaction management and data modification techniques step-by-step.

What database skills will I learn in this course?

You’ll learn how to use INSERT, UPDATE, and DELETE statements, manage transactions, apply ACID principles, handle errors, and maintain database consistency in SQL Server.

How does generative AI support SQL development in this course?

The course demonstrates how generative AI tools can help optimize SQL operations, troubleshoot transaction issues, and improve productivity when working with database tasks.

When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Data Manipulation and Transactions in SQL Server

This course is part of Microsoft Data Analysis with SQL, Excel & Power BI Specialization

Instructor: Microsoft

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate 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.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Use INSERT, UPDATE, and DELETE statements to modify and manage data in SQL Server databases
Implement transaction management techniques to maintain database consistency and integrity
Apply ACID principles, isolation levels, and error handling strategies to prevent concurrency issues
Use generative AI tools to optimize SQL operations and troubleshoot transaction-related problems

Details to know

Shareable certificate

Add to your LinkedIn profile

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 subject-matter expertise

This course is part of the Microsoft Data Analysis with SQL, Excel & Power BI Specialization

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

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

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.

Module details

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 videosTotal 34 minutes

Data Manipulation and Transactions in SQL Server2 minutes
The Significance of SQL Server in Managing Data2 minutes
Installing and Setting Up SQL Server and SSMS7 minutes
Transitioning from SQL to T-SQL2 minutes
Demo on Basic T-SQL Commands5 minutes
The Role of DML in Managing Data2 minutes
Creating a Database and Inserting Data8 minutes
Modify and Retrieve Data in SQL Server using SSMS7 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

Basics of SQL Server and SSMS30 minutes
Understanding T-SQL Basics30 minutes
Understanding Database Creation and DML Concepts30 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 videosTotal 23 minutes

Ensuring Data Integrity2 minutes
Starting and Testing Transactions in SSMS7 minutes
Implementing Transaction Control in SQL Server6 minutes
Implementing ACID Compliant Transactions in SSMS9 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

Fundamentals of Transactions30 minutes
Transaction Handling in SQL Server30 minutes
ACID Properties in SQL Transactions30 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 videosTotal 27 minutes

Addressing Concurrency in Data Management1 minute
Simulating and Observing Concurrency Issues9 minutes
Implementing Isolation Levels7 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 75 minutes

Understanding Concurrency Concepts30 minutes
Isolation Levels and their Effects30 minutes
Addressing Concurrency Conflicts15 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.