āļ‚āđ‰āļēāļĄāđ„āļ›āļĒāļąāļ‡āđ€āļ™āļ·āđ‰āļ­āļŦāļēāļŦāļĨāļąāļ
āļāļēāļĢāđ€āļĢāļĩāļĒāļ™ data science

Data Science Tutorials

Learn data science and AI with step-by-step tutorials on the DataCamp blog. Master Python, SQL, machine learning, and build your own AI agents.

āļ„āđ‰āļ™āļžāļšāļŦāļĄāļ§āļ”āļŦāļĄāļđāđˆ

āļāļķāļāļ­āļšāļĢāļĄ 2 āļ„āļ™āļ‚āļķāđ‰āļ™āđ„āļ›?āļĨāļ­āļ‡āđƒāļŠāđ‰ DataCamp for Business
SQL

SQL Pivot Rows to Columns: A Comprehensive Guide

Learn the art of pivoting rows into columns in SQL in Oracle, MySQL, and SQL Server. Explore practical methods with detailed examples to boost your data engineering skills.

Allan Ouko

Data Science

Iloc vs Loc in Pandas: A Guide With Examples

.loc selects data using row and column names (labels), while .iloc uses numerical indices (positions). Learn how to use both with examples.

Tom FarnschlÃĪder

SQL

CTE in SQL: A Complete Guide with Examples

Understand how to use common table expressions to simplify complex queries for improved readability. Learn the difference between non-recursive and recursive CTEs.

Allan Ouko

Data Engineering

What is Third Normal Form (3NF)?

Learn how third normal form (3NF) can help you organize your databases more efficiently by removing redundancy and minimizing dependency issues. See how decomposing tables can simplify data management.

Marie Fayard