Hands-on with SQL Server DBCC Commands
4.2 (3 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.
12 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Hands-on with SQL Server DBCC Commands to your Wishlist.

Add to Wishlist

Hands-on with SQL Server DBCC Commands

DBCC Commands
4.2 (3 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.
12 students enrolled
Created by Amit Arora
Last updated 4/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • One of the primary goals of this course is to understand what DBCC commands exist and when to use them. These are commands that you can use against the SQL Server instance or against a specific database, and they will either return information about the instance or a database, or they can validate data or data integrity, and there are select commands which will change how SQL Server behaves. This course will also highlight which commands can affect system performance and you need to take caution against running in production.
View Curriculum
Requirements
  • Basic understanding of SQL Server databases is prerequisite of this course.
  • For self practice and trying demo's on your own, you need to have any version of SQL Server management studio installed (preferably 2012 or above version).
Description

In this course we'll review the most frequently executed DBCC commands to not just see exactly what they do, but also understand what impact if any they can have on performance, on your solution  / configuration, or on your data.  If you work with SQL Server in any capacity, whatever your level, this course is relevant to you. This course is relevant to database administrators and developers. Experience with TSQL commands is helpful, along with the basic understanding of how SQL Server works.

The primary goals of this course are for you to start to understand what DBCC commands exist and when to use them.  These are commands that you can use against the SQL Server instance or against a specific database, and they will either return information about the instance or a database, or they can validate data or data integrity, and there are select commands which will change how SQL Server behaves, we will explore all these categories of commands in this course along with hands-on exercise for each command.

This course is comprised of five modules. In first module, we will cover some basic information about DBCC commands including categories and how we can get information about all the commands available on any specific SQL Server release. In module two, we'll get into informational commands which provide information about instance or SQL database. In module three, we will cover maintenance commands which are used to make changes in behavior of SQL. In module four, we will learn about validation commands which validate structure of database objects. And then we'll wrap up module six discussing undocumented commands which are used widely but not officially supported by Microsoft.

I hope you'll join me as we explore the world of DBCC commands with this course, "Hands-on with SQL Server DBCC command" on Udemy.

Who is the target audience?
  • This course will provide detailed understanding of DBCC commands which will provide benefits to all levels of SQL Server database developers and database administrators.
  • Anyone who want to learn some tricks about getting quick information from SQL Server database and use DBCC commands for performance tuning diagnosis.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
01:26:11
+
Module 1 : Introduction
3 Lectures 13:03

Provide description about various modules in this course.

Preview 02:38

In this chapter, we will learn about categories of DBCC commands and how to get list of supported commands for any specific SQL Server version. 

Preview 07:58

Demo on DBCC HELP

DBCC HELP DEMO
02:27

Introduction Quiz
2 questions
+
Module 2 : Informational Commands
3 Lectures 20:35

This chapter provides information about "Informational" DBCC commands. 

Informational Commands
12:26

Informational Command Demo -1
03:25

Informational Command Demo -2
04:44

Information commands quiz
2 questions
+
Module 3 : Maintenance Commands
3 Lectures 22:27

This chapter provides information about "Maintenance" DBCC commands. 

Maintenance Commands
13:23

Maintenance Commands Demo -1
04:05

Maintenance Commands Demo -2
04:59

Maintenance commands quiz
3 questions
+
Module 4 : Validation Commands
2 Lectures 18:15

This chapter provides information about "Validation" DBCC commands. 

Validation Commands
13:23

Validation commands Demo
04:52

Validation commands quiz
2 questions
+
Module 5 : Undocumented Commands
2 Lectures 11:51

This chapter provides information about "Undocumented" DBCC commands, which are not officially supported by Microsoft.

undocumented commands
06:51

Undocumented commands Demo
05:00

Undocumented commands quiz
2 questions
About the Instructor
Amit Arora
3.7 Average rating
136 Reviews
1,099 Students
4 Courses
Data Integration Specialist

I have over 16 years of experience with databases (primarily with Oracle and SQL Server and NoSQL databases). In this period, I worked in every phase of Software development life cycle including database developer and database administrator, data modelling, etc.

I am an Oracle certified DBA and handing Oracle / SQL Server projects in my jobs. I am regular blogger for various sites and written Oracle/ SQL related articles along with certification tests for Oracle, PMP and more.

I completed MongoDB courses with full score from MongoDB university and practically implimented the solution for various applications.