TrainSignal
قيمت: ۶,۰۰۰ تومان
آموزش شبکه » TrainSignal
آموزش Database Administration Advanced SQL Server 2008
آموزش
Advanced
SQL Server 2008 Database Administration آموزش مالتی مدیا به مدت 12
ساعت از کمپانی Train Signal به صورت 2 حلقه DVD
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 configu
عنوان اصلی : VMware vSphere Pro Series Training Vol. 2 این مجموعه آموزش سری دوم از مجموعه آموزش حرفه ای و استفاده کاربردی از vSphere ...
آموزش Microsoft Exchange Server 2003 Administration and Maintenance در آموزش مالتی مدیا محصول موسسه آموزشی Knowledgenet در قالب 1 حلقه CD
عنوان اصلی : System Center Operations Manager Training همانطور که می دانید بوسیله نرم افزار System Center Operations Manager می توانید بر تمام ...
عنوان اصلی : Windows Server 2008 R2 Training آموزش ویژگی ها و امکانات جدید و کاربردی Windows Server 2008 R2 از جمله کار با Active Directory ...
عنوان اصلی : VMware vSphere Pro Series Training Vol. 1 : View, ThinApp, Nexus 1000V, and PowerCLI این مجموعه آموزش دقیقا آن محتوایی را ارائه می ...
آموزش Advanced SQL Server 2008 Database Administration آموزش مالتی مدیا به مدت 12 ساعت از کمپانی Train Signal به صورت 2 حلقه DVD
آموزش جامع Hyper-V ارائه شده بر روی 2 حلقه DVD به مدت زمان 7 ساعت . هر کدام از دروس این مجموعه با چندین فرمت های فایل ...
آموزش Windows Home Server Training در آموزش ویدیویی محصول موسسه آموزشی TrainSignal به مدت زمان 13 ارائه شده بر روی 2 حلقه CD
عنوان اصلی : VMware vSphere Pro Series Training Vol. 1 : View, ThinApp, Nexus 1000V, and PowerCLI این مجموعه آموزش دقیقا آن محتوایی را ارائه می ...
عنوان اصلی : Windows Small Business Server 2008, Configuring MCTS: Exam 70-653 نرم افزار Small Business یکی از برترین نرم افزارهای مدیریت اطلاعات ...
راه اندازي فروشگاه در Eforosh رايگان است
--
آموزش جامع و کاربردی نرم افزار Access 2010
آموزش نرم افزار Access 2007 محصول کمپانی TrainSignal 
یادگیری سریع زبان انگلیسی با Oxford New English File Series
آموزش زبان انگلیسی ویژه کودکان Tell Me More English for Kids
معتبرترین و محبوب ترین نرم افزار یادگیری انگلیسی از مبتدی تا پیشرفته با Learn to Speak English Deluxe 10
مجموعه آموزش زبان انگلیسی در خواب
آموزش نرم افزار VMware Workstation 7 – برنامه ای برای ایجاد و مدیریت ماشین های مجازی 
آموزش جامع Security Plus در 3 دی وی دی
فیلم آموزشی کامل نرم افزار تري دي مكس 3D MAX
فیلم دوره آموزشی ویژوال استدیو 2010 و دات نت و فریم ورک 4 Visual Studio 2010 and .NET Tutorials
مجموعه فیلم های آموزشی آیلتس Study English - IELTS Preparation Series 1-2-3 
آموزش جامع ویندوز 7
فیلم آموزشی ساخت و تعمیر کامپیوتر PC Build and Repair Video Training 
فیلم آموزش پرورش اندام Muscle and Fitness Home Training 
فیلم آموزش تعمیر لپ تاپ Laptop Repairing Video Training 
بهترین دوره آموزشی زبان انگلیسی BBC DVD English