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.
Data Manipulation and Transactions in SQL Server
本课程是 Microsoft SQL Server 专业证书 的一部分
位教师： Microsoft
2,201 人已注册
包含在 
中
您将获得的技能
要了解的详细信息
添加到您的领英档案
June 2025
13 项作业
了解顶级公司的员工如何掌握热门技能
积累 Data Analysis 领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Microsoft 获得可共享的职业证书
该课程共有4个模块
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个作业5个插件
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个作业3个插件
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个作业3个插件
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.
涵盖的内容
5个视频6篇阅读材料3个作业2个非评分实验室3个插件
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
从 Data Analysis 浏览更多内容
Coursera Project Network
状态：免费试用Fractal Analytics
状态：免费试用University of Colorado Boulder
人们为什么选择 Coursera 来帮助自己实现职业发展
学生评论
23 条评论
- 5 stars
65.21%
- 4 stars
13.04%
- 3 stars
13.04%
- 2 stars
4.34%
- 1 star
4.34%
显示 3/23 个
已于 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.
常见问题
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.
When you enroll in the course, you get access to all of the courses in the Certificate, 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.
更多问题
提供助学金，