|
Provided by: Affinity IT Training, LLC Extended Features In Microsoft SQL Server 2000 Level 3 |
 |
Training
Provided by Affinity IT Training, LLC
Presents and explains advanced features, tools, and capabilities
of SQL Server 2000,
including Data Transformation Services, XML formatting, Replication,
Automated Administration, and Data Mining.
Audience:Experienced Programmers already familiar with SQL Server 2000 seeking to take advantage of advanced features and capabilities.
|
|
||||||||||
Extended Features In Microsoft SQL Server 2000 Level 3
Objectives
- Be prepared to utilize SQL Server 2000 Data Transformation Services
- Be prepared to read and write XML data
- Be familiar with the purpose and capabilities of System Objects
- Understand how to automate Database Administration tasks using SQL Agent
- Understand how to publish SQL Server 2000 data to web applications
- Be familiar with how to configure and conduct Data Mining using SQL Server 2000
Outline
Using System Objects
Exploring System Objects
Using System Functions
Using Information Schema Views
Using System Stored Procedures
How To Find What You're Looking For
Extended Stored Procedures
DBCC
Using DBCC CHECKDB
Locating DBCC Commands
Does a Table Exist ?
Using Extended Stored Procedures
Automating Administration with SQL Agent
Configuring SQL Server Agent
Setting SQL Server Agent Properties
Operators
Jobs
Alerts
Create an Operator
Create a Job
Create an Alert
Data Transformation Services (DTS)
What is DTS ?
When to use DTS
The DTS Import/Export Wizard
Saving and Scheduling a DTS Package
DTS Packages
The DTS Designer
DTS Package Components
Connection Objects
The Transform Data Task
Other Built-In Tasks
Controlling DTS Workflow
Precedent Constraints
DTS Transactions
Error Handling
Custom ActiveX Scripts
Setting Up a Transformation Task
Adding an ActiveX Scripting Task
Replication
What is Replication ?
How Replication Works
Replication Terminology
Replication Topologies
Replication Pre-requisites
Replication Components
Replication Methods
Snapshot Replication
Transactional Replication
Merge Replication
Why Bi-directional Replication is Bad
Transformable Subscriptions
Determining the Best Replication Scenario
Implementing Replication
Configuring Your SQL Server for Replication
Create a Publication
Pushing a Subscription
Configuring Replication
Creating Publications and Subscriptions
Publish SQL Server Data to the Web
Publishing Data to the Web
Overview
The Web Assistant Wizard
Publishing Data
Setup
- Access to an SQL Server 2000 Database Server
- Accounts and databases for all Students and Instructor
Seminar Pre-Requisites
- Programming Databases with SQL Server 2000
Training Materials
- Course Workbook
Jan06
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
