New Horizons Computer Learning Center
410-597-9722

2782: Designing Microsoft SQL Server 2005 Databases

Course Length: 2 Days

Overview:
This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Course Objectives:
Upon successful completion of this course, students will be able to:

• Approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design
• Analyze and evaluate a logical database design
• Apply best practices for creating a physical database design
• Apply best practices when designing for database scalability
• Design a database access strategy
• Use best practices to model database dependencies

Course Content

Lesson 1: Approaching Database Design Systematically

• Overview of Database Design
• Gathering Database Requirements
• Creating a Conceptual Database Design
• Lab 1: Beginning the Database Design Process
• Gathering Database Requirements
• Creating a Conceptual Design

Lesson 2: Modeling a Database at the Logical Level

• Building a Logical Database Model
• Designing for OLTP Activity
• Designing for Data Warehousing
• Evaluating Logical Models
• Lab 2: Modeling a Database at the Logical Level
• Determine Entities, Attributes, Relationships, Keys, and Constraints
• Normalization and Schema Assignment

Lesson 3: Modeling a Database at the Physical Level

• Designing Physical Database Objects
• Designing Constraints
• Designing for Database Security
• Designing Server and Database Options
• Evaluating the Physical Model
• Lab 3: Modeling a Database at the Physical Level
• Specify Database Object Naming Standards
• Define Tables and Columns and Choose Data Types

Lesson 4: Designing for Database Performance

• Designing Indexes
• Planning for Table Optimization
• Planning for Database Optimization
• Lab 4: Designing for Database Scalability
• Apply Optimization Techniques

Lesson 5: Designing a Database Access Strategy

• Designing for Secure Data Access
• Designing User-Defined Functions
• Designing Stored Procedures
• Lab 5: Designing a Database Access Strategy
• Design data retrieval objects
• Design security for data retrieval objects

Lesson 6: Modeling Database Dependencies

• Modeling Local Database Dependencies
• Modeling Remote Database Dependencies
• Lab 6: Modeling Database Dependencies
• Design Cross-Database Access
• Design Linked Servers

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com