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.

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

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

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

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

Advanced Transaction Management1 minute
Implementing Advanced Techniques5 minutes
Transforming Transaction Management with AI2 minutes
Implementing AI-Driven Transaction Enhancements6 minutes
AI-Assisted Transaction Analysis and Optimization8 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

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

Microsoft

307 Courses2,546,936 learners

Offered by

Microsoft

Explore more from Data Analysis

Microsoft
Advanced Data Analysis & Visualization with Copilot in Excel
Course
Microsoft
Data Cleaning & Processing with Copilot in Excel
Course
Microsoft
Data Analysis and Visualization with Power BI
Course
Microsoft
SQL Foundations
Course

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

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

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.

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.

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

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.