0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Comprehensive Introduction: Hands-On

 
Course: 530   Type: Hands-On Training   Duration: 4 Days
 
 

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

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

Related Courses

  • 531 SQL Server 2000 Database Administration
  • 532 SQL Server 2000 Transact-SQL Programming
  • 534 SQL Queries for SQL Server
  • 523 SQL Server Reporting Services
  • 535 High-Performance SQL Server Databases
  • 539 Deploying Clusters on Windows Server 2003
  • 381 Business Process Re-engineering
  • 296 Project Management: Skills for Success

 
SQL Server is a trademark of Sybase, Inc.
   SQL Server 2000 Comprehensive Introduction

Upcoming Dates

7 - 10 Oct, 2008
London
6 - 9 Jan, 2009
London
31 Mar - 3 Apr, 2009
London
14 - 17 Jul, 2009
London

For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk530.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Comprehensive Introduction: Hands-On

 
Course: 530   Type: Hands-On Training   Duration: 4 Days
 
 
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 Analyser
  • 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 Analyser

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
 
http://www.learningtree.co.uk/courses/uk530.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Comprehensive Introduction: Hands-On Tuition

 
Course: 530   Type: Hands-On Training   Duration: 4 Days
 
 

Course 530 Tuition

£ 1,695Standard Tuition
Tuition with a Savings Plan
£ 98010-Day Training Pass
£ 915Flex-Training Pass
£ 1,46010-Training Vouchers
£ 1,5605-Training Vouchers
£ 1,525Alumni Gold Tuition

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Lunch
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2 750
  • As little as £915
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £770 per course
  • Any combination of courses
  • Only £2,450
Training Vouchers
  • Save as much as £535 per course
  • Fully transferable
  • As low as £1,460 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £200 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk530.htm