MISSION 252

Introduction to SQL

Learn the basics of SQL to explore a dataset.

Objectives

  • Learn how to preview a SQLite database table.
  • Learn how to filter the rows in a table.

Mission Outline

1. Introduction to Databases
2. Previewing A Table Using SELECT
3. Filtering Rows Using WHERE
4. Expressing Multiple Filter Criteria Using AND
5. Returning One of Several Conditions With OR
6. Grouping Operators With Parentheses
7. Ordering Results Using ORDER BY
8. Practice Writing A Query
9. Next Steps
10. Takeaways

sql-fundamentals

Course Info:

SQL Fundamentals

Beginner

The median completion time for this course is 6.3 hours.

This course requires a basic subscription and includes five 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

Take a Look Inside