|
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 Identify the roles of system databases and tables Define data by using system functions and applying constraints Create database objects, such as tables and views Allocate space to database objects Create indexes, considering performance issues Enforce data integrity by creating and implementing rules, defaults, and constraints Write basic Transact-SQL® statements to query data Write Transact-SQL® statements to summarize and manipulate data Write Transact-SQL® statements to modify data Import and export data These course objectives correspond to the specific skills measured by the ‘Implementing a Database Design on Microsoft® SQL Server 6.5 Certification Exam 70-027.
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
|
