CourseMonster
To speak to a training advisor please call
0800 40 848 40
training@coursemonster.co.uk
Browse Microsoft Training Courses

Microsoft SQL Server 2005 2008: Database Administration (DBA) Upgrade

Course Code: SQL0030      Days: 3
Show all Microsoft Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Greater London
Whetstone (N20) 12/04/10 £ 1,395
Prices exclude VAT.
No suitable dates?
I'd like a different date/location

Please click above and we will take care of the rest.

I’d like an onsite/bespoke course

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

Our 3-day upgrade course for DBAs with current skills in SQL Server 2000 will bring delegates up to speed with the essentials of setting up, maintaining and getting the most out of Microsoft's flagship database server.

Because of the similarities in architecture and functionality between SQL Server 2005 and SQL Server 2008, those delegates upgrading from SQL Server 2000 or coming across from Oracle or Sybase platforms will have the opportunity to get hands-on experience on their platform of choice. Demonstrations and course labs will either be on SQL 2005 or SQL 2008 with any specific differences being demonstrated where necessary (usually in a short session at the end of each day). Delegates with some experience of SQL Server 2005 may find this course a useful refresher, and a chance to take on board SQL Server Best Practices.

This course has been developed for real-world, commercial scenarios by our expert instructors.

Audience

Experienced SQL Server 2000 Administrators (or DBAs with good experience of other SQL-based platforms such as Oracle or Sybase)

Prerequisites

Delegates should have a good background knowledge of SQL Database Administration.

See also our SQL Server 2008 Comprehensive Upgrade Course for SQL Server 2005 specialists

Course Outline

SQL Server 2005 / SQL Server 2008 Overview

  • New Features for Administrators
  • Availability and Scalability Features
  • Security Features
  • Data Management Features
  • Administration and Maintenance Features
  • Development Features
  • To enable SQLiMail
  • Testing mail delivery

Installing SQL Server 2005 / SQL Server 2008

  • SQL Server 2005 / SQL Server 2008 Editions
  • Installing Microsoft SQL Server
  • System Requirements
  • Preparing for a SQL 2005 Installation
  • Installation Checklist
  • Setup Features
  • Using the System Consistency Checker
  • Component Install
  • Unattended Installation
  • Installation Sequence
  • Installation Maintenance
  • Upgrading from previous versions of SQL Server
  • Retaining SQL 2000
  • To verify the Installation

Administrative Tools

  • Upgrading to SQL Server Management Studio
  • Management Studio Windows
  • Registered Servers
  • Object Explorer
  • Review Database Objects
  • Modify Database Properties
  • Create Database Scripts
  • The Maintenance Plans Node
  • Solution Explorer
  • Query Editor
  • Template Explorer
  • Dynamic Help
  • Upgrading to SQL Server Computer Manager
  • SQL Server 2005 / SQL Server 2008 Services node
  • SQL Server 2005 / SQL Server 2008 Network Configuration node
  • SQL Server 2005 / SQL Server 2008 Native Client Configuration node
  • The SQLCMD Management Utility
  • SQLCMD Syntax
  • SQLCMD Variables
  • Dedicated Administrative Connection
  • SQL Server Management Studio SQLCMD Mode
  • Using SQL Management Objects
  • SMO Object Model

Monitoring the Database Server

  • Monitoring with SQL Profiler
  • DDL Triggers
  • Using DDL Triggers
  • Managing DDL Triggers
  • Managing DDL Triggers from TSQL
  • Managing DDL Triggers from Management Studio
  • DDL Event Notifications
  • Handling Events
  • Creating an Event Notification
  • Managing Event Notifications
  • Managing Metadata Views
  • Metadata Storage
  • System Views
  • Information Schema
  • Catalog Views
  • Sys All
  • Dynamic Management Views
  • System Stored Procedures

Database and Index Maintenance

  • Index Management
  • New Index Features
  • Creating Indexes
  • Online Index Maintenance
  • Parallel (multiple CPU) Index Operations
  • Lock Options
  • Included Columns in Indexes
  • Partitioned Tables and Indexes
  • XML Index Support
  • Altering an Index
  • Rebuilding an Index
  • Reorganising an Index
  • Disabling an Index
  • Dropping an Index
  • Index Fragmentation
  • Using the Database Tuning Advisor

Securing SQL Server 2005 / SQL Server 2008

  • Implementing Securables
  • New Security Features
  • Principals
  • Securables
  • Permissions
  • Permission Types
  • Managing Logins
  • Managing Users
  • Managing Schemas
  • Schema Definition
  • Using Schemas
  • Managing Execution Context
  • Managing Permissions
  • Manage Server Permissions
  • Manage Server-Scope Securable Permissions
  • Manage Database Permissions
  • Manage Database-Scope Securable Permissions
  • Managing Certificates
  • Native Data Encryption
  • Code and Module Signing

SQL Server Disaster Recovery

  • Disaster Recovery
  • SQL 2005 Disaster Recovery Feature
  • Enhanced Features
  • Database Snapshots
  • Creating a Snapshot
  • Common Snapshot Applications
  • Undeleting table rows
  • Undoing a table update
  • Recovering a dropped object
  • Backup and Restore
  • Backup Changes
  • Restore Changes
  • Media Integrity Changes
  • Recovering the MASTER Database
  • Create a mirrored backup
  • Restore from the backup mirror
  • Create a snapshot
  • Restore the snapshot data
  • Automate the creation of daily snapshots

Enhancing Database Availability

  • SQL 2005 Data Availability
  • Database Mirroring
  • The Witness Server and Automatic Failover
  • Configuring Database Mirroring
  • Transaction Safety Level
  • Operating Modes
  • High Availability Operating Mode
  • High Protection Operating Mode
  • High Performance Operating Mode
  • Mirroring Security
  • Monitoring Mirroring
  • Database States for Database Mirroring
  • Prepare the Servers
  • Configure Mirroring
  • Verify Principal and Mirror Access
  • Execute the Mirror Failover
  • Verify Mirror and Witness Status
  • Terminating the Mirror Session

Replicating Information

  • Replication Enhancements
  • Stand-alone Replication Monitor
  • Support for Oracle Publishing
  • HTTP Synchronisation for Merge Replication
  • Subscriber Initialisation
  • Replicating DDL Statements
  • Modified User Interface
  • Replication Management Objects
  • To Configure Publishing and Distribution
  • Configuring Peer-to-Peer Replication
  • Create a Publication
  • Create a Subscription with RMO

SQL Server 2005 / SQL Server 2008 Integration Services

  • Creating the Database Objects
  • Creating a Package Using Business Intelligence Studio
  • Integration Services Project Template
  • OLE DB Command object
  • Column Mappings
  • Adding a Data Viewer

Enhanced TSQL Commands

  • SQL Server 2005 / SQL Server 2008 T-SQL Enhancements
  • Ranking Functions
  • ROW_NUMBER()
  • TOP
  • Recursive Queries
  • New Relational Operators: PIVOT/UNPIVOT/APPLY
  • Exception Handling TRY/CATCH

Messaging with the Service Broker

  • SQL Server Service Broker
  • The Dialog Protocol
  • Service Broker Components
  • Messages
  • Dialog - Conversations
  • Conversation Groups
  • End Point
  • Service Broker Security
  • Service Broker inside the Database
  • Message Types
  • Contracts
  • Queues
  • Services
  • Routes
  • Remote Service Bindings

Follow On Courses

Associated Courses

  • Microsoft Business Intelligence Training Course (SQL Server 2008 SSRS / SSAS / SSIS)
  • SQL Server 2008 Reporting Services Fundamentals Training Course
  • SQL Server 2008 Analysis Services Fundamentals Training Course
  • SQL Server 2008 Integration Services Fundamentals Training Course
  • Microsoft Business Intelligence Training Course (SQL Server 2005 / SQL Server 2008 SSRS / SSAS / SSIS)
  • SQL Server 2005 / SQL Server 2008 Reporting Services Fundamentals (SSRS) Training Course
  • SQL Server 2005 / SQL Server 2008 Analysis Services Fundamentals (SSAS) Training Course
  • SQL Server 2005 / SQL Server 2008 Integration Services (SSIS) Training Course
  • Advanced Microsoft Business Intelligence with SSAS & PerformancePoint Server 2007 Training
  • Advanced SQL Server Analysis Services Training Course
  • Microsoft Performance Point 2007 Training Course - Visualising Business Intelligence
  • SQL Server 2008 Upgrade Training Course for existing SQL Server 2000 / SQL Server 2005 Developers & DBAs
  • SQL Server 2005 / SQL Server 2008 Applications Development Fundamentals training course
  • SQL Server 2005 / SQL Server 2008 Database Administration Training Course
  • SQL Server 2005 / SQL Server 2008 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle / MySQL users


How to make a booking for the SQL0030 course
 

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.