Course not currently available
SQL Server 2008 Administration Training Course
Course
In Swansea ()
Description
-
Type
Course
This SQL Server Administration training course teaches students how to administer a SQL Server 2008.
Objectives
Install and configure Microsoft SQL Server
Create databases and tables
Implement indexes and partitions
Take database snapshots
Implement service broker for asynchronous processing of database requests
Create and use full-text indexes
Secure SQL Server and implement policy-based management
Recover data
Automate administrative tasks with the SQL Server Agent
Use Dynamic Management Views to monitor the database and troubleshoot problems
Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication
About this course
None
Reviews
Subjects
- Business Intelligence
- Install
- XML
- Performance Management
- Contracts
- Server
- Database
- SQL
- Database training
- Shipping
Course programme
- Database Engine
- Business Intelligence
- Editions of SQL Server
- Infrastructure Requirements
- Service Accounts
- Collation Sequences
- Authentication Modes
- SQL Server Instances
- Upgrading to SQL Server
- Installing SQL Server
- SQL Server Documentation
- Management Tools in SQL Server
- Performance Management Tools
- Business Intelligence Tools
- SQL Server System Databases
- SQL Server Database Structure
- Creating a Database
- Moving Databases
- Naming Objects
- Schemas
- Data Types
- Column Properties
- Creating Tables
- Computed Columns
- Sparse Columns
- Constraints
- Database Diagrams
- Index Structure
- Clustered Indexes
- Nonclustered Indexes
- Included Columns
- Filtered Indexes
- Online Index Creation
- Index Management and Maintenance
- XML Indexes
- Spatial Indexes
- Partition Functions
- Partition Schemes
- Partitioning Tables and Indexes
- Managing Partitions
- Creating a Database Snapshot
- Reverting Data Using a Database Snapshot
- Service Broker Architecture
- Message Types and Contracts
- Queues and Services
- Conversations
- Sending and Receiving Messages
- Queue Activation
- Prioritization
- Full-Text Catalogs
- Full-Text Indexes
- Querying Full-Text Data
- Configuring the Attack Surface
- Endpoints
- Principals, Securables, and Permissions
- CLR Security
- Data Encryption
- Overview of Policy-Based Management
- Facets
- Conditions
- Policy Targets
- Policies
- Policy Categories
- Policy Compliance
- Database Backups
- Recovery Models
- Database Restores
- Creating Jobs
- Creating Maintenance Plans
- Creating Alerts
- Overview of DMVs
- Retrieving Object Metadata
- Database Diagnostics
- Failover Clustering
- Database Mirroring
- Log Shipping
- Replication
Additional information
SQL Server 2008 Administration Training Course