CommonLounge Archive

Learn SQL for Data Analytics

July 04, 2018

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:

  1. Learn how to create, query, and modify databases using commands such as Create, Select, Where, Group, Having, Update, Truncate, etc.
  2. Create relationships between tables using Joins.
  3. Learn how to aggregate data using mathematical functions and create reports using these aggregates.
  4. Lean how to write efficient and dynamic queries using case statements, temporary tables, and subqueries.
  5. 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!

Querying Data in SQL

  • Collect data using standard SQL commands (Create, Update, Truncate, Select, etc.).
  • Filter data using advanced SQL commands (Where, Group By, Having, Order By, Distinct, Limit).
  • Obtain data by creating relationships between tables using Joins (Inner, outer, union)
  • Gather filtered data using SQL Boolean operators (AND and OR) and SQL conditional operators (=, >, <, and BETWEEN).
  • Querying Databases in SQL Part 1
  • Querying Databases in SQL Part 2

Aggregating Data in SQL

  • Write Boolean statements with the IN SQL conditional operators and null functions (“IS NULL,” “IS NOT NULL,” and “IFNULL”).
  • Clean data using SQL mathematical functions (ABS, SIGN, MOD, etc.).
  • Summarize data sets by employing aggregation functions (“Sum,” “Average,” “Count,” etc.).
  • Creating reports by applying aggregation methods.
  • Aggregating Data in SQL Part 1
  • Aggregating Data in SQL Part 2

Writing Efficient and Dynamic Queries

  • Use CASE statements to structure data and create new attributes.
  • Combine multiple subqueries into one using “AS.”
  • Temporary Tables and Subqueries.
  • Determining data trends through advanced reporting.
  • Writing Efficient and Dynamic Queries

© 2016-2022. All rights reserved.