Databases with SQL and Python

4.688 hours3K learnersCertificate

Explore the world of SQL and its role in retrieving, storing, and processing data, empowering you to make informed decisions and drive impactful insights.

Provided by

JetBrains Academy

See course content3 weeks ago last updated

No credit card required

Our students are building their future at:

Study at your own pace

Fit learning around your schedule. Suitable for all levels.

Learn from the experts

Short, practical text lessons by seasoned developers.

Become job-ready

Integrated with professional tools by JetBrains.

Join the community

Trusted by learners worldwide, confirmed by Trustpilot

What you'll learn

You'll learn the basics of SQL – the Structured Query Language designed for managing data in relational databases. While working on projects, you will figure out how to ensure the interaction between the application and the database.

You will:

get to know the SQL syntax.
dive deeper into Python development.
learn how to work with SQL queries and database cursor methods.
get familiar with the basics of SQLAlchemy.
find out how to manage an SQLite database in Python.
practice loops, lists, and various string methods.
figure out how to get, store, and process data in your apps.

See course content

Learn by doing

# 1

Apply knowledge into practice

You already know the theory. Now it's time to code like you do at work—in a professional IDE, with real project constraints, solving problems that actually matter. Welcome to software engineering as it should be.

# 2

Navigate complexity with surgical precision

Most developers waste months learning random concepts without seeing how they connect. Our interactive Knowledge Map fixes this. It shows exactly how every programming concept relates to others, helping you build a structured mental model of coding.

# 3

Copy the best. Then improve.

Here's what top engineers do that others don't: they study other people's code obsessively. When you get stuck on Hyperskill, you can explore solutions published by other developers. See their exact code. Understand their approach. Learn their tricks.

# 4

Code review that actually makes you better

We stripped code review down to what actually matters: does your solution work? Have you handled the edge cases? Is there a cleaner way to write this? Hyperskill acts like a competent reviewer who actually tests your code. Not genius-level analysis, not architecture debates — just solid feedback on making your code better.

Elevate your engineering mastery through real-world challenges

Master advanced engineering concepts through ambitious projects. Each project deepens your expertise and transforms you from an experienced engineer into an exceptional one.

Calculator for Investors

Create a small program that helps investors make a fundamental analysis based on the company's reports and estimate the company's performance. With this calculator, you can choose the best company in the industry and decide whether to buy its shares or not.

Graduate

Simple Banking System (Python)

Everything goes digital these days, and so does money. Today, most people have credit cards, which saves us time and energy and protects us from unnecessary stress. Cards make our lives easier in so many ways to carry a wallet full of cash to providing consumer protection. In this project, you will develop a simple banking system with a database.

Graduate

Food Blog Backend

Your great-grandmother asked you to copy all the recipes that she had been collecting in her notebook for several decades to “that computer of yours”. You don't like easy solutions, so you decided to build a recipe database. You will need to refresh your SQL knowledge to build a simple backend.

Graduate

Explore all projects

Topics covered by this course

SQL and Databases

70 topics

Working with data

29 topics

Essentials

18 topics

Basics

18 topics

Control flow

16 topics

Python libraries

7 topics

Object-oriented programming

5 topics

Code quality

4 topics

System administration and DevOps

3 topics

Dev tools

2 topics

Additional instruments

1 topic

Algorithms and Data Structures

1 topic

Learn from the industry experts

JetBrains Academy

JetBrains Academy is a part of JetBrains, a global software company specializing in the creation of intelligent, productivity-enhancing tools for software developers and teams. With years of expertise in software development and education, JetBrains Academy empowers more than a million people worldwide to learn and teach computer science, and help organizations inspire their teams to reach their goals in tech. Professional development tools play a big role in computer science education. This is why JetBrains Academy courses offer integration with JetBrains IDEs. This integration assists learners in getting experience with real development processes to streamline their learning curve at future work.

Your peers think Hyperskill rocks

Scout Walker

1 month ago

This course was challenging, especially the SQL parts. I wish there was more learning on some of the earlier SQL to really hone in on the language. The python stuff was great!

EVGENII MORGUNOV

9 months ago

I have learned how to integrate SQL with Python, which is essential for managing and querying data in real-world applications. The course provided a comprehensive understanding of SQL syntax, database management, and the use of SQLAlchemy for ORM. I also gained practical experience in handling SQLit ...

Przemyslaw Gorski

9 months ago

This is a really good thing for the beginners. I started some Python course and then turned out that SQL skill is required, so this track merge them both together (e.g. files or tables).