[FreeTutorials.Eu] [UDEMY] Data Modeling and Relational Database Design using ERwin

Description

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs

Created by: Haris Kilikotu

Last updated: 10/2017

Language: English

Subtitle: Included

Torrent Contains: 73 Files, 7 Folders

Course Source: https://www.udemy.com/datamodeling/

What you'll learn

• Create Entity Relationship Diagrams by identifying entities, attributes, relationships and constraints from a set of requirements

• Normalize the Entity Relationship Diagram to third Normal form

• Develop sound database designs by applying proven data modeling techniques

• Engineer/Re-engineer the data Models into and from relational database designs

• Optimize the Relational Database Design for various functional/non functional requirements

• Work with database change requests and maintain existing databases with the help of tools.

• Develop data models using ERwin Data Modeler

Requirements

• SQL RDBMS

Description

The data model is the one place where you can store all the relevant information about a data asset (definitions, structure, relationships, integration points etc) and deliver it in a visual and contextually appropriate format for stakeholders involved in the management and consumption of data.

The course will help you learn how to develop data models and maintain them with the help of popular data modeling tool ERWIN. We will discuss various data modeling techniques with the help of appropriate modeling scenarios and make you ready to take up complex data modeling challenges and become an effective data architect. The tools and techniques demonstrated in this course are equally applicable to OLTP & OLAP databases.

Who this course is for:

• Data Modelers

• Data Architects

• Database administrators

• ETL developers

• DWH/BI professionals

• Business Analysts.

For More Udemy Free Courses >>> http://www.freetutorials.eu

For more Lynda and other Courses >>> https://www.freecoursesonline.me/

Our Forum for discussion >>> https://discuss.freetutorials.eu/

File list

[FreeTutorials.Eu] [UDEMY] Data Modeling and Relational Database Design using ERwin - [FTU]
01 Introduction/001 What is data modeling-en.srt 2.9 KB
01 Introduction/001 What is data modeling.mp4 4.3 MB
01 Introduction/002 Entity Relationship Model-en.srt 6 KB
01 Introduction/002 Entity Relationship Model.mp4 13.2 MB
01 Introduction/003 Notation - Information Engineering(IE) basic symbols-en.srt 6.5 KB
01 Introduction/003 Notation - Information Engineering(IE) basic symbols.mp4 10.6 MB
01 Introduction/004 Download and Install ERwin software-en.vtt 8 B
01 Introduction/004 Download and Install ERwin software.mp4 16.1 MB
01 Introduction/005 ERwin workspace - Model Subject Areas and Diagrams-en.srt 5.2 KB
01 Introduction/005 ERwin workspace - Model Subject Areas and Diagrams.mp4 19.2 MB
02 Relationships/006 Relationships - Identifying and Non Identifying-en.srt 6.4 KB
02 Relationships/006 Relationships - Identifying and Non Identifying.mp4 18.4 MB
02 Relationships/007 Relationships - Recursive relationships-en.srt 3.9 KB
02 Relationships/007 Relationships - Recursive relationships.mp4 15.2 MB
02 Relationships/008 Relationships - Super types and Sub types-en.srt 3.8 KB
02 Relationships/008 Relationships - Super types and Sub types.mp4 6.2 MB
02 Relationships/009 Relationships - Sub types transformations-en.srt 14.3 KB
02 Relationships/009 Relationships - Sub types transformations.mp4 36.2 MB
03 Data Modeling Exercise/010 Data Modeling Exercise - Retail banking system-en.srt 12.2 KB
03 Data Modeling Exercise/010 Data Modeling Exercise - Retail banking system.mp4 58 MB
04 ERwin Core Features/011 Diagrams - How to create diagrams with different display elements-en.srt 11.2 KB
04 ERwin Core Features/011 Diagrams - How to create diagrams with different display elements.mp4 28.4 MB
04 ERwin Core Features/012 Domain Dictionary - How to use domain objects in model-en.srt 10 KB
04 ERwin Core Features/012 Domain Dictionary - How to use domain objects in model.mp4 36 MB
04 ERwin Core Features/012 ERwin-Domains.pdf 234.5 KB
04 ERwin Core Features/013 Bulk Editor - How to edit definition of all entitiestables-en.srt 4.1 KB
04 ERwin Core Features/013 Bulk Editor - How to edit definition of all entitiestables.mp4 12.5 MB
04 ERwin Core Features/014 Forward Engineering - How to generate database schema from model-en.srt 4 KB
04 ERwin Core Features/014 Forward Engineering - How to generate database schema from model.mp4 16.7 MB
04 ERwin Core Features/015 Reverse Engineering - Creating a data model from database-en.srt 3.5 KB
04 ERwin Core Features/015 Reverse Engineering - Creating a data model from database.mp4 10.4 MB
04 ERwin Core Features/016 Naming Standards - Name settings and attaching business glossary-en.srt 5 KB
04 ERwin Core Features/016 Naming Standards - Name settings and attaching business glossary.mp4 15.9 MB
04 ERwin Core Features/017 Complete Compare - Compare models and importexport differences-en.srt 7 KB
04 ERwin Core Features/017 Complete Compare - Compare models and importexport differences.mp4 19.3 MB
04 ERwin Core Features/018 Reporting and Publishing - How to export diagram images-en.srt 4 KB
04 ERwin Core Features/018 Reporting and Publishing - How to export diagram images.mp4 13.3 MB
04 ERwin Core Features/019 Reporting and Publishing - Entity report using Report Designer-en.srt 5 KB
04 ERwin Core Features/019 Reporting and Publishing - Entity report using Report Designer.mp4 23 MB
04 ERwin Core Features/020 Reporting and Publishing - HTML and PDF export with diagrams-en.srt 8.5 KB
04 ERwin Core Features/020 Reporting and Publishing - HTML and PDF export with diagrams.mp4 37.2 MB
05 Dimensional Modeling/021 What is dimensional modeling-en.srt 1.4 KB
05 Dimensional Modeling/021 What is dimensional modeling.mp4 2.6 MB
05 Dimensional Modeling/022 Creating a star schema - retail sales-en.srt 16.7 KB
05 Dimensional Modeling/022 Creating a star schema - retail sales.mp4 75.1 MB
05 Dimensional Modeling/023 Documenting Source to Target mappings and ETL rules-en.srt 14.6 KB
05 Dimensional Modeling/023 Documenting Source to Target mappings and ETL rules.mp4 59.8 MB
05 Dimensional Modeling/023 Sample-models-and-auxiliary-files.txt 62 B
05 Dimensional Modeling/024 Publishing Source to Target mappings and ETL Rules-en.srt 11.8 KB
05 Dimensional Modeling/024 Publishing Source to Target mappings and ETL Rules.mp4 53.2 MB
06 Normalization/025 Normalization - Introduction-en.srt 6.3 KB
06 Normalization/025 Normalization - Introduction.mp4 10.5 MB
06 Normalization/026 Normalization - First Normal Form Part1-en.srt 4.6 KB
06 Normalization/026 Normalization - First Normal Form Part1.mp4 7.4 MB
06 Normalization/027 Normalization - First Normal Form Part2-en.srt 3.4 KB
06 Normalization/027 Normalization - First Normal Form Part2.mp4 5.3 MB
06 Normalization/028 Normalization - Second Normal Form-en.srt 6.5 KB
06 Normalization/028 Normalization - Second Normal Form.mp4 12.1 MB
06 Normalization/029 Normalization - Third Normal Form-en.srt 7.5 KB
06 Normalization/029 Normalization - Third Normal Form.mp4 12.3 MB
06 Normalization/030 Normalization - BCNF-en.srt 9.4 KB
06 Normalization/030 Normalization - BCNF.mp4 16.4 MB
07 Student Exercises/031 Logical data modeling practice - Public Library.html 1.8 KB
07 Student Exercises/032 Public Library Solution.html 3.5 KB
07 Student Exercises/033 Logical data modeling practice - Transportation services.html 5.8 KB
07 Student Exercises/034 Transportation Services Solution.html 6.6 KB
07 Student Exercises/README.txt 2.2 KB
Discuss.FreeTutorials.Us.html 165.7 KB
FreeCoursesOnline.Me.html 108.3 KB
FreeTutorials.Eu.html 102.2 KB
How you can help Team-FTU.txt 259 B

[FreeTutorials.Eu] [UDEMY] Data Modeling and Relational Database Design using ERwin - [FTU]