MISSION 252

Introduction to SQL

In our introduction to SQL mission, learn the basics of 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 paramount skill you need to have. Throughout this mission and coming missions, you'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 mission, 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 clause. 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. 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:

Beginner

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

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