Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

SQL Server 2000 Comprehensive Introduction: Hands-On

Course: 530   Type: Hands-On   Duration: 4 Days
Quick Enrol  

You Will Learn How To

  • Utilise the key components of SQL Server 2000
  • Implement a database schema with SQL Server Enterprise Manager
  • Retrieve and modify data with SQL tools
  • Replicate data between databases
  • Query SQL Server from the Web using XML
  • Migrate data from diverse sources with DTS

Course Benefits
Microsoft's SQL Server 2000 offers ease of use and scalability, XML integration, improved data transformation and analysis services. In this hands-on course, you explore many of the SQL Server 2000 capabilities using the graphical tools provided by Microsoft. You gain a solid foundation on which to build specific SQL Server 2000 database development or administration skills.

Who Should Attend
This course is valuable for those interested in, or evaluating, SQL Server 2000. Familiarity with relational databases is helpful.

Hands-on Training
Exercises provide immediate experience in developing and administering SQL Server systems, including:
  • Creating databases with Enterprise Manager
  • Adding primary and foreign key constraints to tables
  • Retrieving data using Query Designer
  • Performing backups and recovering from disasters
  • Replicating data with merge replication
  • Generating HTML files from triggers
  • Building a cube and dimensions with Analysis Services
  • Using HTTP to extract XML data from SQL Server

Course Content
SQL Server 2000 Overview
Overview of database concepts
  • Client/Server
  • RDBMS
  • Entity relationship diagramming
SQL Server components
  • Database engine
  • SQL Server Agent
  • Analysis Services
  • Data Transformation Services (DTS)
SQL Server editions
  • Personal
  • Server
  • Enterprise
  • Desktop Engine
  • Windows CE
Client tools
  • Enterprise Manager
  • Query Analyzer
  • Query Designer
  • Wizards
Constructing a Database Schema with Enterprise Manager
Using the Create Database Wizard
  • Selecting file name and locations
  • Determining file size and growth parameters
Designing tables
  • Choosing appropriate datatypes
  • Identifying primary keys
  • Adding and removing columns
  • Applying declarative constraints
Developing Database Applications
Retrieving data
  • Creating SQL queries
  • Sorting and selecting result sets
  • Joining tables
  • Aggregating data
  • Defining and using full-text indexes
Modifying data
  • Adding and deleting rows
  • Updating existing rows
Storing query definitions
  • Creating views with Query Designer
  • Selecting data from a view
  • Building a stored procedure with wizards
  • Invoking stored procedures in Query Analyzer
Administering Databases
Setting up security
  • Adding SQL Server logins with the Login Wizard
  • Authorising access to databases
  • Granting and revoking permissions
  • Assigning administrator roles
Maintaining the database
  • Backing up and recovering databases
  • Database Maintenance Plan Wizard
Automating administration procedures
  • Scheduling jobs
  • Responding to events using alerts
  • Defining operators
  • Reporting job success or failure
Transferring Data
Migrating data with DTS
  • Importing data into SQL Server
  • Upsizing Access databases
  • Exporting data to text or CSV format
Replicating databases
  • Replication strategies
  • Subscribing to a publishing server
  • Empowering mobile users with merge replication
  • Resolving conflicts using priorities
Publishing Data on the Web
Web Assistant Wizard
  • Building static Web pages using templates
  • Triggering a Web page refresh
Streamlining Web development with XML
  • Creating a Virtual Directory
  • Generating XML from HTTP
Moving Beyond the Database
Analysis Services
  • Storing multidimensional data
  • Browsing cubes in Microsoft Excel
Microsoft SQL Server 2000 Reporting Services
  • Authoring and deploying reports
  • Viewing reports from a Web site
SQL Server is a trademark of Sybase, Inc.
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
SQL Server 2000 Comprehensive Introduction
Course Schedule
15 - 18 Jul, 2008
London
7 - 10 Oct, 2008
London
6 - 9 Jan, 2009
London
31 Mar - 3 Apr, 2009
London

Participants submitting an XML request to SQL Server 2000.

£ 1,695 - Standard Tuition
Savings Plans
£ 1,080 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 1,215 - 10-Training Vouchers
£ 1,300 - 5-Training Vouchers
£ 1,525 - Alumni Gold Tuition

 
Certification Core Course
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610