Designing Microsoft SQL Server 2005 Databases |
![]() |
| Tipo de curso: |
Cursos de especialización |
Metodología: |
Presencial |
| Centro: | New Horizons Barcelona | Nº de horas: | 12.00 |
| Sedes: | No presencial | ||
![]() |
|
| Precio: | ¡ Gratuito ! |
![]() |
|
![]() |
|
|
Justificación/Descripción del curso:
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. |
![]() |
|
|
Requisitos de acceso al curso:
Nnguno
|
![]() |
|
|
Temario cubierto por el curso:
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 |
![]() |
|
![]() |
|
![]() |
|
| Puede ver otros cursos relacionados en las categorías: |
|
Directorio de cursos » Cursos de Idiomas » Inglés Directorio de cursos » Informática » Bases de datos |
![]() |
|
El curso Designing Microsoft SQL Server 2005 Databases está en nuestra base de datos desde el 02/05/2006. Desde entonces ha sido visto por un total de 223 usuarios, generando un total de 0 peticiones de información. Sus tags: database, designing, design, modeling, dependencies, physical, logical, requirements Términos relacionados: database design, database dependencies |
© 2002-2006 Portal Formativo S.L. - B27303494 - Tlf 902 922245 - Fax 982 210683 - info@portalformativo.com - XHTML válido
Squid
0.10269 Carga - 0.017458 Mysql (1) - 0.085232 PHP












