This course explains the different ways to recover lost data from our databases. This course allows you to learn step by step procedure to track the data which can be easily understandable to anyone who have basic knowledge on database concepts. I have also provided much bonus content at the end of this course to learn more and practice.
The Topics which I discussed in this course are a bit high level and Admin level activities. But don't worry. It does not matter whether you are beginner or expert. It is very user friendly. This course is well planned and designed to allow all the levels of database folks very easily and quickly.
I have made this course with many features like, quizzes, coding exercises, bonus content etc... Most importantly I have published a complete reference hand book for your reference.
I hope this course helps you...
Note: This course is the Part 1 of my module 'Database recovery techniques'. I am going to publish the part II soon...
Enjoy the course & ALL THE BEST
This session gives the overview of Change Tracking mechanism.
Setup the data required for Change Tracking demonstration.
This session demonstrates how to Enable Change Tracking on both database and table.
Apply few DML operations on the table which will be tracked by CT.
This session Introduces the functions used in tracking the data with Change Tracking.
Introduces the way to fetch the detail data modified.
Discusses the Drawbacks identified in change tracking.
Disable Change Tracking on Table and database as well.
This session summarizes the topics which we discussed in change tracking mechanism.
This Quiz tests your knowledge on Change Tracking Mechanism.
Discusses the drawbacks identified in change tracking and also discusses the mitigation techniques to avoid them.
What is change data capture concept?
Setup and Modify the data in table which has to be captured using CDC.
Demonstrates the process of enabling change data capture on the database.
Discusses the default objects created once CDC is enabled on database.
Discusses the the way to enable CDC on the table.
Do some DML operations on the table and capture the data.
Disables CDC on table and database as well.
This session discusses the CDC mechanism in short.
This Quiz tests your knowledge on Change Data Capture Mechanism.
This session discusses the similarities and differences between CT & CDC.
A Quiz on Differences between CT & CDC.
CT Coding Challenge.
CDC Coding Challenge.
This session explains answers to the quiz given under Change Tracking section.
This session explains answers to the quiz given under Change Data Capture section.
This session explains answers to the quiz given under Comparison section.
This session explains the solution for the CT coding challenge.
This session explains the solution for the CDC coding challenge.
Course overview - Presentation.
Change Tracking - Presentation.
Change Data Capture - Presentation.
CT Demo Code snippets.
CDC Demo Code snippets.
CT Coding Challenge - Solution.
CDC Coding Challenge - Solution.
This is the sample of the complete reference handbook below.
The full hand book consists of
The full hand book consists of
Conclusion... The final session...!!!
Chandrasekhar is a Microsoft Certified Technology Specialist in Database Development and has over 8 years of real time exposure on SQL, T-SQL and MSBI. Currently I am working as Senior database and MSBI developer in one of the Fortune 500 Companies in USA. I have also worked for couple of Top MNC’s in India. Since the first day of my IT career, I have been interested in database technologies & Business Intelligence. As a part of MCTS (Microsoft Certified Technology Specialist) preparation, I learnt many advanced concepts in SQL server and I would like to share my knowledge to everyone. So I launched a website SQLVersity on my own through which I share my knowledge by writing articles on SQL Server. Till now I have published more than 100 posts in SQLVersity which helped many database developers in the world. This is just my beginning of UDEMY journey with the course named ‘The Ultimate ways to recover the lost data in your database’. I have published this course after so much struggle in learning making Video tutorials, editing the videos and most importantly making awesome course content to make it easily understand by everyone from beginner level to expert level. I hope my courses help people who want to become expert in database technologies.
“Try and Fail. But Never Fail to Try”- JARED LETO