MISSION 363

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. Grabbing Data With SELECT
3. Filtering Your Data With WHERE and LIMIT
4. Expressing Multiple Filters Using AND
5. Returning One of Several Conditions With OR
6. Grouping Operators With Parentheses
7. Specify Sorting Rules With ORDER BY
8. Practice Writing A Query
9. Next Steps
10. Takeaways

sql-fundamentals

Course Info:

SQL Fundamentals for R Users

Beginner

The average completion time for this course is 3 –4-hours.

This course requires a basic subscription and includes four missions and one guided project.  It is the fifth course in the ​Data Analyst in R Path​​​

START LEARNING FREE

Take a Look Inside