SQL FUNDAMENTALS FOR R USERS > MISSION 1 > LEARN SQL

Introduction to SQL

In our introduction to SQL mission, you’ll learn the basics of using SQL to explore a data set. 

SQL is the main language you will use to pull data from a database while working as a data analyst or data scientist. Knowing SQL and being adept at writing queries is a critical skill you need to have. Throughout this lesson and future lessons, we'll gradually grow your skills to ensure you are proficient and prepared to become data literate and land your first job in data!

In this lesson, you will learn the basic components of a SQL query, such as `SELECT` and `FROM`. You will also learn how to filter data using the `WHERE` clause, as well as checking for multiple conditions when filtering using the `AND` and `OR` clauses. 

In addition to filtering the data returned, you will learn how to control the results set using the `ORDER BY` clause and the `LIMIT` clause.

While learning about each of the above clauses, you will be working with a bit of data that contains the 2010-2012 data for college grads. This dataset contains information on job outcome statistics based on college majors. With each concept, you'll be using our code running system with answer checking so you can ensure you've mastered each concept before moving on to the next concept.

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:

Beginner

The median completion time for this course is 3.5 hours. ​View Details​​​

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