COURSE

SQL Fundamentals

Learn the basics of working with SQL databases.

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.
sql-fundamentals

Course Info:

SQL Fundamentals

Beginner

The average completion time for this course is 10-hours.

This course requires a basic subscription and includes four missions and one guided project.  It is the 11th course in the Data Analyst in Python path and the Data Scientist in Python path.

START LEARNING FREE

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.