Administering SQL Server 2000
Course Level: Beginner, Intermediate
Duration: 15 Hours
Covers: SQL Server 2000, 7.0
Benefits:
- Installing & Upgrading SQL
Server
- Using SQL Server
Administrative Tools including Enterprise Manager, Query
Analyzer & Profiler
- Creating, Altering & Managing
Databases
- Implementing SQL Server
Security
- Planning & Implementing
Disaster Recovery for SQL Server & Databases
- Managing Data using Data
Transformation Services and Other Utilities
- Automating Administration of
SQL Server
- Setting up and managing SQL
Server Replication
- Performance Tuning SQL
Server
Prerequsites:
- Some Knowledge with Databases
Course Outline:
RELATIONAL DATABASE FUNDAMENTALS
- Database
- Database Objects including
Tables, Rows, Columns, Views, Rules, Defaults, Index, Stored
Procedures, and Trigger etc.
- Understanding Client/Server
and Desktop Databases
- Data Warehousing Vs
Transaction Processing
INTRODUCTION TO SQL
- SEQUEL
- Data Definition Language (DDL)
& Data Manipulation Language (DML)
- ANSI-SQL
- Transact-SQL
INSTALLATION OF SQL SERVER
- Editions of SQL Server
- Pre-installation
Considerations
- Hardware Requirements
- Software Requirements
- License Mode
- Collation
- Sort order
- Unicode support
- Network libraries
- User accounts
- Default and Named
Instances
- Installation Path
- Upgrade Vs. Side-by-Side
Installation
- Components
- Upgrading Vs Side-by-side
Installation
- Unattended Installation
- Post-Installation
- Testing the Installation
- Understanding the
Installation Folders
- Configuring SQL Server
ARCHITECTURAL OVERVIEW OF SQL
SERVER
SQL Server Components
- SQL Server
- SQL Server Agent
- Distributed Transaction
Coordinator
- Microsoft Search
Tools
- SQL Server Enterprise Manager
- SQL Query Analyzer
- SQL Profiler
- iSQL & OSQL
- Wizards
UNDERSTANDING & CREATING SQL
SERVER DATABASES
- Understanding Databases
- Database & Log Files
- Disk (RAID)
- Data Storage Structures:
Extent & Pages
- Estimating Storage
Requirements
- Creating & Managing Databases
- Create Databases Using
Enterprise Manager & T-SQL
- Setting up Database
Options
- Altering databases
SQL SERVER SECURITY
- Authentication Modes
- SQL Server Authentication
- Windows Integrated
Security
- Security Components
- SQL Server Logins
- Database Users
- Server Roles
- Database Roles
- Statement Permissions
- Server Level
- Database Level
- Grant, Revoke and Deny
Statements
- Ownership Chains
- Monitoring Security using
Profiler
BACKUP & RECOVERY
- Backup Plan
- Using Hardware & Windows to
Protect SQL Server
- DBCC, Transaction & Copy
Database Wizard
- SQL Database Backup Modes
- Backup SQL Server
- Backup Types
- Backup Characteristics
- Backup Devices
- Backup Databases and Log
using EM & T-SQL
- Database Maintenance Plan
Wizard
- Restoring Databases & Log
- Understanding Restore
Options
- Resorting Databases Using
EM and T-SQL
- Restoring master database
- Rebuilding master database
MANAGING DATA WITH SQL SERVER
- Using Bulk-Copy Program (BCP)
- BULK INSERT
- Data Transformation Services
(DTS)
- DTS Packages
- Import/Export Wizard
- DTS Designer
- DTS Storage
- DTS Security
- DTSRUN
- DTSRUNUI
- CONFIGURE SQL SERVER FOR XML
SUPPORT
- Configuring XML SQL Support in
IIS
- Retrieving XML using HTTP
- Submitting SQL as part of a
URL
- Formatting results with XSL
AUTOMATING SQL SERVER
ADMINISTRATION
- MSDB Database
- SQL Server Agent
- Understanding & Using
- Job
- Job Steps
- Schedules
- Events
- Operators
- Alerts
- Multi-server Jobs
- Creating SQL Server Error
Messages
- Enabling MAPI Support for
Email
REPLICATION
- Understanding SQL Server
Replication
- Publishers
- Distributors
- Subscribers
- Publications
- Articles
- Types of Replications
- Snap-shot Replication
- Transactional Replication
- Merge Replication
- Replication Topology
- Configuring & Managing
Replication
- Troubleshooting Replication
MONITORING & OPTIMIZING SQL
SERVER
- Using Windows Performance
Console
- System Monitor
- Counter Logs
- Alerts
- Important SQL Server Counters
- Using Query Analyzer to Tune
Queries
- Monitoring with SQL Profiler
- Index Tuning Wizard
- Optimizing using Various
Options & Considerations
