Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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.

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 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)
Leads to examination
70-100, Analyzing Requirements and Defining Solution Architectures
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.
Delegates will learn how 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 Outline
Module 1: Introduction to Modeling Business Requirements
Module 2: Analyzing External Information and Creating a Conceptual Model?CSDP Step 1
Module 3: Drawing a Conceptual Model and Entering Sample Data?CSDP Step 2
Module 4: Trimming the Conceptual Schemaf?CSDP Step 3
Module 5: Adding Uniqueness Constraints and Checking Arity of Fact Types?CSDP Step 4
Module 6: Adding Mandatory Role Constraints and Checking for Logical Derivations?CSDP Step 5
Module 7: Adding Value and Set Constraints, and Creating Entity Subtypes?CSDP Step 6
Module 8: Adding Frequency and Ring Constraints?CSDP Step 7
Module 9: Generating a Relational Logical Model
Module 10: Completing the Baseline Model
Module 11: Generating and Reverse Engineering Physical Schema ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect training resources.

Developing Component-Based Applications Using Microsoft .NET Enterprise Services
ASP.NET 1.1 and ADO.NET 1.1
Developing Microsoft .NET Applications for Windows
Developing Secure Web Applications
Introduction to Programming
Introduction to XML and the Microsoft .NET Platform
Programming the Microsoft .NET Framework
Programming the Microsoft .NET Framework with Visual Basic.NET
Programming with C#
Programming with Managed Extensions for Microsoft Visual C++ .NET
Programming with Microsoft ADO.NET
Programming with Microsoft Visual Basic .NET

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.