Database

[SQL Basic] Let’s learn some advanced JOIN queries!

[SQL Basic] How to work with Date Functions in SQL — SQL DATE_FORMAT, DATEDIFF

#16. Marketing/Data Analysis for Beginners

[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery

#15. Marketing/Data Analysis for Beginners

[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN

#14. Marketing/Data Analysis for Beginners

[SQL Basic] Let’s designate a value based on the rental duration. — SQL CASE

#12. Marketing/Data Analysis for Beginners

[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN

#13. Marketing/Data Analysis for Beginners

[SQL Basic] How many movies have the same rating?— SQL GROUP BY/HAVING

#11. Marketing/Data Analysis for Beginners

[SQL Basic] What is the average film length? — SQL AVG/MIN/MAX

#10. Marketing/Data Analysis for Beginners

[SQL Basic] What is the total length of all the films added together? — SQL COUNT/SUM

#9. Marketing/Data Analysis for Beginners

[SQL Basic] Let’s see some Sample Database tables!

#8. Marketing/Data Analysis for Beginners