MOC 2782 Designing Microsoft SQL Server 2005 Databases
Kurs
In Kiel
Beschreibung
-
Kursart
Kurs
-
Ort
Kiel
-
Dauer
2 Tage
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. Apply best practices when designing for database scalability. Design a database access strategy. Use best practices to model database dependencies. Gerichtet an: 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.
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Have experience reading user requirements and business-need documents.
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.
Be able to design a database to 3NF and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in ad
Meinungen
Themen
- Microsoft
- SQL Server
Inhalte
- 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.
- Apply best practices when designing for database scalability.
- Design a database access strategy.
- Use best practices to model database dependencies.
Inhalte
Module 1: Approaching Database Design Systematically
Module 2: Modeling a Database at the Logical Level
Module 3: Modeling a Database at the Physical Level
Module 4: Designing for Database Performance
Module 5: Designing a Database Access Strategy
Module 6: Modeling Database Dependencies
MOC 2782 Designing Microsoft SQL Server 2005 Databases