Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

SQL Server: Advanced Corruption Recovery Techniques

SQL Server: Advanced Corruption Recovery Techniques

1425/month
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Advanced
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

Database corruption happens all the time, all over the world, and sometimes it's not so simple to deal with. In this follow-on course from SQL Server: Detecting and Correcting Database Corruption, you'll learn the more advanced techniques that can lead to success in the most challenging corruption scenarios, applicable for more experienced SQL Server professionals, from SQL Server 2005 onward.

Syllabus

Why is This Course Important?
What Can Happen When Corruption Recovery Does Not Work?
Real-World Example
Practice Makes Perfect
Root Cause Analysis
Why Can I Teach This Course?
Course Structure
Introduction
What Exactly Does DBCC CHECKDB Do?
Fact Processing (1)
Fact Processing (2)
Fact Processing (3)
Batch Processing
Parallelism (1)
Parallelism (2)
Nonclustered Index Checks
Making DBCC CHECKDB Go Faster (1)
Making DBCC CHECKDB Go Faster (2)
Making DBCC CHECKDB Go Faster (3)
Making DBCC CHECKDB Go Faster (4)
Summary
Introduction
DBCC IND
DBCC PAGE
Demo: DBCC IND and DBCC PAGE
DBCC DBINFO
DBCC DBTABLE
Demo: DBCC DBINFO and DBCC DBTABLE
DBCC WRITEPAGE
Demo: Creating Corruption Using a Hex Editor
Demo: Introducing DBCC WRITEPAGE
Demo: DBCC WRITEPAGE Examples
Summary
Introduction
Database States (1)
Database States (2)
Damaged/Missing Log With Clean Shutdown
Demo: Recreating the Log
Damaged/Missing Log Without Clean Shutdown
EMERGENCY Mode
EMERGENCY-Mode Repair
Demo: EMERGENCY-Mode Repair
Demo: Unrepairable Corruption in EMERGENCY-Mode
Detached SUSPECT Database
Demo: Detached SUSPECT Database
Demo: Detached SUSPECT Database with Non-Standard File IDs
Damaged Log of Attached Database
Summary
Introduction
What If SQL Server is Unavailable?
Demo: Hack-Attach Tail-of-the-Log Backup
Page Restore
Demo: Simple Page Restore
Demo: Failed Page Restore
Piecemeal and Partial Restores
Demo: Partial Restore
Demo: Piecemeal Restore
Restoring Corrupt Backups
Demo: Restoring Corrupt Backups
Looking Into Log Backups
Restoring to a Log Sequence Number
Demo: Using fn_dump_dblog and LSN Restore
Restoring System Databases (1)
Restoring System Databases (2)
Demo: Restoring master
Summary
Introduction
Is Repair Guaranteed to Work?
Metadata Corruption
Demo: Enabling the Dedicated Admin Connection
Demo: Upgraded Corrupt Metadata
Demo: Metadata Corruption
Rebuilding System Table Indexes
Demo: Corrupt System Table Indexes
Using Older Backups and Repair
Demo: Using Older Backups and Repair
Reconstructing Data From Nonclustered Indexes
Demo: Reconstructing Data From Nonclustered Indexes
Using DBCC PAGE to Navigate Table Structures
Demo: Using DBCC PAGE to Navigate Table Structures
The Ultimate Advanced Recovery
Demo: Manual Repair Using DBCC WRITEPAGE
Any Other Ways to Salvage Data?
Course Summary

What others say about this course

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of SQL Server: Advanced Corruption Recovery Techniques

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer