Search for Training

Data Modelling

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Data Modelling which gives you the opportunity to interact with a Data Modelling instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


  • Data warehousing and Business Intelligence Overview
  • Data Mining
  • Data Profiling
  • Star vs Snowflake schemas
  • Subject Areas and Enterprise Data Model
  • A Relational Database Modeling Tool
  • ERWin: Changing Physical Structure
  • The History of Data Modeling Collapse
  • What is a Data Model?
  • Types of Data Models
  • The Evolution of Data Modeling
  • File Systems
  • Hierarchical Databases
  • Relational Databases
  • The History of the Relational Database
  • Tools for Data Modeling
  • Entity Relationship Diagrams
  • Using ERWin
  • Data Warehouse Data Modeling
  • Available Database Engines
  • Relational Data Modeling
  • What is Normalization?
  • Normalization Made Simple
  • Relational Terms and Jargon
  • 1st Normal Form-Demonstrating 1st Normal Form
  • 2nd Normal Form-Demonstrating 2nd Normal Form
  • 3rd Normal Form-Demonstrating 3rd Normal Form
  • 4th and 5th Normal Forms-Primary/Foreign Keys/Referential Integrity
  • The Traditional Relational Database Model
  • Surrogate Keys and the Relational Model
  • Denormalization
  • The Dimensional Data Model Part pt. 1
  • The Dimensional Data Model Part pt. 2
  • Star Schemas and Snowflake Schemas
  • Getting Data from a Database
  • What is Structured Query Language (SQL)?
  • The Roots of SQL
  • Queries
  • Changing Data
  • Changing Metadata
  • Tuning a Relational Data Model
  • Normalization versus Denormalizatrion
  • Real Time Examples and Building a Sample Data Model

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 5 + 1? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter