SQL With Python on JetBrains Academy
Knowledge of SQL (Structured Query Language) is one of the most in-demand skills for anyone working with data. Whether you are interested in data science, software development, marketing, or product management, SQL will help you become more successful at what you do. For example, you can execute SQL queries and retrieve data to segment audiences, find patterns in data, or improve the performance of your database.
This is why we’re introducing SQL With Python, a new JetBrains Academy track that will teach you how to work with databases and build a connection between an application and its stored data. You’ll also learn Python essentials, as these languages are often used together to build database-driven applications.
What you’ll learn
In the SQL With Python track, you will learn how to query data with SQL, perform data analysis with Python, work with popular database management systems, and get familiar with SQLAlchemy, a Python library that offers the full power and flexibility of SQL. In particular, you will:
✅ Learn how to retrieve, store, and process data using SQL operators.
✅ Work with an SQLite database in Python.
✅ Get familiar with SQL queries and database cursor methods.
✅ Practice using loops, lists, and various string methods.
By starting SQL With Python, you’ll join a community of more than 500,000 JetBrains Academy learners. You can discuss what you’ve learned, complete tasks together, share knowledge, and give others a hand by answering their questions.
Projects you’ll build
This track gives you access to more than 180 educational topics and 18 real-world projects that you’ll create step by step. Let’s take a look at a few of them:
🔷 Honest Calculator. Easy, 10 hours.
The Honest Calculator is a new spin on the good old calculator. Not only will it perform all the necessary calculations, but it will also scold you for not performing simple calculations yourself. How’s that for learning motivation? In this project, you will have to work with flowcharts in order to assemble your final app. You will learn to read flow charts to hone your understanding of loops, conditions, and algorithms.
🔷 Read Quality Control. Medium, 15 hours.
In this project, you will learn how to utilize programming for real-world biological tasks. You’ll learn about key parameters of data quality and automating data evaluation with Python. If you love solving problems at the intersection of different fields, then this project is for you.
🔷 Memorization Tool. Challenging, 26 hours.
In this project, you are going to create a tool for memorizing lines, poems, speeches, and other text-based materials, so you don’t have to! You’ll work with the SQLAlchemy ORM and an SQLite database, and practice using loops, lists, and various string methods.
After you finish this track, you’ll receive a certificate of completion that you can add to your LinkedIn profile and resume. Don’t forget to add completed projects to your GitHub profile to strengthen your developer portfolio!
A career to pursue after track graduation
The SQL With Python track gives you a better understanding of what is behind data jobs, and it prepares you for the interview questions you may get as a Junior Data Analyst. Add the SQL Fundamentals track to your studies to strengthen your SQL skills, so you can feel more confident during interviews.
If you don’t want to start a career in the data field, you can use your new SQL and Python skills in other areas such as product management, marketing, research, accounting, or any other fields that work with data.
We hope you’ll enjoy studying with us! If you have any questions or would like to share your feedback, feel free to leave a comment below or contact us at firstname.lastname@example.org.
Your JetBrains Academy team