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:(2073) Programming a Microsoft SQL Server 2000 Database - 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

Programming a Microsoft SQL Server 2000 Database
(Microsoft Training Course: 2073) - 5 days - £2640 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 provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000.
> Course outline
  1. SQL Server Overview
  2. Overview of Programming SQL Server
  3. Creating and Managing Databases
  4. Creating Data Types and Tables
  5. Implementing Data Integrity
  6. Planning Indexes
  7. Creating and Maintaining Indexes
  8. Implementing Views
  9. Implementing User-defined Functions
  10. Implementing Stored Procedures
  11. Implementing Triggers
  12. Programming Across Multiple Servers
  13. Query Performance
  14. Analyzing Queries Using Graphical SHOWPLAN
  15. Managing Transactions and Locks
Module 1: SQL Server Overview
  • What Is SQL Server
  • SQL Server Integration
  • SQL Server Databases
  • SQL Server Security
  • Working with SQL Server
Skills
  • Describe SQL Server 2000 and its supported operating system platforms.
  • Describe SQL Server Integration with Microsoft Windows 2000 and other server applications.
  • Describe SQL Server databases.
  • Describe SQL Server security.
  • Describe SQL Server querying, implementation, administration, and data warehousing activities, as well as client application design options.
top
Module 2: Overview of Programming SQL Server
  • Designing Enterprise Application Architecture
  • SQL Server Programming Tools
  • The Transact-SQL Programming Language
  • Elements of Transact-SQL
  • Additional Language Elements
  • Ways to Execute Transact-SQL Statement
Skills
  • Describe the concepts of enterprise-level application architecture.
  • Describe the primary SQL Server programming tools.
  • Explain the difference between the two primary programming tools in SQL Server.
  • Describe the basic elements of Transact-SQL.
  • Describe the use of local variables, operators, functions, control of flow statements, and comments.
  • Describe the various ways to execute Transact-SQL statements.
top
Module 3: Creating and Managing Databases
  • Creating Databases
  • Creating Filegroups
  • Managing Databases
  • Introduction to Data Structures
Skills
  • Create and configure a database.
  • Create a filegroup.
  • Manage a database and transaction log.
  • Describe how SQL Server uses data structures to store data.
top
Module 4: Creating Data Types and Tables
  • Creating Data Types
  • Creating Tables
  • Generating Scripts
Skills
  • Create and drop user-defined data types.
  • Create and drop user tables.
  • Generate a script.
top
Module 5: Implementing Data Integrity
  • Types of Data Integrity
  • Enforcing Data Integrity
  • Defining Constraints
  • Types of Constraints
  • Disabling Constraints
  • Using Defaults and Rules
  • Deciding Which Data Integrity Methods to Use
Skills
  • Describe the types of data integrity.
  • Describe the methods to enforce data integrity.
  • Determine which constraint to use and create constraints.
  • Define and use DEFAULT, CHECK, PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
  • Disable constraints.
  • Describe and use defaults and rules.
  • Determine which data integrity enforcement methods to use.
top
Module 6: Planning Indexes
  • Introduction to Indexes
  • Index Architecture
  • How SQL Server Retrieves Stored Data
  • How SQL Server Maintains Index and Heap Structures
  • Deciding Which Columns to Index
Skills
  • Describe why and when to use an index.
  • Describe how SQL Server uses clustered and nonclustered indexes.
  • Describe how SQL Server index architecture facilitates the retrieval of data.
  • Describe how SQL Server maintains indexes and heaps.
  • Describe the importance of selectivity, density, and distribution of data when deciding which columns to index.
top
Module 7: Creating and Maintaining Indexes
  • Creating Indexes
  • CREATE INDEX Options
  • Modifying Data
  • Maintaining Indexes
  • Introduction to Statistics
  • Using an Index to Cover a Query
  • Performance Considerations
  • Using Index Tuning Tools to Improve Query Performance
Skills
  • Create indexes and indexed views with unique or composite characteristics.
  • Use the CREATE INDEX options.
  • Describe how adding, updating, and deleting data physically affects SQL Server indexes.
  • Use various tools and verification features to maintain indexes and enhance their optimal performance.
  • Understand how the query optimizer creates, stores, maintains, and uses statistics.
top
Module 8: Implementing Views
  • What Is a View?
  • Advantages of Views
  • Defining Views
  • Partitioned Views and Scaling Out
  • Security
  • Modifying Data Through Views
  • Performance Considerations
Skills
  • Define a view with the CREATE VIEW statement.
  • Alter and drop a view definition.
  • Describe the characteristics and implications of a broken ownership chain.
  • Locate view definition information.
  • Create partitioned views.
  • Optimize view security.
  • Modify a source table by using a view.
top
Module 9: Implementing User-defined Functions
  • Creating, Executing, and Altering User-defined Functions
  • Using User-defined Functions with MDX
  • UDF Permissions
  • Using User-defined Functions with Dynamic/Static Filters
  • Developing User-defined Functions for XML
Skills
  • Create, execute, and alter user-defined functions.
  • Create user-defined functions with the MDX language.
  • Control security with Uniqueness Database File (UDF) permissions.
  • Describe the use of dynamic and static filters.
  • Develop user-defined functions for XML.
top
Module 10: Implementing Stored Procedures
  • Introduction to Stored Procedures
  • Creating, Executing, and Modifying Stored Procedures
  • Using Parameters in Stored Procedures
  • Executing Extended Stored Procedures
  • Handling Error Messages
  • Performance Considerations
Skills
  • Describe how a stored procedure is processed.
  • Create, execute, modify, and drop a stored procedure.
  • Create stored procedures that accept parameters.
  • Execute extended stored procedures.
  • Create custom error messages.
top
Module 11: Implementing Triggers
  • Introduction to Triggers
  • Defining Triggers
  • Examples of Triggers
  • Performance Considerations
Skills
  • Describe the purpose of triggers.
  • Create, alter, and drop a trigger.
  • Use nested, recursive, and INSTEAD OF triggers to enhance the ability to enforce data integrity and business rules.
top
Module 12: Programming Across Multiple Servers
  • Security
  • Distributed Queries
  • Distributed Transactions
  • Partitioned Views
Skills
  • Design security for a multi-server environment.
  • Construct and use distributed queries.
  • Construct and use distributed transactions.
  • Design and implement partitioned views.
top
Module 13: Query Performance
  • Introduction to the Query Optimizer
  • Obtaining Query Plan Information
  • Indexing Strategies
Skills
  • Explain the role of the query optimizer and how it works.
  • Obtain query plan information to determine how the query optimizer processed a query.
  • Validate that the most efficient query plan was generated.
  • Implement indexing strategies to reduce page reads.
  • Design indexes that can benefit from using query optimizer.
top
Module 14: Analyzing Queries Using Graphical SHOWPLAN
  • Queries That Use the AND Operator
  • Queries That Use the OR Operator
  • Queries That Use Join Operations
  • Evaluating Query Performance
Skills
  • Analyze the performance gain of writing efficient queries and creating useful indexes for queries that contain the AND logical operator.
  • Analyze the performance gain of writing efficient queries and creating useful indexes for queries that contain the OR logical operator.
  • Evaluate how the query optimizer uses different join strategies for query optimization.
top
Module 15: Managing Transactions and Locks
  • Introduction to Transactions and Locks
  • Managing Transactions
  • SQL Server Locking
  • Managing Locks
  • Deadlocks
Skills
  • Describe transactions and locks.
  • Manage transactions by executing, canceling, or rolling back.
  • Identify locking concurrency issues.
  • Identify resource items that can be locked and the types of locks.
  • Describe lock compatibility.
  • Manage locks by setting locking options and displaying locking information.
  • Identify and minimize deadlocks.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
> Purpose
At the end of the course, students will be able to describe the elements of SQL Server 2000, design a SQL Server enterprise application architecture, describe the conceptual basis of programming in Transact-SQL, create and manage databases and their related components, implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers, plan for the use of indexes, create and maintain indexes, create, use, and maintain data views, implement user-defined functions, design, create, and use stored procedures, create and implement triggers, program across multiple servers by using distributed queries, distributed transactions, and partitioned views, optimize query performance, analyze queries by using Graphical Showplan, and manage transactions and locks to ensure data concurrency and recoverability.
> EXAMS
There are no exams directly associated with this course