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