Pular para o conteúdo principal

Folhas De Consulta

programações conjuntas

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 de jul. de 2023

Code along with us onCode Along

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

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

11 min

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.

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

code-along

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.

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

See More See More