DataCamp

📊 Guided Projects using SQL

1. Analyze International Debt Statistics

🔑 Key Learnings

• Using aggregate functions such as SUM(), MAX()
• Filter techniques such as WHERE, GROUP BY
• Sorting using ORDER BY
• Limiting results using LIMIT clause
• Subquery in WHERE clause

View my project here!

2. Analyzing American Baby Name Trends

🔑 Key Learnings

• Using aggregate functions such as SUM(), MAX(), COUNT()
• Filter techniques such as WHERE, GROUP BY and HAVING()
• Sorting using ORDER BY
• Limiting results using LIMIT clause
• Pattern matching using the LIKE operator
• Classifying using CASE WHEN statement
• Subqueries
• Window functions using RANK() and SUM()
• Common Table Expressions (CTEs)

View my project here!

3. Analyzing NYC Public School Test Result Scores

🔑 Key Learnings

• Using aggregate functions such as SUM(), MIN(), MAX(), COUNT()
• Filter techniques such as WHERE, GROUP BY
• Sorting using ORDER BY
• Limiting results using LIMIT clause

View my project here!

4. Optimizing Online Sports Retail Revenue

🔑 Key Learnings

• Using aggregate functions such as COUNT(), AVG()
• Filter techniques such as WHERE, GROUP BY and HAVING()
• Sorting using ORDER BY
• Cleaning data using TRUNC, EXTRACT
• Labeling using CASE WHEN statement
• Casting using CAST
• Inner JOIN
• Common Table Expressions (CTEs)

View my project here!

5. What and Where Are the World's Oldest Businesses?

🔑 Key Learnings

• Using aggregate functions such as MAX(), MIN(), COUNT()
• Filter techniques such as WHERE, GROUP BY and HAVING
• Sorting using ORDER BY
• Inner JOIN and LEFT JOIN

View my project here!

6. When Was the Golden Age of Video Games

🔑 Key Learnings

• Filter techniques such as WHERE, GROUP BY and HAVING()
• Sorting using ORDER BY
• Limiting results using LIMIT clause
• Subquery in WHERE clause
• Inner JOIN and LEFT JOIN
• Set theory concepts such as EXCEPT, INTERSECT

View my project here!