COURSE

SQL Fundamentals

SQL is the language of data, and it is a critical skill to have when working as a Data Analyst, Data Scientist, or as a Data Engineer. In fact, more data analysts and data scientists use SQL than use either Python or R (because both Python and R programmers use SQL, too).  In our SQL Fundamentals course, you will learn the basics of this critical skill and start building some experience working with SQL databases.

This course will teach you how to explore and analyze data in SQL through hands-on active learning. You will learn concepts such as how to preview a SQLite database table and how to filter the rows in a table using the WHERE clause to select only the data you want to look at. You will also learn how to use aggregate functions in SQL to create summary statistics for various tables. Some aggregate functions you'll get familiar with are computing the minimum, maximum, and average values of a column.

You'll also learn how to use the GROUP BY clause to compute group-level summary statistics in a database table. We’ll cover how to query virtual columns using the HAVING clause to further filter your data after aggregation, and we’ll explain the difference between the WHERE clause and the HAVING clause.

In this course, you'll also learn how to write complex, nested SQL queries using subqueries. At the end of this course, you'll get hands-on practice using the Python SQLite workflow to explore CIA factbook data and learn to generate visualizations using SQLite results.

By the end of this course, you'll be able to:

  • Understand how to work with databases using SQL.
  • Understand the Python SQLite workflow.
  • Understand how to explore and analyze data in SQL.

START LEARNING

60+ FREE MISSIONS

By creating an account you agree to accept our terms of use and privacy policy.

Learn SQL Fundamentals

Introduction to SQL

Learn the basics of SQL to explore a dataset.

Summary Statistics

Learn how to calculate summary statistics in SQL.

Group Summary Statistics

Learn how to compute statistics across groups.

Subqueries

Learn how to write complex, nested queries using subqueries.

Querying SQLite From Python

Learn how to query a SQLite database from Python.

Analyzing CIA Factbook Data Using SQLite and Python

Practice the Python SQLite workflow using CIA Factbook data.