Online Data Modeling Training Syllabus

Part 1: Course Information

Course Description:

This online training course explains in detail about database, data warehouse, data modeling concepts, data modeling types and how these are used in OLTP environments and Data warehouse / Datamart Environments. To get more information about this training program, send an email to Training@LearnDataModeling.Com and we will get back to you.

Course Information:
  • Start Date: 17th January 2018
  • Course Name: Data Modeling Training
  • Course Fee: $100 (100 US Dollars)
  • Training Hours: 10.00 PM EST to 11.00 PM Eastern Standard Time
  • Training Time: 1 hour per session
  • Days: Monday, Wednesday, Friday (Alternate Days)
  • Total no. of theoretical/Practical classes: At least 10
  • Mode of Teaching: Online through SKYPE
  • Instructor: Neelesh & Antony (Owner of LearnDataModeling.com)
  • Office: USA and Chennai
Course Requirements:
  • Internet connection
  • Lap Top or Desk Top
Tools:
  • Erwin
  • MS Word, MS Excel
  • My SQL
  • Windows Operating System
Training Certificates:
  • Will be provided.

Online Training on Data Modeling with Business Analysis and Data Analysis

Table of Contents

  1.   Part 1 –   Career Path of a Data Modeler
  2.   Part 2 –   Project and PMO
  3.   Part 3 –   Business Analysis from Data Modeling Perspective
  4.   Part 4 –   Data Analysis from Data Modeling Perspective
  5.   Part 5 –   Data Modeling Concepts
  6.   Part 6 –   Data Modeling Types
  7.   Part 7 –   How to create a logical data model
  8.   Part 8 –   How to create a Physical data model
  9.   Part 9 –   Dimensional Data Modeling, Data Warehouse and Data Mart
  10. Part 10 – Repository, Meta Data and Maintenance of the Data Model

Additional Topics

  • Data Modeling Interview Questions
  • Business Analysis/Data Modeling and Recruiter
  • Business Analysis/Data Modeling and HR
  • Business Analysis/Data Modeling and Immigration
  • Business Analysis Data Modeling and Accounts Manager
  • Business Analysis/Data Modeling and Consulate Visa Interview

Course Syllabus

Part 1 – Career Path of a Data Modeler

  • What is a Data Modeling?
  • Explanation of Data Modeler duties in brief
  • Certifications in Data Modeling
  • Career Path of a Data Modeler
  • Salary of a Data Modeler

Part 2 – Project and PMO

  • What is a project?
  • What are the project engagement models?
  • Explanation of End to End, Upgrade, Migration projects and Maintenance Projects.
  • What is PMO?
  • What are the different phases in software development?
  • Organization Chart

Part 3 – Business Analysis from Data Modeling Perspective

  • What is Business Process?
  • What is Business Process Management?
  • What is Business Analysis?
  • Who is a business Analyst?
  • What are the duties and responsibilities of a Business Analyst?
  • What are the other alternative names for a Business Analyst?
  • Explanation of Business Analysis with a Project example

Part 4 – Data Analysis from Data Modeling Perspective

  • What is Data Analysis?
  • Explanation of Data Analysis with a Project example

Part 5 – Data Modeling Concepts

  • Who is a data modeler? What are the other alternative titles for a Data Modeler?
  • What are the duties and responsibilities of a Data Modeler? What is the difference between duty and responsibility?
  • What is a Data Model?
  • Who needs Data Modeling?
  • Different Data Modeling Tools.

Part 6 – Data Modeling Types

  • Explanation for Logical, Physical, Conceptual, Enterprise, and Dimensional Data Model
  • Data Modeling Development Life Cycle

Part 7 – How to create a logical data model

  • Entity, Attribute, Primary Key, Alternate Key, Inversion Key Entry, Rule, Relationship, Definition

Part 8 – How to create a Physical data model:

  • Table, Column, Primary Key Constraint, Unique Constraint or Unique Index, Non-Unique Index, Check Constraint, Default Value, Foreign Key, Comment
  • Difference between a logical data model and Physical Data Model
  • What is Forward Engineering?
  • What is Reverse Engineering?
  • What is subject area?
  • How to implement Physical data model in a database:
  • How to generate SQL Code?
  • How to implement it in Database?

Part 9: Dimensional Data Modeling, Data Warehouse and Data Mart

  • What is a Lookup?
  • How to maintain data in Lookups?
  • What is a Data Warehouse?
  • What is a Data Mart?
  • What is Snow Flake Modeling?
  • What is Star Schema Modeling?
  • What is Slowly Changing Dimensions?
  • What is Dimensional Data Modeling?
  • How to create a data model for Data Warehouse and Data Mart?

Part 10:  Repository, Meta Data and Maintenance of the Data Model

  • What is a Repository?
  • What is Meta Data?
  • How to maintain the data model?

Additional Topics

Business Analysis/Data Modeling and Recruiter

  • How to prepare the right resume?
  • What recruiters will be searching on your resume?
  • What information recruiters ask in preliminary screening?
  • How to get more hits on your resume?
  • How to place yourself quickly?

Business Analysis/Data Modeling and HR:

  • How to read out the offer letter?
  • What are the important clauses in offer letter?
  • How your salary is keyed in US Immigration Forms?
  • How to negotiate the best salary with HR?
  • How to find out the right wages recommended by US Department of Labor?

Business Analysis/Data Modeling and Immigration:

  • Why USCIS rejects the H1B/L1 petition?
  • How USCIS interprets Business Analyst position and Business System Analyst position?
  • How F1 students face problems when they apply for Business Analyst position through H1B Master’s Cap?
  • On what situation USCIS rejects a data modeler H1B or L1?

Business Analysis Data Modeling and Accounts Manager:

  • How Accounts Manager hire Business Analysis/Data Modeling candidates?
  • Why they give more importance to hire a US – F-1 student visa holder?
  • Why Accounts Managers are giving more focus to process US – H-1B and L-1 and L-1B visas?
  • On what situation Accounts Managers are focusing on US – B1 Visas?

Business Analysis/Data Modeling and Consulate Visa Interview:

  • What are the different questions asked in US Consulate Interview?
  • How to answer visa officer questions in a clear and crisp manner?