JetBrains Academy Course Catalog
CoursesSkill paths
Subjects
AI Coding ToolsAI EngineeringAlgorithms and Data StructuresBackendCloud & DevOpsData ScienceDeep LearningDevOpsFrontendFull StackKotlin & AndroidMachine LearningMathML & MathSQL and DatabasesWeb Dev
Languages
C/C++GoHTML/CSSJavaJavaScriptKotlinPythonRustScala
In-IDE learningFreeJetBrains Academy

Introduction to SQL

A fast-paced SQL intro covering data types, filtering, joins, and aggregations. Perfect for beginners with basic programming experience.

Beginner

You'll take this course in your JetBrains IDE.
Just install JetBrains Toolbox 2.7+, and we'll handle the rest!

Beginner

About

A fast-paced introduction to SQL fundamentals. You'll learn the core essentials: data types, filtering results, joining tables, and aggregating data. Designed for complete SQL beginners (some programming experience helps, but isn't required). Note: We recommend IntelliJ IDEA Ultimate (free for students via the JetBrains Student Pack).

Content

  1. Welcome
  2. Navigating Around
  3. Course View
  4. Editor
  5. Task Description
  1. What is in this lesson
  2. T1: Search in a tiny dataset
  3. Ex: Search in a tiny dataset
  4. T2: Search in a small dataset using spreadsheets or command-line tools
  5. Ex: Search in a small dataset using spreadsheets or command-line tools
  6. T3: Complex search tasks and big datasets
  7. Ex: Writing search queries in Kotlin
  8. T4: Meet SQL language
  1. What is in this lesson
  2. T1: SELECT clause and arithmetic expressions
  3. Ex: Arithmetic expressions
  4. T2: String expressions
  5. Ex: String expressions
  6. T3: Boolean expressions
  7. Ex: Boolean expressions
  8. T4: Three-valued logic
  9. Ex: More expressions
  1. What is in this lesson
  2. IDE: Connect to the course database
  3. IDE: Explore tables
  4. IDE: Run SQL from the editor
  5. T1: Select everything
  6. T2: Simple data filtering
  7. Ex: Simple data filtering
  8. T3: Subqueries in WHERE clause
  9. Ex: Subqueries in WHERE
  1. What is in this lesson
  2. T1: Inner Join operator
  3. Ex: Inner join
  4. T2: Outer joins
  5. Ex: Outer joins
  6. T3: Join chains and filters
  7. T4: Make a join not using a join
  8. Ex: Make a join not using a join
  1. What is in this lesson
  2. T1: Aggregate functions and scalar subqueries
  3. Ex: Aggregate functions and scalar subqueries
  4. T2: Aggregate functions and rows grouping
  5. Ex: Aggregate functions and rows grouping
  6. T3: Aggregate functions, groups and filters
  7. Ex: Aggregate functions, groups and filters
  1. What is in this lesson
  2. T1: Subqueries in FROM clause
  3. Ex: Subqueries in FROM
  4. T2: Common Table Expressions
  5. Ex: Common Table Expressions
  1. That's a wrap!

Learn with the tools developers use every day

Real-world development environment (Python)
Project-based learning journey (Python)
Collaboration via Git (Python)
Focused learning (Python)

  • Real-world development environment

    Gain hands-on experience with the same tools and workflows you'll use in your career, reducing the learning curve when transitioning to real-world projects.

  • Project-based learning journey

    Our plugin is designed to guide you through real coding projects that you can showcase in your portfolio after completion.

  • Collaboration via Git

    Easily track changes and collaborate on projects using Git — an essential tool for developers in every field.

  • Focused learning

    Enjoy fewer distractions with assignments, coding, debugging, and version control all in one window

Student? Get JetBrains IDEs & hands-on courses — free for the full duration of your studies.

What do you need to start?

1

Install the free JetBrains Toolbox App

The JetBrains Toolbox App 2.7+ makes setting up your course effortless. Already have a compatible IDE? It will launch it. If not, the app will install the right IDE for your course.

Learn more about our licenses here.

JetBrains Toolbox App illustration
2

Confirm the course launch

Click Take course and then Allow to open the Toolbox App.

Select Always Allow to skip this confirmation in the future.

To return to the course later, find it in your IDE's recent projects.

Need more help? Check out our guide.

Course launch confirmation illustration
JetBrains Toolbox App illustration

The JetBrains Toolbox App 2.7+ makes setting up your course effortless. Already have a compatible IDE? It will launch it. If not, the app will install the right IDE for your course.

Learn more about our licenses here.

JetBrains Toolbox App illustration

Click Take course and then Allow to open the Toolbox App.

Select Always Allow to skip this confirmation in the future.

To return to the course later, find it in your IDE's recent projects.

Need more help? Check out our guide.

JetBrains Toolbox App illustration

FAQ and troubleshooting

Yes, you will need the JetBrains Toolbox App and a JetBrains IDE.

Just click this link to install the JetBrains Toolbox App. We've taken care of all the necessary settings, and the app will handle the rest of the setup for you.

The JetBrains Toolbox App checks which IDE is compatible with your course and whether it is installed on your computer. If you have the necessary IDE installed, the app will open it. If not, JetBrains Toolbox will initiate the installation, prioritizing free community editions.

Yes, the JetBrains Toolbox App is essential, even if you already have a JetBrains IDE. It automatically prepares your IDE for studying by installing the required plugins and updating the IDE if necessary.

Please make sure you have the latest version of the JetBrains Toolbox App. To update, open the app and click Update Toolbox App, or download the latest version here.

If you’re using a Chrome-based browser, please also allow Find devices on local networks in the popup that appears on the course page. When this permission is granted, the page will detect when the Toolbox App opens on your system and you’ll be able to open the course properly.

Yes! It's 100% free and works with both the free and paid versions of JetBrains IDEs.

If you're a student, apply for the Student Pack to get full access to JetBrains IDEs for the duration of your studies. If not, check if you qualify for a free non-commercial license.

The configuration process may vary depending on the IDE you are using for the course. For detailed instructions, please refer to the Troubleshooting guide.
Report BugLeave Feedback
License

Learn to code like a pro with JetBrains Academy

Explore catalog

The course requires the latest installed version of Toolbox application. If you don’t have it, you can download it here.

Privacy & SecurityTerms of UseTrademarksLegalGenuine Tools
© 2000—2026 JetBrains s.r.o. All rights reserved. Developed with drive and IntelliJ IDEA