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