دانلود TrainSignal Advanced SQL Server 2008 Database Administration Training (DVD1-2)
TrainSignal Advanced SQL Server 2008 Database Administration Training (DVD1-2)
Fomat: iSO | DVD1: 2.76GB | DVD2: 2.18 GB
Genre: eLearning
Download Provider - Heroturko.com
YES! If you have taken our SQL Server 2008 Administration Training course, have obtained your 70-432 MCTS: SQL Server 2008, Implementation and Maintenance certification, or have experience as a SQL Server 2008 administrator, you’ll benefit from this in-depth course!
Video 1
Getting Started with Advanced SQL Server 2008 Administration Training
In this video you will learn a little bit about your instructor and you will discover the topics that will be covered in this course.
* About This Course
* About Your Instructor
* Overview of Course Topics
* How to Use This Course
Video 2
Lab Setup
In this video you will learn about the hardware and software that Mel uses in the course, so you can set up your own environment that will allow you to work hands-on and follow along with the course labs.
* The Instructor’s Environment
* Copying and Setting Up the Course Files
Video 3
The Course Scenario
In this video you will be introduced to the course scenario that you will work with throughout the course.
* The Company: Veronica’s Veronicas
* Database Schema for Veronica’s Veronicas
* Veronica’s Veronicas Locations
Video 4
Setup and Installation of SQL Server 2008
In this video you will learn how to prepare for a SQL Server 2008 installation. Plus, you will work hands-on to install SQL Server 2008!
* SQL Server 2008 Editions
* Performing a New Installation
* SQL Server Installation Center
* Server Configuration
* Database Engine Configuration & Authentication
* Microsoft SQL Management Studio
* Features of SQL Server
* Hardware, Disk Space, and Software
Video 5
Indexes
In any database you definitely want to be able to access information as quickly as possible; that’s why knowing how to utilize indexes is an invaluable resource. In this video you will learn how to use indexes, when to use indexes and the best ways to use the various types of indexes to access your databaase information in the most efficient manner.
* Introduction and Overview
* 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 Indexes
* Filtered Indexes
* Indexes Views
* Index Performance
* Disabling Query Statistic Collection
* Fragmentation and Fill Factor
* Reorganizing vs. Rebuilding an Index
* The Database Tuning Advisor
Video 6
Full-Text Search
In this video you will learn how to search through text in your database by using an index to jump directly to the records of interest. Plus, you will work hands-on performing full-text searches using the Full-Index Wizard.
* Overview of Topics
* Pros and Cons
* Full-Text Search Terminology
* Installing Full-Text Search
* Introduction to Full-Text Catalogs and Full-Text Indexes
* Creating a Full-Text Catalog and Index 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
* Troubleshooting Full-Text Search Using Dynamic Management Views
* Full-Text Search Error Logs
Video 7
SQL Server 2008 Security
SQL Server is designed to allow quick reliable access to your corporate data. In this video you will learn how to use the various SQL Server security configuration choices and you will work hands-on with these different configuration options to control access to the data in your database.
* 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
Video 8
SQL Server 2008 Policy Based Management
Policy Based Management is new to SQL Server 2008 and it replaces the Surface Area Configuration tool from previous SQL Server versions. In this video you will learn to utilize Policy Based Management to provide a more manageable centralized configuration management interface for all your server instances. Plus, you will work hands-on to enforce naming restrictions and control your feature states.
* Policy Based Management Benefits
* Policy Based Management Terms and Concepts
* Setting Up Naming Restrictions
* Controlling Feature State
* Security
* Adding a User to the Policy Administrator Role
* Recap and Other Things to Remember
Video 9
SQL Server 2008 Data Encryption
Most of us will agree that our data can never be too secure! That is why in SQL Server 2008 you are able to encrypt your data, so that even if your data is compromised it is not readable without the decryption keys and passwords. In this video you will learn how to properly utilize the various SQL Server encryption options and you will work hands-on to encrypt the data in your SQL Server 2008 database.
* Encryption Background Information
* SQL Server 2008 Encryption Hierarchy
* Encryption Hiearachy Components
* Data Encryption vs. Transparent Data Encryption
* SQL Server 2008 Column Encryption
* Column Decryption
* Transparent Data Encryption
* Encryption Alogorithms
Video 10
SQL Server 2008 Backup and Recovery
Being able to recover your data in the event of data loss or corruption is part of the foundation of any administered SQL installation. In this video you will work step-by-step through the backup and recovery process. Plus, you will work hands-on with Snapshots as you develop your own data recovery plan.
* SQL Server 2008 Files
* SQL Server 2008 System Databases
* Creating a Basic Backup
* Performing a Basic Restore
* Database Recovery Models
* Backup Types
* Backup and Restore with TDE Enabled
* Using Snapshots in SQL Server 2008
Video 11
SQL Server 2008 High Availability
In this video you will learn how to utilize the various SQL Server High Availability options. Plus, you will discover the pros and cons of each option that will enable you to create and tailor the best high availability solution for your organization.
* High Availability Options
* Failover Clustering
* Pros and Cons of Failover Clustering
* Database Mirroring
* Pros and Cons of Database Mirroring
* Log Shipping
* Pros and Cons of Log Shipping
* Replication
* Replication and Database Mirroring
* Selecting a High Availability Solution
Video 12
SQL Server 2008 Failover Clustering
SQL Server 2008 operates based on the Microsoft Windows clustering capabilities. In this video you will learn the requirements to enable SQL Server clustering so that you will be prepared in the event of a failure.
* Key Terms to Know
* Prerequisites
* Introduction to SQL Server 2008 Clustering Installation Process
* SQL Server 2008 Clustering Options
Video 13
SQL Server 2008 Database Mirroring
Database Mirroring is an excellent way to maintain database availability in the event of a server outage or during server maintenance. In this video you will work hands-on to configure your own mirrored instance so that you can avoid database downtime.
* Mirroring Overview
* Operating Modes
* Mirroring Roles
* Mirroring Service Account
* Setting Up Server Engine Service Accounts
* Database Mirroring Sessions
* Creating Database Mirroring Endpoints
* Role Switching
* Configuring Endpoints and Starting Mirroring
* Recommendations and Restrictions
Video 14
SQL Server 2008 Log Shipping
Log Shipping is another option you can utilize to make sure your data remains available to users in the event of crashes or failures. In this video you will work step-by-step to setup, configure and monitor log shipping in your own SQL Server 2008 database environment.
* Log Shipping Overview
* SQL Server 2008 Supported Editions
* Log Shipping Servers
* Log Shipping Jobs
* Setting Up Log Shipping
* Log Shipping Failover
* Primary Server Tables
* Secondary Server Tables
* Monitor Server Tables
Video 15
SQL Server 2008 Replication
Replication allows you to make segments of your data available to users and applications on separate SQL Server instances by automatically copying data to various servers within your network. In this video you will learn how to take advantage of the different Replication options. Plus, you will work hands-on to setup and configure Replication in your own SQL Server 2008 database.
* The Need for Replication
* What is SQL Server Replication?
* Two Categories of Replication: Server to Server
* Two Categories of Replication: Server to Client
* Replication Roles: Publisher, Distributor, and Subscriber
* Replication Agents
* Replication Configuration
* Adding Computers to the Domain
* Creating Domain Accounts
* Replication User Accounts
* Configuring the Firewall
* Installing SQL Server and Replication
* Configuring Distribution
* Creating the Publication
* Configuring the Subscriber
* Creating the Subscription and Verifying Data Was Replicated
* Best Practices
Video 16
Resource Governor
Resource Governor is a new feature in SQL Server 2008 that allows you to regulate access to SQL Server resources. In this video you will learn how to utilize Resource Governor to properly manage resource utilization. Plus, you will work hands-on to create your own resource pools, classifier functions, and workload groups.
* Managing Resource Utilization
* Grouping Server Resources
* Classification
* Classifier Functions
* Creating a Classifier Function
* Security for Resource Governor
* Resource Pools
* Creating a Resource Pool
* Workload Groups
* Creating the Resource Pool and Workload Group
Video 17
Monitoring SQL Server 2008
SQL Server 2008 comes equipped with numerous tools designed to monitor the "health" of your SQL Server instance. In this video you will learn how to utilize some of the monitoring tools that will help you prevent problems before they occur and will help you troubleshoot issues as they occur.
* Activity Monitor
* Trace Flags
* SQL Server 2008 Reports
* Job Activity Monitor
* SQL Server 2008 Logs
* Dynamic Management Views and Functions
* Using Dynamic Management Views
* SQL Server Audits
* Dedicated Administrator Connection (DAC)
Video 18
SQL Server 2008 Performance Tuning
In this video you will learn how to utilize performance tuning tools to make sure you get the top performance out of your SQL Server instance.
* SQL Server Profiler
* Database Engine Tuning Advisor
* Using the SQL Server Profiler and Database Engine Tuning Advisor
* Query Analysis and Execution Plans
* Using Execution Plans for Query Analysis
* Other Performance Tuning Tools
Video 19
SQL Server 2008 PowerShell
Power Shell is an object-oriented scripting language designed to automate system tasks. In this video you will learn the basics of SQL Server PowerShell and how to begin to utilize foundational commands and Cmdlets.
* Introduction to PowerShell
* Running PowerShell 1.0 with SQL Server 2008
* Launching PowerShell
* Execution Policy Setting
* Using Execution Policy Cmdlets
* The SQL Server PowerShell Virtual Drive SQLSERVER
* Foundational PowerShell Commands
* SQL Server Specific Cmdlets
Video 20
SQL Server 2008 Integration Services
SQL Server Integration Services is your enterprise level tool for transforming data and migrating data between the SQL Server and other data storage. In this video you will work hands-on to install SSIS, configure SSIS, and create & run a full package.
* Introduction to Integration Services (SSIS)
* Installation and Configuration
* SSIS Service Account and Firewall
* Modifying MsDtsSrvr.ini.xml and the Windows Registry
* SSIS Configuration File
* Running an Integration Services Package
* Using the "Integration Services" (Import/Export) Wizard
* Rerunning a Package Via SSMS
* Other Methods of Running a Package
Video 21
Preparing for Your MCITP: 70-450 Certification Exam
In this video you will learn Mel’s inside tips and pointers on the exam certification process and other things you should consider before taking the exam.
* Three SQL Server 2008 Certication Levels
* Three SQL Server 2008 Certification Tracks
* Microsoft Certified Technology Specialist
* Microsoft Certified IT Professional (MCITP)
* MCITP 2005 Upgrade Exams
* Microsoft Certified Master (MCM)
* SQL Server 2008 Certifications
* Preparing for Your 70-450 Certification Exam
* Registering for Your 70-450 Certification Exam
Video 22
Next Steps
Reaching the end of the course does not mean the learning has to end! In this video you will discover the "next steps" for continuing your growth with Microsoft SQL Server 2008.
* Lesson Recap
* Steps for Follow Up
* We’ Like Your Opinion
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
http://www.fileserve.com/file/U3APt9...isc2.part1.rar
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
Free File Hosting, Online Storage & File Upload with FileServe
