🔅 Python in Excel: Getting Started with Data Analysis

📝 Explore the core concepts and fundamental skills of working with data using Python in Microsoft Excel.

🌐 Author: Joe Marini
🔰 Level: Intermediate
⏰ Duration: 1h 40m

📋 Topics: Data Analysis, Microsoft Excel, Python

🔗 Join Data Analysis for more courses

📱Data Analysis
📱Python in Excel: Getting Started with Data Analysis

📖 Types of Keys in SQL

🔅 Advanced NoSQL for Data Science

📝 Explore the fundamentals of NoSQL. Learn the differences between NoSQL and traditional relational databases, discover how to perform common data science tasks with NoSQL, and more.

🌐 Author: Dan Sullivan
🔰 Level: Advanced
⏰ Duration: 1h 54m

📋 Topics: Data Science, NoSQL

🔗 Join Data Analysis for more courses

📱Data Analysis
📱Advanced NoSQL for Data Science

📦 Exercise Files

📖 SQL cheat sheet - Every JOIN explained

🔰 The 4 Types of SQL Joins

SQL joins combine rows from two or more tables based on a related column. Here are the different types of joins you can use:

1⃣ Inner Join
Returns only the matching rows between both tables. It keeps common data only.

🔢 Left Join
Returns all rows from the left table and matching rows from the right table. If a row in the left table doesn’t have a match in the right table, the right table’s columns will contain NULL values in that row.

🔢 Right Join
Returns all rows from the right table and matching rows from the left table. If no matching record exists in the left table for a record in the right table, the columns from the left table in the result will contain NULL values.

🔢 FULL OUTER JOIN
Returns all rows from both tables, filling in NULL for missing matches.

🔅 Python Data Structures: Dictionaries

📝 Learn how to use dictionaries to store and retrieve unordered data in Python.

🌐 Author: Deepa Muralidhar
🔰 Level: Beginner
⏰ Duration: 57m

📋 Topics: Data Structures, Python

🔗 Join Data Analysis for more courses

📱Data Analysis
📱Python Data Structures: Dictionaries