Saltar al contenido principal
InicioProgramando juntosData Analysis

Data Modeling in SQL

In this live training, you'll learn about data cleaning, shaping and loading techniques and learn about common database schemas for organizing tables for analysis.
12 jul 2023
Code along with us onCode Along

View Slides

Data modeling - how data is structured within your database - is an essential part of data engineering. Doing it right makes it easier for data analysts to understand the data they are working with, and helps you maintain data quality. In this live training, you'll learn about data cleaning, shaping and loading techniques and learn about common database schemas for organizing tables for analysis.

Key takeaways

  • Learn about common database schemas like star and snowflake.
  • Learn how to organize your database to make life easier for data analysts.
  • Learn about data transformation techniques to fit your data into a schema.
Temas
Relacionado

tutorial

Cleaning Data in SQL

In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.
Sayak Paul's photo

Sayak Paul

10 min

tutorial

Data Modeling in Power BI Tutorial

Discover what data modeling in Power BI is and how good data modeling practices can take your Power BI reports to the next level.
Joleen Bothma's photo

Joleen Bothma

11 min

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Jasmin Ludolf's photo

Jasmin Ludolf

code-along

Exploring Astronaut Activities in SQL

In this live training, we use string cleaning to process and analyze a database
Justin Saddlemyer's photo

Justin Saddlemyer

code-along

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.
Kelsey McNeillie's photo

Kelsey McNeillie

code-along

A Beginner's Guide to Data Analysis with SQL

In this session, DataCamp's VP of Media Adel Nehme & co-host of the DataFramed podcast, shows you how to get started with SQL.
Adel Nehme's photo

Adel Nehme

See MoreSee More