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

本课程是 Microsoft Data Analysis with SQL, Excel & Power BI 专项课程的一部分

位教师： Microsoft

包含在中

了解更多

4个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

4个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

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

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

本课程是 Microsoft Data Analysis with SQL, Excel & Power BI 专项课程专项课程的一部分

在注册此课程时，您还会同时注册此专项课程。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有4个模块

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.

涵盖的内容

8个视频11篇阅读材料4个作业

8个视频总计34分钟

Data Manipulation and Transactions in SQL Server2分钟
The Significance of SQL Server in Managing Data2分钟
Installing and Setting Up SQL Server and SSMS7分钟
Transitioning from SQL to T-SQL2分钟
Demo on Basic T-SQL Commands5分钟
The Role of DML in Managing Data2分钟
Creating a Database and Inserting Data8分钟
Modify and Retrieve Data in SQL Server using SSMS7分钟

11篇阅读材料总计110分钟

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

4个作业总计120分钟

Understanding DML Operations in SQL Server 30分钟
Basics of SQL Server and SSMS30分钟
Understanding T-SQL Basics30分钟
Understanding Database Creation and DML Concepts30分钟

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.

涵盖的内容

4个视频8篇阅读材料3个作业

4个视频总计23分钟

Ensuring Data Integrity2分钟
Starting and Testing Transactions in SSMS7分钟
Implementing Transaction Control in SQL Server6分钟
Implementing ACID Compliant Transactions in SSMS9分钟

8篇阅读材料总计80分钟

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

3个作业总计90分钟

ACID Properties in SQL Transactions30分钟
Fundamentals of Transactions30分钟
Transaction Handling in SQL Server30分钟

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.

涵盖的内容

4个视频6篇阅读材料3个作业

4个视频总计27分钟

Addressing Concurrency in Data Management1分钟
Simulating and Observing Concurrency Issues9分钟
Implementing Isolation Levels7分钟
Detecting and Resolving Deadlocks and Blocking Transactions9分钟

6篇阅读材料总计60分钟

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

3个作业总计75分钟

Addressing Concurrency Conflicts15分钟
Understanding Concurrency Concepts30分钟
Isolation Levels and their Effects30分钟

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.