Filtering and Sorting data in SQL
Continue your SQL learning journey!
This second course in our SQL course skill path is all about taking your SQL query skills to the next level. After learning the basics in our first SQL fundamentals course, you're ready to start doing more advanced querying, filtering, and analysis with SQL.
SQL skills are also valuable in any role that involves work with data or spreadsheets. If you spend some of your working hours in Excel, chances are you could benefit from learning SQL skills.
Do what you couldn't do before.
Ace your interviews. You'll be coding from the get-go and you can take this experience directly into your next technical SQL interview.
Get premium learning content. Our in-house team of senior data experts developed our SQL courses based on real-world applications. You can take what you learn from this content directly into your current (or future) data job.
Learn one step at a time. This step-by-step learning path will teach you everything you need to know at your own pace.
Your SQL questions, answered:
Course Structure: Filtering and Sorting Data in SQL
Continue your learning journey with SQL!
Datatypes and Column Operations
Learn about the different datatypes available in SQL columns and which operations work with which datatypes.
Learn about functions, nested functions, and what to do about missing values in SQL database tables.
Filtering I — Logical Operators
Learn more about expressions, conditions, and filtering data using WHERE in combination with operators NOT, AND, and OR.
Filtering II — Complex Expressions
Learn how to use comparison operators, master SQL's order of execution, and learn about the BETWEEN operator.
Filtering III — Special Comparison Operators
Learn about the LIKE operator, filtering by pattern, and checking if expressions are NULL (among other special topics).
Learn to create if/then rules in SQL, and start using the CASE expression while avoiding some of its common mistakes and pitfalls.
Learn to get the results of your SQL query in whatever order you're looking for!
It's not just what you learn,
but how you learn it.
Dataquest is recommended by 97% of students for learning data skills.
Learn by writing and validating code, not by watching videos.
Challenge yourself with dozens of SQL practice problems.
Revisit what you've learned anytime you need a refresher.
Join over 1 million data learners!
Rated 4.85/5 on Switchup + Voted Best Bootcamp Winner of 2021
David Rodrigues @davidorodrigues
I left datacamp for @dataquestio. 10x better I wish I had started Dataquest 2 years ago.
Lysdel Tellez @LysdelTellez
It’s great! So many options; R, SQL, Python. And they take you on guided projects where you understand the reasoning behind the code and are able to apply it to future projects.
Cesar Jr @ceeezthedata
I've been learning data science with Dataquest — and it's a game changer! No boring videos or fill-in-the-blank exercises. Try it for yourself!
Studying with @dataquestio has been the best decision I have made this year.
Ijeoma Benson @ijeybenson
If you want to get into a career in data, choose DQ. The education they offer would stretch you and prepare you for real life work.
Matthew Madden @mattmadden
I've found @dataquestio super helpful in levelling up my data skills. #100daysofcode #DataScience
We Learn Better Together
When you join Dataquest, you join a community of committed learners.