Course

You'll learn how to:

Start this course today

Build hands-on data skills with interactive exercises and projects.

Sign up

About this course

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

Lessons in this course

Loading lessons....

Thousands of learners have changed their careers with Dataquest

97%

Learners who recommend
Dataquest for career advancement

4.9 stars

Dataquest rating on
G2Crowd and SwitchUp

$30k

Average salary boost
for learners who complete a path

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:

  • This course is the second course in the SQL Fundamentals skill Path. It consists of the seven lessons listed below, which cover intermediate coding concepts in SQL.
  • You’ll write real code with dozens of practice problems so you can apply your skills.
  • When you complete this course, you’ll receive a certificate that you can share with your professional network.
  • Once you complete this course, you’ll be ready for more advanced SQL courses.
  • Engage with our friendly community of data professionals, get feedback on your projects, and keep building your skills.

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:

  • Data science beginners looking for fundamental SQL knowledge for data science
  • SQL beginners seeking proficiency with basic operations in SQL
  • People who want a career as a data analyst, data engineer, or data scientist
  • People seeking remote work in data science
  • Anyone who works with data in telecommunication, finance, education, and healthcare
  • Junior data analysts or data scientists who want to advance in their current positions
  • Anyone who wants to be able to capture, process, and interpret data
  • Students who wish to develop a competitive portfolio
  • Experienced SQL users who want to brush up on the basics

Join a community of 1M+ data learners on Dataquest

1

Sign up for a free account

Get access to hundreds of free lessons.

2

Choose a course or path

Start anywhere, from beginner topics to advanced concepts.

3

Learn with hands-on exercises

Learn with real data and build your experience.

Apply your skills

Create projects, build your portfolio, and build your career.

Sign up today

or