Data Analysis with SQL and Pandas (2 days)

Data Analytics is one of the key competencies for the modern workplace. Everyone can benefit from increasing their data literacy. In this course you will learn the basics of data analytics with SQL and Python.

Who should take this course?

  • STEM graduates looking for a career in Data Science / Data Analytics.
  • Working professionals looking to transition into Data Science / Data Analytics.

Prerequisites

  • Some previous knowledge of programming languages / data analysis is ideal but not required. If needed, the instructor will provide references for extra practice and self-study.

Topics Covered

SQL

  • Intro to databases. SELECT command. Single-table queries. GROUP BY.
  • JOIN statement and multiple-table queries.
  • Window Functions

Pandas

  • Indexing and Filtering Data
  • Split, apply and combine operations. Data aggregation.
  • Visualization with Pandas and Matplotlib
  • + Final Project