1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2000 Comprehensive Introduction: Hands-On

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

Quick Enroll    

You Will Learn How To
  • Utilize 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 SQL Server 2000, or those evaluating it, can benefit from this course. 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 530 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 names 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
  • Authorizing 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

Related Courses
SQL Server is a trademark of Sybase, Inc.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $2,350 on a Triple-Pack!

SQL Server 2000 Comprehensive Introduction: Hands-On
Upcoming Dates
Jul 15 - 18, 2008
 New York

SQL Server 2000 Comprehensive Introduction: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,660 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

SQL Server 2000 Comprehensive Introduction: Hands-On
SQL Server 2000 Comprehensive Introduction: Hands-On
Participants submitting an XML request to SQL Server 2000.

Certification Core Course CPE 23 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733