MS SQL Server 6.5: Design & Management

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Description

In this course, students will learn to implement a database design on Microsoft® SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for the ‘Implementing a Database Design on Microsoft® SQL Server 6.5 Certification Exam 70-027.

Audience

This course is designed for database implementors, database administrators, system engineers, developers using Transact-SQL code, Help Desk technicians and Microsoft® Certification Professional candidates.

Prerequisites

The student is expected to have a working knowledge of relational database theory and database design, SQL Enterprise Manager or isql/w., ANSI-SQL statements, Microsoft Windows® interface, Microsoft Windows NT® Server network operating system, Microsoft networking fundamentals.

Objective

Design a database by applying data modeling concepts

Topics Include

Model and Define Data

• Model Data Introduction
• Use Administration Tools
• Describe DMF
• Create a Logical Database
• Implement the ERA Model
• Model Data
• Use System DBs and Tables
• Use Databases
• Use System Tables
• Use System Stored Procedures
• Create a Database
• Estimate Storage Space
• Create a Database
• Increase Transaction Log Size

Create Tables and Indexes

• Create and Modify Tables
• Identify Database Components
• Select Datatypes
• Create Tables
• Modify Tables
• Enforce Integrity
• Create Defaults and Rules
• Enforce Integrity Using Defaults
• Enforce Integrity Using Rules
• Bind Defaults and Rules
• Unbind & Drop Defaults and Rules
• Apply Constraints
• Load the Data
• Use the INSERT Statement
• Use the BCP Utility
• Create and Implement Indexes
• Implement Indexes
• Create an Index
• Use a Clustered Index
• Use a Nonclustered Index
• Use a Unique Index
• Use a Composite Index
• Manage Indexes

Retrieve Data

• Use the SELECT Statement
• Write a SELECT Statement
• Choose Columns
• Improve Results Readability: Literals
• Improve Results Readability: Aliases
• SELECT Specific Rows
• Choose Specific Rows
• Choose a Row Using Comparisons
• Choose a Row Using Ranges
• Choose a List-based Row
• Choose a Character-based Row
• Choose a Row With Unknown Values
• Use Search Arguments
• Eliminate Duplicates
• Manipulate Data
• Manipulate Numeric Data
• Manipulate Character Data
• Manipulate Datetime Data
• Use System Functions
• Convert Data
• Sort Results
• Create and Use Views
• Create a View
• Choose View Options
• Create a View of a View
• Modify Data Through Views

Duration

5 hrs

Minimum Requirements

IBM 486 compatible PC, Minimum of 8MB RAM, 35 MB hard disk space, one 3.5 diskette drive, VGA Color Monitor with 256 colors, MS Windows 3.x/Windows 95 or Windows NT 3.5x/4.0, IBM 0S/2.

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002