Advanced SQL Querying

This badge is earned by successfully completing the Advanced SQL Querying course at Maven Analytics.

COURSE HOURS: 13.5

COURSE DESCRIPTION:

SQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst, data scientist and BI professional should seek to master.

In this course, we’ll move beyond the basic "Big 6" clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY) and cover advanced querying techniques like JOIN types, subqueries, CTEs and window functions.

From there, we’ll introduce advanced functions used for manipulating various data types, including numeric, datetime, string and NULL functions.

Finally, we'll practice solving real-world business problems and common data analytics use cases by applying advanced querying techniques like pivoting with CASE statements, calculating running totals with window functions, and more.

If you're looking for a hands-on, practical guide to advanced querying with SQL, this is the course for you.