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

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Data Manipulation and Transactions in SQL Server

Ce cours fait partie de Spécialisation "Microsoft Data Analysis with SQL, Excel & Power BI"

Instructeur : Microsoft

Inclus avec

4 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

4 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

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

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

mai 2026

Évaluations

13 devoirs

Enseigné en Anglais

91% of learners achieved a positive career outcome

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation "Microsoft Data Analysis with SQL, Excel & Power BI"

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 4 modules dans ce cours

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.

Détails du module

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.

Inclus

8 vidéos11 lectures4 devoirs

8 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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.

Inclus

4 vidéos8 lectures3 devoirs

4 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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.

Inclus

4 vidéos6 lectures3 devoirs

4 vidéosTotal 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 lecturesTotal 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 devoirsTotal 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.

Inclus

5 vidéos6 lectures3 devoirs2 laboratoires non notés

5 vidéosTotal 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 lecturesTotal 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 devoirsTotal 90 minutes

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

2 laboratoires non notésTotal 120 minutes

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

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.