Data Recovery Techniques Part - I

The Ultimate way to Recover the LOST data from your database
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
243 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 40
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

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

What are the requirements?

  • Knowledge on SQL, TSQL, Transactions, MDF and LDF files.
  • Knowledge on the impact of Triggers on database.
  • Knowledge of Microsoft SQL Server 2008 or higher with SQL Server Agent.
  • Basic knowledge on Database Administration.
  • Basic knowledge on SQL Server Agent jobs.
  • Knowledge on Executing stored procedures.

What am I going to get from this course?

  • You will have Over 25 lectures and 1.5hrs of content.
  • You will have Over 10 lectures of bonus content.
  • You will learn how to recover your data using Change Tracking and Change Data Capture.
  • You will learn the multiple ways to know the changes made on our database.
  • You will learn Joining Change Tracking functions and database tables.
  • You will get step by step procedure to track the data.
  • You will learn the old and new tracking mechanisms.
  • Huge bonus content
  • 40 Pages free handbook
  • Code snippets for each module

What is the target audience?

  • Team lead and Project Managers of a software development teams
  • Management of organizations
  • People who really want to know the changes made by themselves or his team mates
  • Database Administrators
  • IT Professionals
  • Everyone who feels that data is precious

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Overview
02:15

Course welcome session...

00:57

This session introduces the techniques to recover the lost data.

01:39

This session compares the old techniques used to recover the lost data and new techniques to be used to recover.

Section 2: Change Tracking
01:32

This session gives the overview of Change Tracking mechanism.

02:28

Setup the data required for Change Tracking demonstration.

03:58

This session demonstrates how to Enable Change Tracking on both database and table.

02:33

Apply few DML operations on the table which will be tracked by CT.

06:00

This session Introduces the functions used in tracking the data with Change Tracking.

01:07

Introduces the way to fetch the detail data modified.

02:14

Discusses the Drawbacks identified in change tracking.

01:32

Disable Change Tracking on Table and database as well.

01:51

This session summarizes the topics which we discussed in change tracking mechanism.

10 questions

This Quiz tests your knowledge on Change Tracking Mechanism.

Section 3: Change Data Capture
02:23

Discusses the drawbacks identified in change tracking and also discusses the mitigation techniques to avoid them.

02:25

What is change data capture concept?

02:24

Setup and Modify the data in table which has to be captured using CDC.

02:23

Demonstrates the process of enabling change data capture on the database.

02:07

Discusses the default objects created once CDC is enabled on database.

05:03

Discusses the the way to enable CDC on the table.

03:29

Do some DML operations on the table and capture the data.

02:11

Disables CDC on table and database as well.

01:13

This session discusses the CDC mechanism in short.

10 questions

This Quiz tests your knowledge on Change Data Capture Mechanism.

Section 4: Comparison
04:04

This session discusses the similarities and differences between CT & CDC.

5 questions

A Quiz on Differences between CT & CDC.

Section 5: Coding Challenge
Article

CT Coding Challenge.

Article

CDC Coding Challenge.

Section 6: Bonus Content
03:41

This session explains answers to the quiz given under Change Tracking section.

03:04

This session explains answers to the quiz given under Change Data Capture section.

00:53

This session explains answers to the quiz given under Comparison section.

14:47

This session explains the solution for the CT coding challenge.

14:12

This session explains the solution for the CDC coding challenge.

Section 7: Bonus Documents
Article

Course overview - Presentation.

Article

Change Tracking - Presentation.

Article

Change Data Capture - Presentation.

Article

Comparison - Presentation.

Article

CT Demo Code snippets.

Article

CDC Demo Code snippets.

Article

CT Coding Challenge - Solution.

Article

CDC Coding Challenge - Solution.

Article

This is the sample of the complete reference handbook below.

The full hand book consists of

  • Code snippets where ever needed
  • Screenshots for each & every step
  • Well described course content and many more...
Article

The full hand book consists of

  • Code snippets where ever needed
  • Screenshots for each & every step
  • Well described course content and many more...
Section 8: Conclusion
01:10

Conclusion... The final session...!!!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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

Ready to start learning?
Take This Course