Description

Type

Course
Methodology

Online

Start date

Different dates available

A Practical Data Modeling Training Course That Teaches Real World Skills In this project-based Learning Data Modeling video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Learning Data Modeling training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Learning Data Modeling subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Learning Data Modeling tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 8 hours to complete this course 122 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Data Modeling training course, expert author Michael Blaha will teach you how to build data models, as well as prepare a data model for simple problems. This course is designed for users that have some programming experience, however, no data modeling experience is needed.

You will start by learning about the data modeling development process, then jump into basic and advanced data modeling. From there, Michael will teach you how to create a UML data model, including finding classes, adding attributes, and simplifying the model. This video tutorial also covers how to translate a UML data model into an IE data model, model quality, the different kinds of data models, and database design. You will also learn how to create an SQL server...

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Requirements

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Self assessment
Database Design
UML training
UML
Basic
Server
Basic IT training
Database
SQL
Database training
Basic IT
Quality
Design
Engineering
Quality Training
IT Development
Architect
Skills and Training

Course programme

01. Getting Started
- About The Course
- About The Author
- What Is A Database?
- What Is A Data Model?
- 0105 How To Access Your Working Files
02. Data Model Development Process
- Data Model Inputs And Outputs
- Data Model Notations
- UML Versus IE - Conceptual, Logical And Physical
03. Basic Data Modeling
- Class And Attribute
- Operation
- Domain
- Association
- IE Entity Type And Relationship Type
- Association Name
- Association End
- Multiplicity - UML
- Multiplicity - IE
- Generalization - UML
- Generalization - IE
- Abstract Versus Concrete Superclass
- Practical Tips
- Self Assessment Test
04. Advanced Data Modeling
- 0401 Identity
- 0402 Derived Data
- 0403 Current Versus Historical Data
- 0404 Association Class
- 0405 Ordered Association
- 0406 Qualified Association - UML
- 0407 Qualified Association - IE
- 0408 Large Taxonomies
- 0409 Package
- 0410 Abridged UML Metamodel
- 0411 Abridged IE Metamodel
- 0412 Modeling Pitfalls
- 0413 Practical Tips
- 0414 Self Assessment Test
05. Create A UML Data Model
- 0501 Problem Statement
- 0502 Finding Classes
- 0503 Finding Associations - Part 1
- 0504 Finding Associations - Part 2
- 0505 Finding Generalizations
- 0506 Iterating And Refining The Model - Part 1
- 0507 Iterating And Refining The Model - Part 2
- 0508 Adding Attributes
- 0509 Cleaning Up Layout
- 0510 Simplifying The Model
- 0511 Evolving A Model - Part 1
- 0512 Evolving A Model - Part 2
- 0513 Enterprise Architect Techniques - Part 1
- 0514 Enterprise Architect Techniques - Part 2
- 0515 Enterprise Architect Techniques - Part 3
06. Translate A UML Data Model Into An IE Data Model
- 0601 Creating Subject Areas
- 0602 Creating Entity Types
- 0603 Creating Domains
- 0604 Adding Attributes - Part 1
- 0605 Adding Attributes - Part 2
- 0606 Creating Relationship Types - Part 1
- 0607 Creating Relationship Types - Part 2
- 0608 Creating Relationship Types - Part 3
- 0609 Subtyping
- 0610 Adding Alternate Keys
- 0611 Cleaning Up The Layout
- 0612 ERwin Techniques - Part 1
- 0613 ERwin Techniques - Part 2
07. Model Quality
- 0701 Model Quality
- 0702 Normal Forms
- 0703 Constraints
- 0704 Hillard Graph Complexity
- 0705 Hoberman Data Model Scorecard
08. Kinds Of Data Models
- 0801 Operational Data Models
- 0802 Enterprise Data Models
- 0803 Data Warehouses - Part 1
- 0804 Data Warehouses - Part 2
- 0805 Data Warehouses - Part 3
- 0806 Master Data Models
09. Database Design
- 0901 Schema Adjustments
- 0902 Attribute Details - Part 1
- 0903 Attribute Details - Part 2
- 0904 Attribute Details - Part 3
- 0905 Primary And Alternate Keys
- 0906 Indexes
- 0907 Referential Integrity - Part 1
- 0908 Referential Integrity - Part 2
- 0909 Check Constraints - Part 1
- 0910 Check Constraints - Part 2
- 0911 Views
- 0912 Other Aspects Of Design
- 0913 Self Assessment Test
10. Create A SQL Server Database
- 1001 Creating A New Database
- 1002 Executing Schema
- 1003 Inspecting Metadata
- 1004 Loading Sample Data
- 1005 Querying Sample Data
11. Create An MS-Access Database
- 1101 Generating An ERwin Schema
- 1102 Creating Tables
- 1103 Creating Indexes
- 1104 Creating Constraints And Default Values
- 1105 Defining Foreign Keys
- 1106 Creating Views
- 1107 Loading Sample Data
- 1108 Querying Sample Data
12. Software Engineering
- 1201 Development Frameworks
- 1202 Agile Data Modelling
- 1203 Documenting A Model - Part 1
- 1204 Documenting A Model - Part 2
- 1205 Presenting A Model
13. Data Modeling Patterns
- 1301 Overview
- 1302 Tree - Hardcoded
- 1303 Tree - Simple
- 1304 Tree - Structured
- 1305 Tree - Overlapping
- 1306 Tree - Changing Over Time
- 1307 Tree - Degenerate Node and Edge
14. Database Reverse Engineering
- 1401 Motives
- 1402 Comparison With Forward Engineering
- 1403 Outputs
- 1404 Inputs
- 1405 Process
- 1406 Principles
- 1407 Example - Part 1
- 1408 Example - Part 2
15. Conclusion
- 1501 Wrap-Up

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

See related categories

Contact us

Learning Data Modeling Training Video

Questions & Answers

Reviews

Subjects

Course programme

Digital Download FAQs

Add similar courses
and compare them to help you choose.

Learning Data Modeling Training Video

Questions & Answers

Reviews

Subjects

Course programme

Digital Download FAQs

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.