Data Modelling Online courses from Udemy

Data Modelling courses

Data modelling is the process of creating a visual representation of data structures and the relationships between them.

What is Data Modelling?

The purpose of data modelling is to organise data in a way that makes it easier to understand, manage, and analyse.

Data models are used in many different fields and applications, including database design, software engineering, and business intelligence.

In the context of databases, data modelling involves defining the tables, columns, relationships, and constraints that make up a database.

There are several different types of data models, including conceptual, logical, and physical data models.

Conceptual data models provide a high-level overview of the data and the relationships between entities.

Data modeling is typically done using visual tools, such as ER (entity-relationship) diagrams, rather than code. However, here’s an example of a data model in SQL:

CREATE TABLE Customer (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100),
    Phone VARCHAR(20)
);

CREATE TABLE Order (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID)
);

CREATE TABLE OrderLine (
    OrderLineID INT PRIMARY KEY,
    OrderID INT,
    ProductID INT,
    Quantity INT,
    Price DECIMAL(10, 2),
    FOREIGN KEY (OrderID) REFERENCES Order(OrderID)
);

CREATE TABLE Product (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(50),
    Description VARCHAR(200),
    Price DECIMAL(10, 2)
);

This example creates four tables in a relational database: “Customer”, “Order”, “OrderLine”, and “Product”.

The tables are related to each other through foreign key constraints. The “Customer” table stores information about customers, including their names, email addresses, and phone numbers.

The “Order” table stores information about orders, including the customer ID, order date, and total amount.

The “OrderLine” table stores information about the items in each order, including the product ID, quantity, and price.

The “Product” table stores information about the products, including their names, descriptions, and prices.

This data model can be used to store and manage data about customers, orders, and products, and to run queries and generate reports based on that data.

Logical data models define the structure of the data in more detail, including the attributes and relationships between entities.

Physical data models define the actual implementation of the database, including the data types, indexes, and storage mechanisms.

Data modelling is an iterative process that involves several steps, including requirements gathering, designing the data model, testing and validation, and implementation.

The goal of data modelling is to create a data model that accurately represents the data and supports the business requirements.

New to Udemy? Lucky you.

Courses start at INR 449. ( USD 6 only) Get your new-student offer before it expires.

Here are the Top Handpicked Data Modelling courses from Udemy

Courses could not be fetched. Please try again.

azure blockchain comptia A+ cybersecurity data science django flask front end web development google it support google it support certificate google it support professional certificate google it support professional certificate cost google it support professional certificate worth it google it support salary It Certification java javascript ketan kk machine learning algorithms machine learning course machine learning definition machine learning engineer machine learning interview questions machine learning jobs machine learning python machine learning vs deep learning mongoDB Network & Security nodejs Operating Systems Other It & Software price elasticity calculator python rest api ruby science of well being science of well being yale Udemy courses university of colorado boulder university of colorado boulder ranking university of colorado colorado springs university of colorado denver university of colorado hospital web development


Other Best seller udemy courses

Microsoft Excel – Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365


Microsoft Excel – Advanced Excel Formulas & Functions

Master 75+ MS Excel formulas and learn data analysis with a top Microsoft Excel & business intelligence instructor


Unlock Excel VBA and Excel Macros

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.


Power BI Completo – Do Básico ao Avançado

Aprenda o passo a passo exato para criar dashboards e relatórios dinâmicos usando Business Intelligence


Microsoft Excel – Data Analysis with Excel Pivot Tables

Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor


Excel Completo – Desde Principiante Hasta Avanzado

Conviértete en un Experto en Excel Desde Cero. Excel 2010, 2013, 2016 2019 and Microsoft/Office 365


Do Básico ao Avançado – O Curso Completo de Microsoft Excel

Das ultimative Excel Kurs Komplettpaket: Jetzt durchstarten!

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Microsoft Excel: dai fondamentali al livello avanzato

Excel Básico Avançado 5 Cursos – Formação Especialista

Master Microsoft Word Beginner to Advanced

Master Excel Power Query Beginner to Advanced (including M)

Excel Essentials: The Complete Excel Series – Level 1, 2 & 3