Modeling a Database at the Physical Level with Microsoft® SQL Server„¢ 2005(3302)


In this 2-hour premium course you will learn how to physically model a database. Topics range from designing database objects, and constraints, to security and server options. In the lab you will model a database at the physical level.

Applying the guidelines learned within this course will allow you to design databases that are optimized according to your organization's operational needs.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft® SQL Server™ 2005.



  • Design Physical Database Objects
    • Define database object naming standards
    • Use column data types
    • Describe CLR user-defined Data Types
    • Use XML Data Type
    • Use Computed Columns
  • Design Constraints
    • Define Column Constraints
    • Define Table Constraints
    • Define Database Constraints Using DDL Triggers
  • Design for Database Security
    • Define Authentication
    • Define Authorization Process
    • Implement Data Protection
    • Implement Audit Patterns
    • Implement Encryption
  • Design Database and Server Options

Use CLR Integration

    • Implement Cross-Database Access
    • Choose Database Options
    • Choosing Database Options
  • Evaluate the Physical Model
    • Prototype the Database Design
    • Handle data migration


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-MDPL-SQL
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend