Filtering and Sorting Data in SQL

This is the second course in our SQL Fundamentals skill path. In the previous course, you learned the essentials for getting started working in SQL. In this course, you’ll build upon those essentials and start learning more advanced querying, filtering, and analysis techniques using SQL.

We’ll start by teaching you how to identify and work with the various data types you’ll encounter in just about any data science role. Next, we’ll introduce you to new concepts like functions, operators, expressions, and control flow, and we’ll show you how to use them to optimize your work in a database.

This course focuses on the following:

  • Intermediate techniques for querying, filtering, and analyzing data in SQL
  • SQL functions, operators, and expressions
  • How to use SQL to streamline your work in databases

97% of our data learners recommend Dataquest for career advancement. Join today!

Get started for free

No credit card required.

Already have an account? Sign in →

By creating an account you agree to accept our terms of use and privacy policy.

What You’ll Learn

We’ve divided our SQL Fundamentals course into two parts — this is the second part. If you missed the first part or would like a refresher, check out the lessons from the previous course! In this second part of our SQL Fundamentals course, you’ll learn intermediate concepts and techniques that will prove invaluable to your data science workflow, no matter what specific role you assume in data science.

Working in data science requires that you work with databases, and sometimes databases can be immense and disorganized. That’s why SQL is such a valuable asset for data professionals. In this course, you’ll learn how to precisely identify, filter, and extract the data you need using SQL functions, operations, expressions, and more.

Enroll in this course if you want to do the following:

  • Identify different data types
  • Execute operations between columns
  • Define aliases and functions
  • Employ nested functions
  • Resolve missing values
  • Define expressions and conditions
  • Identify the order of execution
  • Employ the `BETWEEN` and `LIKE` operator
  • Filter based on patterns
  • Check if an expression is `NULL`
  • Program if/then rules
money in envelope

SQL devs command an average salary of over $93,000/yr, according to ZipRecruiter.

bar graph going up

Over 70% of developers use SQL more than any other language, per StackOverflow.

Indeed data finds over 50% of data job postings include SQL as a required skill.

How Our SQL Fundamentals Part II Course Works

Even though SQL is half a century old, it’s one of the most important skills to learn if you want a data career. Big companies like Uber, Netflix, and Airbnb all use SQL. Also, it’s more in-demand now than ever. Currently, over 50% of data job postings on Indeed list SQL as a required skill.

At Dataquest, it’s our job to help you develop these in-demand data science skills so that you excel in your data science career. Since SQL is such a prominent part of data science, we’ve created our SQL Fundamentals skill path, including this course. We’ve carefully designed our lessons to give you the structure you need as well as the freedom to explore and maximize learning.

Here at Dataquest, we believe in learning by doing. That’s why we’ll never ask you to sit through boring training videos or ineffective “fill-in-the-blank” questions. Instead, we believe the best way to learn data science skills is by solving real problems with actual code.

Additionally, with Dataquest, you’ll never learn alone. By signing up with us, you’ll become a part of our supportive community of data learners and professionals who are eager to help you overcome any obstacle. And if you ever need a little extra help, our powerful and responsive support tools are just a click away.

Here’s a glance at our SQL Fundamentals course:

Enroll in this course to learn SQL Fundamentals Part II!

Filtering and Sorting Data in SQL Lessons List

Datatypes and Column Operations

In this lesson, learn all about datatypes, string operations, and column operations. Learn to use documentation and how to define aliases.

Functions SQL Fundamentals Part II

Continue learning about functions in SQL, including defining functions, employing nested functions, and resolving missing values.

Filtering I — Logical Operators

In this introduction to logical operators, you’ll learn how to order results.

Filtering II — Complex Expressions

Continue learning about filtering in this lesson on comparison operators, the order of execution, and the “BETWEEN” operator.

Filtering III — Special Comparison Operators

Learn how to filter results using special comparison operators, including the “LIKE” operator and patterns.

Control Flow

In this lesson, learn how to code if/then/else rules in SQL and how to use the “CASE” expression.

Ordering Results

Learn how to order results in this lesson using the Chinook Music Store Database.

Who Is this SQL Fundamentals Course for?

We created this SQL course for beginners, but it does require prerequisite knowledge of basic SQL concepts and techniques from our previous course. If you haven’t completed Part I of our SQL fundamentals course, we strongly recommend you return to our previous lessons before starting this course.

This SQL beginners course has a broad application — we didn’t design it for any one kind of person. Here are a few examples of people who could benefit from these lessons in SQL:

Students Who Enrolled in this Course Also Enrolled in these:

If you’re one of the many thousands learning SQL for a data science career, we encourage you to enroll in any of the following. We’ve crafted these paths specifically to help you develop the in-demand skills you need to jump-start your data science career:

Or perhaps you already have a data science background. If you simply want to expand your knowledge base and broaden your skill set, we’re happy to recommend the following courses to enhance your job performance:

Qualify for In-demand Jobs in Data Science With SQL

SQL has stood the test of time and remains the universal language for databases — and one of the most necessary skills for any career in data science. Consequently, proficiency in SQL is in very high demand across a variety of industries and data positions.

With the skills you’ll learn in this course, you’ll be ready for success in any of the following in-demand data specializations: