|
Provided by: Webucator Advanced Microsoft SQL Server TrainingUnfiled |
 |
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 .
|
|
||||||||||||||
Training
Provided by Webucator
- S asked: Do you also take goverment POs.
- S asked: any dts training available?
- L asked: Is this class taught in a self paced online format, and if so, how much for the course. Thank You
- Y asked: how we get this material
- R asked: I'd like a bit more information about this training. Costs, location, scheduling, etc.
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, instructor-led online and at-your-own-paced technical training throughout the United States and worldwide. Webucator has trained 40 percent of the Fortune 100.
Onsite Class Delivery:
Our onsite classes are delivered for private groups at your offices or a location of your choice. These classes can also be delivered through a web conference for...
