SQL Fundamentals Part II

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.

DURATION
2 Hours
LESSONS
7
DIFFICULTY
Intermediate
ENROLLED
341,010

Start learning for free!

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

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.


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.

Functions

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

Control Flow

Learn to create if/then rules in SQL, and start using the CASE expression while avoiding some of its common mistakes and pitfalls.

Ordering Results

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.

Retain

Learn by writing and validating code, not by watching videos.

Reinforce

Challenge yourself with dozens of SQL practice problems.

Reference

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.

1

3

6

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.

2

5

14

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!

2

5

14

ChukwuSom @legally_6lack 

Studying with @dataquestio has been the best decision I have made this year.

13

2

24

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.

33

12

86

Matthew Madden @mattmadden

I've found @dataquestio super helpful in levelling up my data skills. #100daysofcode #DataScience 

12

7

17

We Learn Better Together

When you join Dataquest, you join a community of committed learners.


Get fast help with your technical questions 


Share your projects and get supportive feedback


Chat one-on-one with developing data experts


Get career tips from career moderators


Start learning SQL today!

Looking for something else? Browse our career paths.

Start learning for free!

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