My lessons Sign in on VTC

Microsoft SQL Server 2000 Admin / Query Analyzer

Loading…

Opening and Exploring the QA

Query Analyzer

← Previous lesson Next lesson →

Course content

A Few Words About SQL Server
Overview
- Overview of Course1 credit or ad
General Database Information
General Administrative Responsibilities
Hardware Requirements
Installing SQL Server 2000
SQL Server Security
System Services
- SQL Services1 credit or ad
- SQL Services Issues1 credit or ad
System Databases
- System Databases1 credit or ad
- Sample Databases1 credit or ad
Data Storage
Administrative Tools
- Overview of Admin Tools1 credit or ad
- Exam Considerations1 credit or ad
Enterprise Manager
Query Analyzer
Transact-SQL Select Statement
Transact-SQL Insert Statement
Transact-SQL Update Statement
Transact-SQL Delete Statement
- Using the Delete Statement1 credit or ad
- Basic Syntax/Important Considerations1 credit or ad
Creating a Database
Transaction Logs
Filegroups
RAID & SQL
- RAID Basics1 credit or ad
- SQL and RAID1 credit or ad
SQL Profiler
Operators
Jobs
Alerts
Linked Servers
Database Backups
Restoring Data
Maintaining High Availability
Data Transformation Services
Monitoring SQL Server 2000
Replication Basics
Course Wrap-Up
- Value of SQL Server knowledge1 credit or ad
- Microsofts MCDBA Certification1 credit or ad
Credits
- About this Author1 credit or ad