A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Exclusive
SQL Server

Microsoft SQL Server 2000 for Experienced Database Professionals
(Microsoft Training Course: 2723) - 3 days - £1700 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server 2000 and how it works. It is for database administrators who are experienced and proficient with enterprise database products such as Oracle, DB2, or Sybase and current database administrators who are experienced with Microsoft SQL Server 6.5 and earlier.
> Course outline
  1. SQL Server Product Overview
  2. SQL Server Components
  3. SQL Server Storage Subsystems
  4. SQL Server Administration
  5. Backup and Restore
  6. SQL Server Security
  7. Monitoring SQL Server
  8. Transferring and Analyzing Data
  9. Additional Resources
Supplementary Information This course has now retired and is no longer available. We suggest you look at Course 6317: Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008.
Module 1: SQL Server Product Overview
  • Introduction to SQL Server Architecture
  • SQL Server Programming Environment
  • Lab: Working with SQL Server Tools
  • Using SQL Server Enterprise Manager and SQL Query Analyzer
  • Creating Columns That Have the Identity Data Type
  • Creating Columns That Have the Uniqueidentifier Data Type
  • Working with Metadata
  • Retrieving XML Result Sets
Skills
  • Describe the architecture of SQL Server and its programming environment.
  • Describe the architecture of SQL Server in terms of its major components and tools.
  • Describe the SQL Server programming environment.

top
Module 2: SQL Server Components
  • Relational Engine
  • Analyzing Query Plans
  • Memory and Processes
  • Client Connectivity
  • Lab: Creating Databases
  • Lab: Configuring, Troubleshooting, and Tuning
Skills
  • Describe key components of SQL Server RDBMS architecture.
  • Describe SQL Server components.
  • Describe relational engine architecture.
  • Describe tools and methods that are used to maintain efficient queries.
  • Describe query execution plans and how SQL Server can optimize them.
  • Describe memory architecture and management.
  • Describe SQL Server threads and process management.
  • Describe the process, tools and techniques for connecting clients to SQL Server.
top
Module 3: SQL Server Storage Subsystems
  • SQL Server Storage Structures
  • SQL Server Index Architecture
  • Managing Indexes
  • Working With Statistics
  • Lab: Examining Disk Storage Structures
  • Examining Indexes by Using DBCC Page
  • If Time Permits: Examining Heaps by Using DBCC Page
Skills
  • Describe key components of SQL Server storage subsystem architecture.
  • Describe SQL Server storage architecture.
  • Describe SQL Server index architecture.
  • Manage SQL Server indexes.
  • Describe approaches to working with statistics.
top
Module 4: SQL Server Administration
  • Administering SQL Server by Scripting and Using SQL Server Enterprise Manager
  • Automating Administration by Using SQL Server Agent and Jobs
  • Creating and Using Alerts
  • Using Multiserver Jobs
  • Lab: osql Scripting
  • Lab: Using SQL Server Agent
  • Lab: Creating Alerts and Multiserver jobs
Skills
  • Describe typical job tasks to administer and manage SQL Server in a multiple server environment.
  • Describe typical administrative tasks for SQL Server using SQL Server Enterprise Manager, maintenance plans, and scripting.
  • Describe how to create and use SQL Server Alerts.
  • Describe how to administer multiple servers as master and target servers.
top
Module 5: Backup and Restore
  • SQL Server Recovery Models
  • SQL Server Backups
  • Restoring Backups
  • Lab: Backup and Restore
  • Creating Routine Database Backups
  • Restoring a Database Using Full, Differential, and Log Backups
  • If Time Permits: Restoring to a Point in Time
Skills
  • Describe database recovery models.
  • Describe the SQL Server back up-and-restore process and operations.
top
Module 6: SQL Server Security
  • SQL Server Security Architecture
  • Securing SQL Server
  • Common Security Issues
  • Lab: Applying Security Measures to SQL Server and Database Objects
  • Assigning Statement Permissions
  • Assigning Object Permissions
  • Securing an Installation of SQL Server
Skills
  • Describe the process of controlling data access and securing SQL Server.
  • Describe security architecture and methods of control.
  • Describe methods of securing SQL Server.
  • Describe common security issues and methods for resolving them.
top
Module 7: Monitoring SQL Server
  • Monitoring System and Server Activity
  • Managing Locks
  • Additional Performance Considerations
  • Lab: Monitoring and Troubleshooting SQL Server Performance
  • Lab: Contrasting Cursors and Table Variables
Skills
  • Describe tools and methods that you can use to monitor system and server activity.
  • Describe the tools and methods that you can use to manage locks.
  • Describe items that may affect performance in SQL Server.
top
Module 8: Transferring and Analyzing Data
  • Distributed Queries
  • Data Extraction, Transformation, and Loading Tools
  • Analysis Services
  • Lab: Working with External and Remote Data
  • Transferring Database Contents to a Database with a Different Collation
  • Transforming Data During Extraction and Load
  • Querying Distributed Data
  • If Time Permits: Transferring Bulk Data Into and Out of SQL Server
Skills
  • Describe how to access homogenous and heterogeneous data sources.
  • Describe the processes and tools for moving data into and out of SQL Server.
  • Describe the processes and tools for analyzing data in SQL Server, using Analysis Services.
top
Module 9: Additional Resources
    top
    > Pre-Requisites
    Before attending this course, students must have the following prerequisites:
    • Database administrators who are experienced in Oracle, DB2, or Sybase. These database administrators have a technical depth of understanding of the database management systems (DBMS) that they currently administer, implement, and manage, and want to apply their database skills to SQL Server 2000.
    • Database administrators who are experienced in Microsoft SQL Server 4.2x, 6.0, or 6.5. (Secondary): These database administrators have a technical depth of understanding of the database systems that they currently administer, implement, and manage, and want to apply their current skills to SQL Server 2000.
    • To be successful in this class, students should have experience in administration and implementation of departmental or enterprise relational database management systems (RDBMS).
    > Purpose
    After completing this course, students will be able to describe the architecture of SQL Server and its programming environment; describe the key components of SQL Server architecture; describe the key components of SQL Server storage subsystem architecture; describe the typical job tasks to administer and manage SQL Server in a multiple server environment; describe the process of developing a data recovery plan; describe the process of controlling data access and securing SQL Server; describe the tools and methods to monitor system and server activity; describe the tools and methods use to manage locks; describe the items that may affect performance in SQL Server; describe how to access homogenous and heterogeneous data sources; describe the processes and tools for moving data into and out of SQL Server; describe the processes and tools for analyzing data in SQL Server, using Analysis Services.
    > Supplementary Information
    This course has now retired and is no longer available. We suggest you look at Course 6317: Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008.
    > EXAMS
    There are no exams directly associated with this course