MOC 2782 Designing Microsoft SQL Server 2005 Databases

Kurs

In Kiel

850 € zzgl. MwSt.

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

Kiel (Schleswig-Holstein)
Karte ansehen
Werftstraße 193, 24143

Beginn

auf Anfrage

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

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

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

850 € zzgl. MwSt.