2782 Designing Microsoft SQL Server 2005 Databases

Module 1: Approaching Database Design Systematically

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

Module 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 : Modeling a Database at the Logical Level
• Determine Entities, Attributes, Relationships, Keys, and Constraints
• Normalization and Schema Assignment

Module 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 : Modeling a Database at the Physical Level
• Specify Database Object Naming Standards
• Define Tables and Columns and Choose Data Types

Module 4: Designing for Database Performance

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

Module 5: Designing a Database Access Strategy

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

Module 6: Modeling Database Dependencies

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

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.

This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment

efore attending this course, students must:
• Have experience reading user requirements and business-need documents. For example, development project vision/mission statements or business analysis reports.
• Have experience reading and drawing business process flow charts.
• Have experience reading and drawing entity relationship (ER) diagrams.
• Understand Transact-SQL syntax and programming logic.

Currently there are no Q&As for this course. Be the first to ask a question.