SQL Server 2008 R2 Database Maintenance Skills

SQL Server 2008 Training for SQL Server 2008 R2 Database Maintenance Skills
3.3 (7 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.
72 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 8
  • Length 2.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 9/2012 English

Course Description

This SysMentors SQL Server 2008 Training course will help you get introduced to the world of SQL Server 2008 Database maintenance tasks. The “SQL Server 2008 Training: SQL Server 2008 R2 Database Tutorial” course is intended for all SQL Server Database users IE. Developers, Administrators, and Operations Specialists. You will learn real life day-to-day tasks and operational skills required to work with SQL Server 2008 R2 Databases.

Take this SQL Server 2008 Training course and learn from SQL Server 2008 R2 Database tutorial.

</p>

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: My First Section
08:53

This module will help SQL Server 2008 R2 users to get familiar with the Configuration Manager tool and also introduces to protocols and Alias setup.

24:32

This module will help you learn about the installation procedures for SQL Server 2008 R2. Best practices for installation are covered along with some must know details.

25:48

This module will help you understand SQL Server 2008 R2 System and User Databases. You will learn about Temporary tables in Temp Database, Creating User Databases, DataFiles and FileGroups.

22:39

This module will help you understand SQL Server 2008 R2 Recovery Models, Backup and Restore operations.

19:38

This module will help you understand the difference between SQL Server 2008 R2 Logins and Database Users and will help you learn how to assign Server and Database roles.

09:07

This module will help you understand the use of triggers for change monitoring and management in Audit.

25:36

This module will help you understand Audit operations using SQL Profiler Tool. You will also learn new Audit features and how to create Server and Database Audit specifications to keep track of changes.

21:32

This module will help you understand about the various maintenance activities required for SQL Server 2008 R2 Databases. You will learn about Integrity checker, Shrink operations, Rebuild & ReOrganize Index, Backup, Job scheduling.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

System Mentors, Remote Learning Solutions

Welcome to SysMentors. Provider of high-quality System and Applications training videos. If you are tired of searching for high quality training material and videos which can help you understand concepts and also provide step-by-step walk through with practical examples - you have come to the destination.We provide OnDemand, high-quality remote learning solutions worldwide. Visit us www.SysMentors.com

Ready to start learning?
Take This Course