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.
OA
It's a very good course. However, it's isn't well explanatory. It is not a beginners course, rather an intermediate course. Anyways, Kudos to the Microsoft Team for this masterpiece.
EK
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.
Showing: 15 of 15
Disappointing to get this far into the course and then find that I need to pay a subscription to another website to be able to install a 'Windows Virtual Machine' or else most of the activities can't be completed.
dislike talking to an ai assistant after every assessment
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.
The course was great and informative.
Excellent material, work fine
Best SQL course ever!
Very well done.
Good course
Lab issues
ok
After finishing Course 2, it says when clicking the Enroll button on Course 3, "Coming soon! Your course is not live yet - but you’ll be notified at [email address] when your session is open for enrollment!"
It's a very good course. However, it's isn't well explanatory. It is not a beginners course, rather an intermediate course. Anyways, Kudos to the Microsoft Team for this masterpiece.
I understand the importance of learning about AI tools, however, I felt the AI was thrown in way to early for this certificate. I want to be able to understand the manual fundamentals of using SQL before having AI tools thrown at me. I felt parts of this course were confusing because I was unsure if the AI recommendation were actually helpful. I wanted a better understanding of SQL so I could be more discerning when using the AI tools later on.
This course does not have very good teaching, sometimes they bring some brand new code and doesn't explain anything. Sometimes the test result bring some arguments. But on the bright side, it does bring a lot about ACID, Transaction and Isolation. Kinda informative for those fresh in SQL Server.
The TechHealthDb no longer exists from when this class was created