You will learn
- SQL Server architecture
- Relational Database Components
- Database Architecture
- Administration Architecture
- Replication Architecture
- Application Development Architecture
- Analysis Services Architecture
- Meta Data Services Architecture
- New features in SQL Server 2000
- Installing, upgrading, and running SQL Server 2000
- Overview of Installing SQL Server 2000
- Upgrading to SQL Server 2000: Overview
- Installing Analysis Services
- Installing English Query
- Upgrading From Earlier Versions
- Planning and designing a new database
- Creating and Maintaining Databases Overview
- Performing administrative tasks
- Importing and Exporting Data
- Backing Up and Restoring Databases
- Automating Administrative Tasks
- Managing Security
- Security and Authentication
- Monitoring Server Performance and Activity
- Getting Started with Command Prompt Utilities
- Administering Analysis Services
- PivotTable Service
- MDX
- Data warehousing and online analytical processing (OLAP)
- DTS Overview
- Data Warehousing and OLAP
- Data Warehousing
- Developing applications
- Transact-SQL Syntax Elements
- Programming ADO SQL Server Applications
- Programming OLE DB SQL Server Applications
- Developing SQL-DMO Applications
- Getting Started with Replication Programming
- Programming DTS Applications
- Programming Extended Stored Procedures
- Programming Embedded SQL for C
- Getting Started with DB-Library for C
- Decision Support Objects
- Add-Ins
- PivotTable Service
- Programming Meta Data Services Applications
- Planning and designing data cubes
- Monitoring Server Performance and Activity
- Optimizing Database Performance Overview
- Analyzing and Optimizing Performance
- Optimizing Repository Performance
- Transact-SQL Tips
- Troubleshooting Overview
- Analysis Services Troubleshooting
