• Decrease font size
  • Default font size
  • Increase font size

Modeling Business Requirements Create Database Using MS Visual Studio .NET Enterprise Architect

 Print E-mail
 Course Length - 3 Days
 
 Course Description
This intensive, three-day course provides students with the knowledge and skills to model business requirements in order to create a baseline database design. It focuses on the use of Object Role Modeling (ORM) and the ORM modeling tool in Microsoft Visual Studio .NET Enterprise Architect. Students will also learn the database modeling process and how ORM relates to Entity Relationship (ER) diagrams. 
 
What you will learn

 After completing this course, students will be able to:

  • Analyze business requirements
  • Create a conceptual database model using ORM
  • Create a logical database model (ER diagram)
  • Validate the model against the external information
  • Transfer the model into a SQL Server database
Course Prerequisites

 Before attending this course, students must have:

  • The ability to describe what databases are and their uses
  • The ability to understand basic concepts of querying databases
  • The necessary skills to log on to and navigate in a Microsoft Windows environment

 

 

Who Should Attend?
 

This course will benefit those who need to understand the principles of database design in preparation for modeling, designing, developing, or administering Microsoft SQL ServerTM databases. It will also help those who are developing applications that access SQL Server data in an online transaction processing (OLTP) environment. Candidates should be familiar with databases and their uses.


Those taking this course should have the ability to:

  • Describe what databases are and how they are used
  • Understand basic programming concepts
  • Understand the following relational database terms:
    • Tables
    • Columns
    • Data integrity
    • Data types

Some of the individuals that may benefit from this course are:

  • Database designers
  • Database implementers
  • Database administrators
  • Application developers (client, server, Web)