SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. Learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.
SQL Training Audience:
Developers who need to build database solutions with SQL Server.
SQL Training Prerequisites
Programming Databases with Microsoft SQL Server 2000 – Level 2.
SQL Training Course duration
3 days
SQL 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-Part I
- 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
XML Features-Part II
- 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 Queries
- Using Full-Text Search with Documents 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 an English Query Application
- Deploying an English Query Application
