Course 2937 Administering and Monitoring Microsoft SQL Server 2005

Course 2937 Administering and Monitoring Microsoft SQL Server 2005 online clinic will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules: Exploring SQL Server 2005 Administrative Tools, Monitoring SQL Server 2005 and Maintaining Databases and Indexes.

Plus, Course 2937 Administering and Monitoring Microsoft SQL Server 2005 E-Learning lets you learn at your own pace. Work online or download courses to your computer to study when you are not connected to the Internet.  

Our Price:  $99

Add to Cart

Purchase Course 2937 Administering and Monitoring Microsoft SQL Server 2005 to save on Microsoft SQL Server E-learning

Title: Course 2937 Administering and Monitoring Microsoft SQL Server 2005
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 6 Hours
Language: English

Course 2937 Administering and Monitoring Microsoft SQL Server 2005 Objectives:
At the end of the course, students will be able to:

Use SQL Server 2005 administration tools.

Monitor SQL Server 2005.

Maintain databases and indexes in SQL Server 2005.

System Requirements:
To view this course, you need:

A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ

Microsoft® Windows® 2000 or higher

Microsoft Internet Explorer 6.0 or higher

Macromedia Flash 7.0 or higher (1MB disk space needed to install)

Microsoft Windows Media Player 7.0 or higher

Microsoft XML Core Services 3.0 or higher

A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.

A sound card, and either speakers or headphones (for multi-media audio).

Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Accessibility Requirements:
The following software must be running on your computer in order to access this course with Screen Reader Software:

Microsoft Internet Explorer 6.0 or higher

Window-Eyes from GS Micro

JAWS from Freedom Scientific

MSAA enabled
Course Overview
Module Introduction
How To Use This Course
Course Information
Exploring SQL Server 2005 Administrative Tools
Module Introduction
Using SQL Server Management Studio
Lesson Introduction
Overview of SQL Server Management Studio
Registering a Server
Overview of Object Explorer
Using Transact-SQL in SQL Server Management Studio
Working with SQL Server Management Studio Solutions
Creating a Solution with Solution Explorer
Self Test
Using SQL Computer Manager
Lesson Introduction
Overview of SQL Computer Manager
Using SQL Computer Manager
Controlling Services Manually
Viewing and Changing Service Properties
Managing Server Network Connectivity
Managing Client Network Connectivity
Self Test
Using the sqlcmd Utility
Lesson Introduction
Overview of the sqlcmd Utility
Using sqlcmd Command-Line Switches
Working with the sqlcmd Utility
Executing Scripts Using the sqlcmd Utility
Using Variables with the sqlcmd Utility
Working with a Dedicated Administrator Connection
Self Test
Using the SQL Management Objects
Lesson Introduction
Overview of SQL Management Objects
Comparing SMO and SQL Server Distributed Management Objects
Creating an SMO Application and Retrieving Server Information
Using SMO to Back Up a Database
Using SMO to List and Create a Database
Self Test
Lab: Administering SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Monitoring SQL Server 2005
Module Introduction
Using SQL Profiler
Lesson Introduction
Understanding SQL Profiler Enhancements in SQL Server 2005
Saving a Trace as XML
Self Test
Using DDL Triggers
Lesson Introduction
Overview of DDL Triggers
Creating DDL Triggers
Managing DDL Triggers
Using a DDL Trigger to Audit Database Operations
Self Test
Using Event Notifications
Lesson Introduction
Overview of Event Notifications
Creating Event Notifications
Processing Event Notifications
Managing Event Notifications
Defining Event Notifications
Self Test
Using Metadata Views
Lesson Introduction
Querying Static Metadata
Querying Dynamic Metadata
Querying Metadata
Self Test
Lab: Monitoring SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Maintaining Databases and Indexes
Module Introduction
Managing Indexes
Lesson Introduction
Introducing New Index Features in SQL Server 2005
Creating an Index
Altering an Index
Disabling an Index
Dropping an Index
Managing Fragmentation
Self Test
Using the Database Tuning Advisor
Lesson Introduction
Overview of the Database Tuning Advisor
Using the Database Tuning Advisor
Viewing Results as XML
Tuning a Database for a Defined Workload
Self Test
Lab: Maintaining a Database
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Our Price:  $99

Add to Cart

Frequently Asked Questions on Microsoft E-Learning

Question: What is Microsoft E-learning?
Answer: Official Microsoft E-Learning products provide a thorough learning experience by incorporating features designed to improve your product proficiency and boost your productivity. Assessments, hands-on virtual labs, expert advice, and an interactive, non-linear approach all contribute to make Microsoft E-Learning an engaging and flexible learning experience. Regardless of your type of organization, skill levels, or learning styles; Microsoft E-Learning can provide access to just the right software training anytime and anywhere - for IT Professional, developers, and home and office workers. Microsoft E-Learning content is created by Microsoft experts, so the training comes straight from the source.

Question: How Long and how I will have access to purchased Microsoft E-Learning?
Answer: When you purchase any Microsoft Elearning course from us, we will send product key to activate your Microsoft E-learning subscription directly on Microsoft official website. You will need internet access to attend your course. Subscription is for 365 days from your activation date.

Question: How we are able to sell Microsoft E-Learning so cheap?
Answer: We are an Authorized reseller for Microsoft E-Learning Solutions. As a reseller we have special pricing from Microsoft E-learning. You attend Microsoft E-Learning course directly at official Microsoft Elearning website. We only provide you activation key to activate your Microsoft elearning course. Only difference is you save money when you purchase from us.

Question: Can I try one of the course before I purchase?
Answer: Absolutely, There are plenty of courses available to try Free of cost and of course no obligation to purchase. Click here for complete Free Microsoft E-Learning Courses.

Question: Can I get Refund for my Microsoft Elearning purchase?
Answer: Sorry NO! All of our orders are FINAL. There is NO RETURN, NO REFUND, NO EXCHANGE. Once order is processed, everything is FINAL. So If you have any questions, please contact customer service at elearning@solartechlearning.com before you place an order.