Designing Microsoft SQL Server 2005 Databases (2782)

OBJETIVOS
This 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.
After completing 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.
Design a database access strategy.
Use best practices to model database dependencies.

PARTICIPANTES
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.

EQUIPOS Y DURACIÓN
Se dispone de un ordenador por alumno. El curso tiene una duración de 10 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado.

 

[Temario]

Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design

Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models

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

Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization

Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures

Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies