Course 2936 Installing and Securing Microsoft SQL Server 2005

Course 2936 Installing and Securing 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: Understanding the SQL Server 2005 Architecture, Installing SQL Server 2005 and Securing SQL Server 2005.

Plus, Course 2936 Installing and Securing 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 2936 Installing and Securing Microsoft SQL Server 2005 to save on Microsoft SQL Server E-learning

Title: Course 2936 Installing and Securing Microsoft SQL Server 2005
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 6 Hours
Language: English

Course 2936 Installing and Securing Microsoft SQL Server 2005 Objectives:
At the end of the course, students will be able to:

Describe the architecture of SQL Server 2005.

Install SQL Server 2005.

Secure a SQL Server 2005 database.

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
Understanding the SQL Server 2005 Architecture
Module Introduction
Overview of SQL Server 2005
Lesson Introduction
What is SQL Server 2005?
Understanding the Components of SQL Server 2005
Self Test
Enhancements to SQL Server 2005 Components
Lesson Introduction
Working with the Database Engine
Understanding Analysis Services
Improvements to Full-Text Search
Introduction to SQL Server Integration Services
Enhancements to Replication
Self Test
Understanding SQL Server 2005 Features
Lesson Introduction
Overview of Notification Services
Creating Instances and Applications for Notification Services
Introducing Reporting Services
Using Reporting Services to Generate Reports
Overview of Native HTTP Support
Creating and Managing HTTP Endpoints
Self Test
Introducing SQL Server 2005 Extensibility Components
Lesson Introduction
Working with Service Broker
Creating and Using Service Broker Objects
Overview of the Common Language Runtime
Integrating Managed Assemblies into SQL Server 2005
Selecting the Appropriate Component
Self Test
System Enhancements for Administrators
Lesson Introduction
Introducing System Enhancements
Data Storage Enhancements
Partitioned Tables and Indexes
Introducing the Snapshot Isolation Level
Overview of SQLiMail
Configuring SQLiMail
Self Test
Module Summary
Installing SQL Server 2005
Module Introduction
Preparing to Install SQL Server 2005
Lesson Introduction
SQL Server 2005 Editions
Hardware Requirements
Software Requirements
Working with Previous Versions
Self Test
Performing a SQL Server 2005 Installation
Lesson Introduction
SQL Server 2005 Installation
The System Consistency Checker
Installing SQL Server 2005 Components
Performing an Unattended Installation
Performing a Remote Installation
Installing SQL Server in a Cluster
Self Test
Maintaining a SQL Server 2005 Installation
Lesson Introduction
Adding or Removing SQL Server 2005 Components
Removing SQL Server 2005
Self Test
Lab: Installing SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Securing SQL Server 2005
Module Introduction
SQL Server 2005 Security Overview
Lesson Introduction
Security Enhancements in SQL Server 2005
SQL Server 2005 Security Architecture
Self Test
Managing SQL Server 2005 Security
Lesson Introduction
Managing Logins
Creating a Windows and SQL Server 2005 Login
Managing Users
Creating Users in a SQL Server 2005 Database
Self Test
Managing Schemas and Controlling Execution Context
Lesson Introduction
Overview of Schemas
Managing Schemas
Setting a User's Default Schema
Creating and Assigning Schemas
Controlling Execution Context
Using the EXECUTE AS clause
Self Test
Managing Permissions
Lesson Introduction
Managing Server Permissions
Managing Server-Scope Securable Permissions
Managing Database Permissions
Managing Database-Scope Securable Permissions
Managing Schema-Scope Securable Permissions
Granting Permissions
Self Test
Managing Certificates
Lesson Introduction
Overview of Certificates
How Does SQL Server Use Certificates?
Managing Certificates
Creating and Working with Certificates
Self Test
Lab: Securing a SQL Server 2005 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.