Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To provide students with a comprehensive overview of SQL Server 7.0 architecture and features

Learning Objectives

Identify the principal design goals for SQL Server 7.0. Point out the core components and advanced features of SQL Server 7.0. List the operating systems compatible with SQL Server 7.0. Describe the SQL Server 7.0 Relational and Storage Engine. Overview the security architecture and Distributed Management Framework of SQL Server 7.0. Outline Microsoft?s Universal Data Access strategy. Identify the components in Microsoft's Data Warehousing Framework

Topics Covered

Background - An overview - Design goals - Communication architecture - Hands-on: Naming components Technologies - Core components - Advanced features - Hands-on: Identifying new features Architecture - The Query Processor - The Storage Engine - Security architecture Frameworks - Distributed Management Framework - Universal Data Access - Data Warehousing Framework - Hands-on: Identifying components

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.