Articles Cookbook
30 Apr 2020
Kateryna Koidan

Is SQL a Programming Language?

SQL is a language for communicating with databases. When you write SQL queries, you give instructions to the computer and it performs these instructions—it sounds like programming. However, you cannot build an application with SQL as you can with Python or Java. So, is SQL a programming language? SQL is used to communicate with databases. It allows you to find information, update or delete data, or create and modify the structure of a database.
Read more
29 Apr 2020
LearnSQL.com Team

Course of the Month: Window Functions

Spring has come. It is nicer outside. It's a great time to learn something new. Which course should you choose? In April, it's worth it to bet on SQL window functions. What are they, what are they used for, and why are they worth knowing? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, these questions. She has a PhD in mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw.
Read more
29 Apr 2020
LearnSQL.com Team

SQL Window Functions Cheat Sheet

Unlock the full potential of SQL with our comprehensive Window Functions Cheat Sheet! This indispensable guide is designed to elevate your analytics capabilities and make complex data manipulations effortlessly accessible. Welcome to the ultimate resource for mastering SQL window functions - the SQL Window Functions Cheat Sheet! This invaluable resource provides you with the essential syntax, a comprehensive list of window functions, and real-life examples to enhance your SQL skills and analytics capabilities.
Read more
28 Apr 2020
Dorota Wdzięczna

What Is a Running Total and How Do You Compute It in SQL?

The SQL running total is a very common pattern, used frequently in finance and in trend analysis. In this article, you’ll learn what a running total is and how to write a SQL query to compute it. The best way to learn SQL is through practice. LearnSQL.com offers over 70 interactive SQL courses at various level of difficulty. Each course is interactive: there is a little bit of reading, followed by an exercise to practice what you've just read.
Read more
23 Apr 2020
Arleta Więch

Top 3 Platforms to Learn SQL Online: A Complete Comparison

Do you want to learn SQL online? Where do you start? There are many choices on the internet, and it can be hard to decide. But don’t worry—I tested and compared three major platforms to help you find the best place to learn SQL online! E-learning is still on the rise. It gives us infinite possibilities of growing our professional careers without leaving our homes. And increasing our competencies is especially important now that the labor market has become dynamic and unstable.
Read more
22 Apr 2020
Tihomir Babic

When Do I Use SQL Window Functions?

Have you heard one of your colleagues bragging about using SQL window functions? Do you know basic SQL but not much, or anything, about window functions? If you want to learn about window functions and how to use them in a business context, you’re in the right place! This happens often. You reach a certain level of knowledge, and you feel like the king (or queen) of the world.
Read more
21 Apr 2020
Kamil Bladoszewski

How to Join 3 Tables (or More) in SQL

Using JOIN in SQL doesn’t mean you can only join two tables. You can join 3, 4, or even more! The possibilities are limitless. The best way to practice SQL JOINs is LearnSQL.com's interactive SQL JOINs course. It contains over 90 hands-on exercises that let you refresh your SQL JOINs knowledge. It covers a wide range of topics from simple 2-table JOINs, through joining multiple tables and using OUTER JOINs, to joining a table with itself.
Read more
17 Apr 2020
Agnieszka Kozubek-Krycuń

Why Take the “SQL Basics” Course at LearnSQL.com

LearnSQL.com’s interactive SQL Basics course teaches the foundations of SQL. Discover why we built this online course, our philosophy behind it, and what it contains! Learning SQL can feel like unlocking a new skill set you didn’t even know you needed. At first, it might seem like just another technical tool, but as you start using it, you'll notice how much smoother your workflow becomes. Suddenly, tasks like pulling data from multiple sources or answering complex questions about trends won’t feel as overwhelming.
Read more
16 Apr 2020
Emil Drkušić

Differences Between GROUP BY and PARTITION BY

Window functions are a great addition to SQL, and they can make your life much easier if you know how to use them properly. Today, we will address the differences between a GROUP BY and a PARTITION BY. We’ll start with the very basics and slowly get you to a point where you can keep researching on your own. PARTITION BY vs. GROUP BY The PARTITION BY and the GROUP BY clauses are used frequently in SQL when you need to create a complex report.
Read more
10 Apr 2020
Marija Ilic

Analyze Time Series COVID-19 Data with Window Functions

The COVID-19 pandemic really changed the way we live. No matter where you are, you're being impacted by this unpredictable virus. We do not know what the future holds, but we do believe in science and in better days to come. One thing that makes me as a data analyst particularly happy is that we have publicly available data. We can analyze that data and learn something from it. If you want to explore COVID-19 with the help of modern SQL constructions, keep reading — this article is intended for you.
Read more