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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size665.7 MB
  • Uploaded BySunRiseZone
  • Downloads74
  • Last checkedDec. 30th '18
  • Date uploadedDec. 29th '18
  • Seeders 16
  • Leechers9
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : CC229CFC5485CCAEED7C5DAC6A126F3546B0FF2C



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/



Files:

[FreeTutorials.Eu] [UDEMY] Data Modeling and Relational Database Design using ERwin - [FTU] 01 Introduction
  • 001 What is data modeling-en.srt (2.9 KB)
  • 001 What is data modeling.mp4 (4.3 MB)
  • 002 Entity Relationship Model-en.srt (6.0 KB)
  • 002 Entity Relationship Model.mp4 (13.2 MB)
  • 003 Notation - Information Engineering(IE) basic symbols-en.srt (6.5 KB)
  • 003 Notation - Information Engineering(IE) basic symbols.mp4 (10.6 MB)
  • 004 Download and Install ERwin software-en.vtt (0.0 KB)
  • 004 Download and Install ERwin software.mp4 (16.1 MB)
  • 005 ERwin workspace - Model Subject Areas and Diagrams-en.srt (5.2 KB)
  • 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)
  • 006 Relationships - Identifying and Non Identifying.mp4 (18.4 MB)
  • 007 Relationships - Recursive relationships-en.srt (3.9 KB)
  • 007 Relationships - Recursive relationships.mp4 (15.2 MB)
  • 008 Relationships - Super types and Sub types-en.srt (3.8 KB)
  • 008 Relationships - Super types and Sub types.mp4 (6.2 MB)
  • 009 Relationships - Sub types transformations-en.srt (14.3 KB)
  • 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)
  • 010 Data Modeling Exercise - Retail banking system.mp4 (58.0 MB)
04 ERwin Core Features
  • 011 Diagrams - How to create diagrams with different display elements-en.srt (11.2 KB)
  • 011 Diagrams - How to create diagrams with different display elements.mp4 (28.4 MB)
  • 012 Domain Dictionary - How to use domain objects in model-en.srt (10.0 KB)
  • 012 Domain Dictionary - How to use domain objects in model.mp4 (36.0 MB)
  • 012 ERwin-Domains.pdf (234.5 KB)
  • 013 Bulk Editor - How to edit definition of all entitiestables-en.srt (4.1 KB)
  • 013 Bulk Editor - How to edit definition of all entitiestables.mp4 (12.5 MB)
  • 014 Forward Engineering - How to generate database schema from model-en.srt (4.0 KB)
  • 014 Forward Engineering - How to generate database schema from model.mp4 (16.7 MB)
  • 015 Reverse Engineering - Creating a data model from database-en.srt (3.5 KB)
  • 015 Reverse Engineering - Creating a data model from database.mp4 (10.4 MB)
  • 016 Naming Standards - Name settings and attaching business glossary-en.srt (5.0 KB)
  • 016 Naming Standards - Name settings and attaching business glossary.mp4 (15.9 MB)
  • 017 Complete Compare - Compare models and importexport differences-en.srt (7.0 KB)
  • 017 Complete Compare - Compare models and importexport differences.mp4 (19.3 MB)
  • 018 Reporting and Publishing - How to export diagram images-en.srt (4.0 KB)
  • 018 Reporting and Publishing - How to export diagram images.mp4 (13.3 MB)
  • 019 Reporting and Publishing - Entity report using Report Designer-en.srt (5.0 KB)
  • 019 Reporting and Publishing - Entity report using Report Designer.mp4 (23.0 MB)
  • 020 Reporting and Publishing - HTML and PDF export with diagrams-en.srt (8.5 KB)
  • 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)
  • 021 What is dimensional modeling.mp4 (2.6 MB)
  • 022 Creating a star schema - retail sales-en.srt (16.7 KB)
  • 022 Creating a star schema - retail sales.mp4 (75.1 MB)
  • 023 Documenting Source to Target mappings and ETL rules-en.srt (14.6 KB)
  • 023 Documenting Source to Target mappings and ETL rules.mp4 (59.8 MB)
  • 023 Sample-models-and-auxiliary-files.txt (0.1 KB)
  • 024 Publishing Source to Target mappings and ETL Rules-en.srt (11.8 KB)
  • 024 Publishing Source to Target mappings and ETL Rules.mp4 (53.2 MB)
06 Normalization
  • 025 Normalization - Introduction-en.srt (6.3 KB)
  • 025 Normalization - Introduction.mp4 (10.5 MB)
  • 026 Normalization - First Normal Form Part1-en.srt (4.6 KB)
  • 026 Normalization - First Normal Form Part1.mp4 (7.4 MB)
  • 027 Normalization - First Normal Form Part2-en.srt (3.4 KB)
  • 027 Normalization - First Normal Form Part2.mp4 (5.3 MB)
  • 028 Normalization - Second Normal Form-en.srt (6.5 KB)
  • 028 Normalization - Second Normal Form.mp4 (12.1 MB)
  • 029 Normalization - Third Normal Form-en.srt (7.5 KB)
  • 029 Normalization - Third Normal Form.mp4 (12.3 MB)
  • 030 Normalization - BCNF-en.srt (9.4 KB)
  • 030 Normalization - BCNF.mp4 (16.4 MB)
07 Student Exercises
  • 031 Logical data modeling practice - Public Library.html (1.8 KB)
  • 032 Public Library Solution.html (3.5 KB)
  • 033 Logical data modeling practice - Transportation services.html (5.8 KB)
  • 034 Transportation Services Solution.html (6.6 KB)
  • 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 (0.3 KB)
  • [TGx]Downloaded from torrentgalaxy.org.txt (0.5 KB)
  • Torrent Downloaded From GloDls.to.txt (0.1 KB)

Code:

  • https://tracker.fastdownload.xyz:443/announce
  • udp://tw.opentracker.ga:36920/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • https://seeders-paradise.org:443/announce
  • udp://open.stealth.si:80/announce
  • udp://hk1.opentracker.ga:6969/announce
  • udp://open.stealth.si:80/announce
  • https://opentracker.xyz:443/announce
  • https://t.quic.ws:443/announce
  • https://tracker.fastdownload.xyz:443/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://zephir.monocul.us:6969/announce
  • udp://open.demonii.si:1337/announce