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:
Learn SQL Fundamentals
Introduction to SQL
Learn the basics of SQL to explore a dataset.
Learn how to calculate summary statistics in SQL.
Group Summary Statistics
Learn how to compute statistics across groups.
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.