What’s in it: Data Model, High Level Data Modeler Responsibilities along with images of a conceptual data model, logical data model and physical Data Model is explained using Erwin Data Modeling Tool.
What’s in it: This question is asked by the Interviewers. Our video explains step by step process in Data Modeling Development Life Cycle. This life cycle is common for RDMS Data Modeling and Dimensional Data Modeling.
What’s in it: ER Diagram also know as Erwin Relationship Diagram is explained with a data model created by using Erwin Data Modeling Tool. Primary Key Constraint, Composite Primary Key Constraint, Foreign Key Constraint, Composite Foreign Key Constraint are explained here in this Data Modeling Video Tutorial.
What’s in it: This is the first phase in designing the data model in the Data Modeling Development Life and is explained in Detail with image of Erwin Data Model.
What’s in it: The is second phase in designing the data model in the Data Modeling Development Life Cycle and is explained in details
What’s in it: The differences between Logical Data Model and Physical Data Model is tabulated and explained with the help of a data model created from the Erwin Tool.
What’s in it: Entity and Attribute are explained with a Diagram.
What’s in it: Identifying and Non-Identifying Relationship are explained with the help of a small data model drawn from Erwin Data Modeling Tool. Difference between those two are also explained.
What’s in it: Forward Engineering, Reverse Engineering, SuperType and SubType are explained.
What’s in it: Data Model Meta Data & Data Model Repository are explained in this video tutorial.
What’s in it: This video explains important points in designing the Data Mart and Data Warehouse Schema.
What’s in it: This video explains the basics of Dimensional Data Model and Schema with OLA use case as the example.
What’s in it: Basics of ETL, Datawarehouse and Datamart are explained in this Data Modeling Video Tutorial.
What’s in it: Brief explanation of Check Constraint, Sequence, and Index is explained. Also NULL values in Unique constraint are explained. The above topic is an important question in the Data Modeling Interview..
What’s in it: Brief explanation about OLTP data modeling and constraint. This is an important question in Data Modeling Interview.
What’s in it: Foreign Key Constraint is explained in a detailed manner by taking an example from IBM.
What’s in it:
This video helps with the list of interview questions that can be asked in creating :
Conceptual data model by Erwin.
Logical data model by Erwin.
Physical data model by Erwin.
What’s in it:
These Dimensional Data Modeling Questions are related to Data Warehouse and Data Mart.
When you work as an ETL developer or BI developer, these questions will be asked in the interview.
Learn data modeling design Skills on OLTP and OLAP from a US University Professor with…
These SQL commands are related with Oracle's data dictionary and can be used to get…
important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..
In this section, we will try to explain about important database DROP commands that are…
In this section, we will try to explain about important database DML commands that are…
In this section, we will try to explain about important database ALTER commands that are…