Chapter 10 ER Modelling – Database Design – 2nd Edition
2a': Data Modeling
Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)
Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you’ll learn what these terms are, so you can communicate better with ot…
OLAP Cubes in SQL Server
This article covers the basics of OLAP Cubes implementation using the SQL Server Analysis Service.
How to build a cube from scratch using SQL Server Analysis Services (SSAS)
In this article, we will learn how to create your first cube from scratch using SQL Server Analysis Services (SSAS)
Analysis Services What is the Difference between Tabular and Multidimensional Models
In Microsoft Analysis Services there are two model types: the Multidimensional and the Tabular. In this video, we'll explain what the difference is and which should you choose?
SSAS Multidimensional or SSAS Tabular
Download a free trial of our On-Demand Training Platform: http://pragmaticworks.com/Training/On-Demand-Training?hsCtaTracking=6bdedee8-b89b-420b-883d-37d9e6d...
Database Normalization
The class from the dude at the other college.
Practical Introduction to Dimensional Data Design
Very good.
B-trees in 4 minutes — Intro
More technical indexing information
Database Indexing for Dumb Developers
This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.
Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)
Boyce-Codd
Entity-Relationship Diagram Symbols and Notation
Confused about ERD Shapes? Check out this guide for a comprehensive look at all ER diagram symbols and notation.
A Practical Introduction to Databases — A Practical Introduction to Databases
A Practical Introduction to Databases, an open educational resource textbook.
Normalization: What does "repeating groups" mean?
Repeating groups are bunk.
Types of Relationships
Identifying vs non-identifying
Non-Identifying vs. Indentifying Relationships
Diagrams and explanations showing the difference between non-identifying (dashed line) and identifying (solid line) relationships in relational database design
What's the difference between identifying and non-identifying relationships?
I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?
TYPES OF RELATIONSHIPS IN DATA MODELLING
Start by learning the meaning of the relational database. A relational database is a type of database that stores and provides access to…
and usage phases. Entity-Relationship (ER) Model helps understanding
Entity Relationship Diagrams — An Explanation
An Entity-Relationship Diagram (ERD) is a visual layout of the structure of a database. It shows the relationships between different…
2. DATA MODELING — A Practical Introduction to Databases
Data Modeling: Conceptual vs Logical vs Physical Data Model
Data modeling is a technique to document a software system using entity relationship diagrams (ER Diagram) which is a representation of the data structures in a table for a company’s database. It is a very powerful expression of the company’s business requirements. Data models are used for many purposes, from high-level conceptual models, logical to …
Explaining 2NF vs 3NF with an example
I have a problem with second normal form (2NF) and I have been unable to solve it by using Google. It is making me crazy because I am a teacher and I don't want to teach wrong stuff to my students....
Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples
In relational databases, especially large ones, you need to arrange entries so that other maintainers and administrators can read them and work on them. This is why database normalization is important. In simple words, database normalization entails organizing a database into several tables in order to reduce redundancy. You can
Database Star VIP Page
Cheat Sheets (various)
An Introduction to Data Pipelines for Aspiring Data Professionals
This tutorial covers the basics of data pipelines and terminology for aspiring data professionals, including pipeline uses, common technology, and tips for pipeline building.
What is a data pipeline | IBM
Learn how data pipelines provide the foundation for both simple and complex analyses.
Explained : Conceptual, Logical, and Physical Data Models
Data lives at the heart of every modern system, but how do we organize and understand it? That’s where data models come in, blueprints for…
1.5: Chapter 5 Data Modelling
What Is Data Modeling? | IBM
Data modeling is the process of creating a visual representation of an information system to communicate connections between data points and structures.
Conceptual, Logical & Physical Data Models (Enhanced Audio)
Learn about the 3 stages of a Data Model Design- Conceptual Data Model- Logical Data Model- Physical Data Model**This is a re-upload of my previous video abo...