  
                     
|
| |
 |
MICROSOFT SQL SERVER 7.0 - LEVEL 2
| Course Description |
|
The first part of this course focuses on querying. You’ll learn how to create a basic query using SELECT statements and then move into more advanced types of queries. Then, you'll learn techniques for making the best use of Microsoft SQL Server. You’ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This course also focuses on topics that are relevant to multi-user, replication, and Internet/intranet environments.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| Introduction to SQL Server 7.0 - Level 1.
|
• Basic Querying
Understanding SQL
The SELECT Statement
The WHERE Clause
The ORDER BY Clause
The GROUP BY Clause
• Joining
Principals of Joining
Inner Joins
Outer Joins
Self Joins
Unions
• Action Queries
Data Manipulation
Inserting Data
Updating Data
Deleting Data
• Advanced Querying
Distributed queries
OpenRowSet
OpenQuery
Advanced Transact-SQL
Parallelism
• Maintaining and Backing up SQL Server
Backup and Restore
Creating a Backup Strategy
Implementing Backups
Introducing the Database Maintenance Plan Wizard
Restoring from a Backup
• Replication
Introduction to Replication
Implementing Replication with Microsoft Access
|
• Transaction Processing
Transactions
Working with Locks
Monitoring Processes and Locks
Transaction Isolation
Deadlocking
• Stored Procedures, Triggers and Views
Introduction to Stored Procedures
Writing Stored Procedures
Triggers
Views
System Functions Reference
• Tuning and Configuration
Filegroup Tuning
Partitioning Data
Optimizing Queries
Optimizing Hardware (and NT)
Performance Monitor
• Security
Security Overview
Authentication
Assigning Permissions
Using Roles
Administering Security
• Using Microsoft OLAP Services
Understanding OLAP Cubes
Building a Simple Cube
Browsing Data from a Cube
• Publishing SQL Server Data to the Web
Publishing Data to the Web
The SQL Server Web Assistant
The SQL Server Web Stored Procedures
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
