MOC 2782 Designing Microsoft SQL Server 2005 Databases

ABS - IT UG (haftungsbeschränkt)
In Kiel

850 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0431 ... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Kurs
  • Kiel
  • Dauer:
    2 Tage
Beschreibung

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.

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Kiel
Werftstraße 193, 24143, Schleswig-Holstein, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

  • 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

Was lernen Sie in diesem Kurs?

Microsoft
SQL Server

Themenkreis

  • 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


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen