Data Recovery Techniques Part - I
0.0 (0 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.
245 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Recovery Techniques Part - I to your Wishlist.

Add to Wishlist

Data Recovery Techniques Part - I

The Ultimate way to Recover the LOST data from your database
0.0 (0 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.
245 students enrolled
Last updated 3/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 12 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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.
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

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 01:33:38
+
Course Overview
3 Lectures 04:51

Course welcome session...

Preview 02:15

This session introduces the techniques to recover the lost data.

Preview 00:57

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

Preview 01:39
+
Change Tracking
9 Lectures 23:15

This session gives the overview of Change Tracking mechanism.

What is Change Tracking?
01:32

Setup the data required for Change Tracking demonstration.

Data Setup
02:28

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

Preview 03:58

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

DML Operations
02:33

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

Functions used in Change Tracking
06:00

Introduces the way to fetch the detail data modified.

Advanced Tracking
01:07

Discusses the Drawbacks identified in change tracking.

Error..!!! Why?
02:14

Disable Change Tracking on Table and database as well.

Disabling CT
01:32

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

CT Summary
01:51

This Quiz tests your knowledge on Change Tracking Mechanism.

CT Quiz
10 questions
+
Change Data Capture
9 Lectures 23:38

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

Drawbacks in CT
02:23

What is change data capture concept?

What is Change Data Capture?
02:25

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

Data Setup
02:24

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

Enable CDC on Database
02:23

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

Preview 02:07

Discusses the the way to enable CDC on the table.

Enable CDC on Table
05:03

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

DML operations & Data tracking
03:29

Disables CDC on table and database as well.

Disable CDC
02:11

This session discusses the CDC mechanism in short.

CDC Summary
01:13

This Quiz tests your knowledge on Change Data Capture Mechanism.

CDC Quiz
10 questions
+
Comparison
1 Lecture 04:04

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

Similarities & Differences
04:04

A Quiz on Differences between CT & CDC.

CT vs CDC Quiz
5 questions
+
Coding Challenge
2 Lectures 00:02

CT Coding Challenge.

CT Coding Challenge
00:01

CDC Coding Challenge.

CDC Coding Challenge
00:01
+
Bonus Content
5 Lectures 36:37

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

CT Quiz Explanation
03:41

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

CDC Quiz Explanation
03:04

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

Comparison Quiz Explanation
00:53

This session explains the solution for the CT coding challenge.

CT Coding challenge solution
14:47

This session explains the solution for the CDC coding challenge.

CDC Coding challenge solution
14:12
+
Bonus Documents
10 Lectures 00:25

Course overview - Presentation.

Course overview - Presentation
00:01

Change Tracking - Presentation.

Change Tracking - Presentation
00:02

Change Data Capture - Presentation.

Change Data Capture - Presentation
00:03

Comparison - Presentation.

Preview 00:01

CT Demo Code snippets.

CT Demo - Code snippets
00:01

CDC Demo Code snippets.

CDC Demo - Code snippets
00:00

CT Coding Challenge - Solution.

CT Coding Challenge - Solution
00:01

CDC Coding Challenge - Solution.

CDC Coding Challenge - Solution
00:01

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...
Preview 00:02

The full hand book consists of

  • Code snippets where ever needed
  • Screenshots for each & every step
  • Well described course content and many more...
CT & CDC Complete Reference - Handbook
00:10
+
Conclusion
1 Lecture 01:10

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

Conclusion
01:10
About the Instructor
Sr.Database & BI Professional Chandrasekhar Raparthi
0.0 Average rating
0 Reviews
245 Students
1 Course

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