Advanced Microsoft SQL Server Training
Unfiled
Training
Provided by Webucator
This advanced SQL Server training course teaches students how to use Data Transformation Services, SQL Server Replication, SQL Server's Web publishing and XML features, and SQL Server's Analysis Services .
|
|
||||||||||||||||
Advanced Microsoft SQL Server Training
Course Outline
- Using System Objects
- Exploring System Objects
- DBCC
- Automating Administration with SQL Agent
- Configuring SQL Server Agent
- Operators
- Jobs
- Alerts
- Create an Alert
- Data Transformation Services (DTS)
- Introduction
- The DTS Import/Export Wizard
- DTS Packages
- Controlling DTS Workflow
- Replication
- Introduction to Replication
- Implementing Replication
- Publish SQL Server Data to the Web
- Publishing Data to the Web
- The Web Assistant Wizard
- The SQL Server Web Stored Procedures
- Scheduling Web Jobs
- XML Features
- XML Fundamentals
- Generating XML from SQL Queries with FOR XML
- Using FOR XML Explicit
- Setting Up IIS for SQL Server
- Accessing SQL Server Using a URL
- Creating XML Views with Annotated Schemas
- Using Xpath to Retrieve SQL Server Data Directly
- Using OpenXML to Work with XML Documents in Transact-SQL
- Using Updategrams
- Full Text Search
- What is Full-Text Search?
- Configuring Full-Text Search
- Writing Full-Text Querries
- Using Full-Text Search with Documented Stored in SQL Server
- Analysis Services
- Understanding Analysis Services
- Building a Simple Cube
- Browsing Data from a Cube
- Exploring MDX
- Data Mining
- English Query
- Overview of English Query
- Before You Start - Preparing Your Database
- Creating and English Query Application
- Deploying an English Query Application
About The Training Provider: Webucator
Webucator - Webucator delivers customized onsite technical training throughout the United States and worldwide.
