This 5-part course consists of tutorials on how to learn SQL for Data Analytics. It's designed to be very hands-on and will walk you through the fundamentals of querying, aggregating, and creating reports. You don't have to have any knowledge of programming to do this course!
The primary objectives of this course are as follows:
- Learn how to create, query, and modify databases using commands such as Create, Select, Where, Group, Having, Update, Truncate, etc.
- Create relationships between tables using Joins.
- Learn how to aggregate data using mathematical functions and create reports using these aggregates.
- Lean how to write efficient and dynamic queries using case statements, temporary tables, and subqueries.
- Get hands-on practice using SQLFiddle
Why SQL?
This tutorial is created for people who want to answer questions using data. Increasingly, SQL is becoming more and more important when analyzing data since it's used for every aspect from storing to cleaning, accessing, and gaining insights from information already stored in databases. It's easy to understand and can be used to go through vast amounts of data — this is why it's used by the world's largest companies!