Otra Información:
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. 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. www.nhbarcelona.com

Descripción :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. www.nhbarcelona.com

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 www.nhbarcelona.com