2a': Data Modeling

Code for "Advanced data transformations in SQL" free live workshop - josephmachado/adv_data_transformation_in_sql

Joins represent the denormalization of data to create dimensions and add dimension attributes to fact tables for reporting. Group bys enable the creation of metrics that determine how your data is used to make decisions. If you have wondered Why do your joins often end up in a dense block that's hard to pick apart. Why are people running nearly identical queries with only different join combinations. How to avoid losing data when performing joins How group bys have been used to mask underlying data modeling issues Why a group by all is considered a red flag Then this post is for you. In this post, we will cover how to use joins and group bys, as well as what to look out for when using them. By the end of this post, you will know what to watch out for when you perform joins or group bys.

Create a free DataCamp account

Create a free DataCamp account

Understanding the Basics and Advanced Levels of Database Normalization

Whether it's for your workplace or home project, learning how to design a database is a valuable skill. Let's take a look at six easy steps on how to design a …

Let’s go on an adventure into the amazing world of AdventureWorks Database!

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.

This article provides a step-by-step practical example on how to create a dimensional modeling with MySQL for analyzing sales data.

Useful queries for popular relational databases to explore schema.

Learn to comment & uncomment code, indent text, filter objects, access error logs, & find SQL Server instance names with SQL Server Management Studio.

I've tried to look on Google about a decent explanation of weak and strong entity type, but I haven't fully understood them. Could someone give me an example of a strong and weak entity type?

Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard

Database normalisation is a concept that can be hard to understand. But it doesn’t have to be. In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms.

Quickly learn UML Activity Diagram. Read this UML guide for everything you need to know about Activity Diagram.

This guide will help you to unravel the confusion of whether to use a tabular or a multidimensional model for your business intelligence semantic layer.

A blog about databases and data architecture

Designing a star schema data warehouse based on the Northwind database and implementing the ETL process using the SSIS tool. - JokoCyber/northwind-date-warehouse

SQL vs. T-SQL — what's the difference, and which one should you learn if you need to work more efficiently with your company's database? We'll tell you.

SSIS How to Create an ETL Package

This graduate-level course will teach you

In this project, I used SQL to query, update, and reorganize data, as well as to create and modify the schema (structure) of a database…

IBM Documentation.

A semantic layer is a semantic data model that shows to the business user: a dimensional view (dimensional schema) from a relational schema. It will create/model a logical star schema by: ...