StudyExam4Less.com Login My Account Favorites View Cart Checkout
          Home         School Program         Affiliates         Help Center         About Us         Contact Us         Product Finder
CompTIA Microsoft Cisco Oracle CISSP Sun PMI MOS IC3
Find a Certification
Search
 

Browse catalog

  CompTIA
  Microsoft
  Cisco
  Oracle
  CISSP
  Sun
  PMI
  MOS
  IC3


Win Free Products
A+
Network+
Security+
Microsoft Certification
MOS Certification
Cisco
Subscribe
View all mailing lists

 

 Other Resources

 Our Authors
 New Arrivals
 Clearance
 Quick Order
 Gift Certificate
 Join Affiliates
 
 Subscribe Area
 Newsletter
 Forums
 Email To A Friend


Course 2936 Installing and Securing Microsoft SQL Server 2005

Course 2936 Installing and Securing Microsoft SQL Server 2005

Price: 99.00 USD

Qty:

Add to cart

  

Add to Favorites | Ask a Question | Email to a Friend

PRODUCTION DESCRIPTION:

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.  


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
  • PRODUCT OPTION:

    Manufacturer: Microsoft E-Learning
        
    Price: 99.00 USD Add to cart

    Be the first to review this product.   Write a review

     

    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 study@studyexam4less.com


    Shopping Cart
    Items: 0
    Subtotal: 0

    View Cart | Checkout
    Products on Sale
      INFORMATION
    Home
    School Program
    Help Center
    About Us
    Contact Us
    Advanced Search
    ACCOUNT
    Login
    My Account
    Favorites
    View Cart
    Checkout
    Affiliates
    VENDORS
    CompTIA
    Microsoft
    Cisco
    Oracle
    CISSP
    Microsoft Office Specialist
    IC3
    Sun Certification
    PMI
    Questions? please visit FAQ Privacy Policy   Sitemap  Guarantee StudyExam4Less Copyright 2007 | Powered by AceFlex