Technology:	Windows 2000 / .NET
Course:	Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect MS-2090 (Exam 70-300)
Type:	Development
Duration:	3 Days

Description:

Delivery Method:

Instructor led

Summary Description:	Audience:
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.	This course will benefit those who need to understand the principles of database design in preparation for modeling, designing, developing, or administering Microsoft SQL Server^TM 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)
Objectives:	Comments:
This course will help the student prepare for the following Microsoft Certified Professional exams: This course is associated with Exam 70-300.	None.
Topics Covered: By the end of this course, the student should 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.	Prerequisites: Student should 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.