SQL Server 2005 tutorials : learn quickly/cost-effectively with this 'SQL Server 2005' training course.

CBT Training IT Training Course Specialists
 
Classroom Training Distance Learning / Correspondence Courses eBooks Kid's CDs Learning Management System Reference Material Web Based Training
 Microsoft SQL Server 2005 Administration Tutorial CBT Course (Prices exclude VAT)
[to previous page]   [other products in "Other IT Courses"]
Microsoft SQL Server 2005 Administration Tutorial CBT Course or a generic image.   larger image of Microsoft SQL Server 2005 Administration Tutorial CBT Course (if available)
   Product: Microsoft SQL Server 2005 Administration Tutorial CBT Course
Microsoft Certified Database Administrator and Certified Trainer Mark Long covers the basics of SQL Server 2005 administration in this course with the aim of helping you feel at ease with SQL Server 2005 in the shortest time possible.
Price:
  UK Delivery    £84.95 
  FEDEX delivery outside UK    £129.95 
 
Details:

Duration: 7 hrs / 92 video lessons

Tutorial Intro

  • Intro
  • SQL Server - The Basics
  • SQL Server History
  • Course Objectives
  • Transact SQL Explained
  • Tutorial Overview
  • SQL Server Mystique

SQL Server 2005 Installation

  • SQL Server 2005 Editions
  • Installation Preparation SQL Server 2005
  • H/W Requirements
  • Working With Previous Versions
  • SQL Server 2005 Installation
  • Installing SQL Server 2005 - Tuition 1
  • Installing SQL Server 2005 - Tuition 2
  • Changing and Deleting SQL Server
  • Default and Named Instances
  • Gaining Assistance

Administrative Tools

  • Management Studio Overview
  • Registering Servers
  • Object Explorer
  • Executing TSQL Queries
  • Management Studio Solutions
  • Server Config Manager
  • SQLCMD
  • SQLCMD Variables
  • Dedicated Admin Connection

SQL Server Security

  • Securing SQL Server 2005
  • Authentication Modes - Tuition 1
  • Authentication Modes - Tuition 2
  • Principles Overview
  • Permissions Explained
  • Securables
  • Handling Logins
  • Handling Users
  • Schemas
  • Managing Schemas
  • Managing Permissions - Step by Step
  • Managing Server Permissions
  • Managing Database Permissions
  • TSQL Permissions

System Databases

  • Chapter Overview
  • System Database Concerns
  • Sample Database

Databases

  • Creating A Database - Lesson 1
  • Creating A Database - Lesson 2
  • Database Properties and Database Options
  • How to Generate Scripts
  • Shrinking Database Files
  • The Creation of Tables - Lesson 1
  • The Creation of Tables - Lesson 2
  • Datatypes - Lesson 1
  • Datatypes - Lesson 2
  • Primary & Foreign Keys
  • Diagrams

Transaction Logs

  • Transaction Logs Explained
  • Transactions Explained
  • Explicit Transactions
  • Implicit Transactions
  • Location, Location, Location
  • The Advantage Of Using Transactions Logs
  • Transaction Log Options Explained

Data Storage

  • How SQL Server Stores Data
  • Fillfactor Explained
  • DBCC Showcontig

SQL Profiler

  • Profiler
  • Using SQL Profiler - Lesson 1
  • Using SQL Profiler - Lesson 2

Automating SQL Server

  • Chapter Overview
  • SQL Server Agent Service
  • Creating Operators
  • Creating Jobs - lesson 1
  • Creating Jobs - lesson 2
  • How to Create Alerts
  • Considerations for Alerts

Database Backups

  • Backup Strategy
  • Database Recovery Models Explained
  • Which Files and When
  • How to Perform A Backup
  • SQL Backup Statement
  • Taking Transaction Log Backups
  • Backup Types Described

Restoring Data

  • SQL Server Recovery Process
  • How to Restore A Database
  • The Restore Statement

High Availability

  • SQL Server High Availability
  • Clustering
  • Using Standby Servers
  • Log Shipping
  • Database Mirroring Explained

Database Maintenance

  • Memory Management Fundamentals
  • Maintenance Plan Creation

Course Wrap-Up

  • Tutorial Wrap-Up

Similar    
Products:
SQL Server 2005 Update Training for Database Administrators (on DVD)
SQL Server 2005 Update Training for Database Developers
MCP Exam #70-431 - Implementing & Maintaining a Microsoft SQL Server 2005 Database
MCP Exam #70-441 - Designing Microsoft SQL Server 2005 Databases & Server-Side Solutions
Microsoft SQL Server 2000 Admin CD Training Course

2Gb USB 2.0 Flash Drive on Special Offer.

What's Hot
 ***Special offers ***
•  A+ 2009 Training
•  Office 2010 Training
•  Project 2007 Training
•  Network+ 2009 Training
•  Office 2007 Essentials Training
•  Office 2003 Essentials Training
•  Project 2003 Essentials Training
•  CCNA Training (640-802)
•  Sage Line 50 Training
•  ITIL v3 Foundation Training
 **Recent Additions**
RCS Newsletter
*Verify: 2664298

New Articles

Child Care Courses
MCSE Training Courses
Dedicated Servers
Accounting Software
Choosing Software
Backup Software


Settings, Tip & Tricks
ComputerArticles
Biodiesel Energy
Computer Training
PPE Safety Equipment
Learn English (Basic)

From the Best Seller List : ITIL v3 Foundation Training - The ITIL v3 Foundations training course maps directly to the exam objectives and offers numerous features such as exam tips, case studies, and practice exams.

CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2011 RCS Limited. All rights reserved. More ...
RCS Limited for home study/ self study/home learning/CBT/Computer Based Training SSL