MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server 2008 Advanced Database Administration: Part 1

Course Summary

Part 1 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out

  • +

    Course Syllabus

    ● Getting Started with Advanced SQL Server 2008 Database Admin
        ◦ About This Course
        ◦ About Your Instructor and Overview
        ◦ How to Use This Course
    ● Lab Setup
        ◦ Introduction
        ◦ Copying and Setting Up the Course Files
    ● The Course Scenario
        ◦ The Company: Veronica's Veronicas
        ◦ Database Schema for Veronica's Veronicas
        ◦ Veronica's Veronicas Locations
    ● Setup and Installation of SQL Server 2008
        ◦ Introduction
        ◦ SQL Server 2008 Editions
        ◦ Performing a New Installation
        ◦ SQL Server Installation Center
        ◦ Server Configuration
        ◦ Database Engine Configuration & Authentication
        ◦ Features of SQL Server
        ◦ Hardware, Disk Space, and Software
        ◦ What We Covered
    ● Optimizing SQL Searches with Indexes
        ◦ Introduction
        ◦ Indexes in SQL Server 2008
        ◦ Clustered and Non Clustered Indexes
        ◦ XML Indexes
        ◦ Spatial Indexes
        ◦ User Account Setup
        ◦ Creating a Clustered or Non Clustered Index
        ◦ Creating a Spatial Index
        ◦ Creating an XML Index
        ◦ Using T-SQL for Indexes
        ◦ Rebuilding and Dropping an Index
        ◦ Filtered Indexes
        ◦ Indexed Views
        ◦ Index Performance: Disabling Query Statistic Collection
        ◦ Index Performance: Fragmentation and Fill Factor
        ◦ Reorganizing vs. Rebuilding an Index
        ◦ The Database Engine Tuning Advisor
        ◦ What We Covered
    ● Full-Text Search
        ◦ Introduction
        ◦ Overview of Topics
        ◦ Pros and Cons
        ◦ Full-Text Search Terminology
        ◦ Installing Full-Text Search
        ◦ Introduction to Full-Text Catalogs and Full-Text Indexes
        ◦ Using the Full-Text Indexing Wizard
        ◦ The Like Expression vs. the Contains Statement
        ◦ Configuring Full-Text Searches
        ◦ Using the Inflectional Statement
        ◦ Troubleshooting Full-Text Search
        ◦ Using Dynamic Management Views
        ◦ Full-Text Search Error Logs
        ◦ What We Covered
    ● SQL Server 2008 Security
        ◦ Introduction
        ◦ Authentication Modes
        ◦ Creating Users and Logins
        ◦ Database-Level Roles
        ◦ Server-Level Roles
        ◦ The SA Account
        ◦ SQL Server Service Accounts
        ◦ Built-in SQL Server Accounts
        ◦ Securable Scopes and Schemas
        ◦ Schemas
        ◦ What We Covered


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top