Cursos de especialización

Presencial

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.

Nnguno

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

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