Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
Guides
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
Log in
Create free account
fullName
User profile menu open
Open user profile menu
fullName
Dashboard
My Profile
Payment & Billing
Log out
MENU
CLOSE
Courses
Pricing
For Students
Articles
Cookbook
Cheat Sheets
Best Way to Learn SQL
SQL Primer
Flashcards
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
24 Apr 2020
Kate Stolarek
Is SQL Worth Learning?
We’re in the 21st century. These are the “ultimate data times” in which loads of information on all kinds of things is available. We want to explore this info even more, slice and dice it, understand where it comes from and what triggers it. With such large amounts of data coming in, people have discovered that spreadsheets aren’t enough. There’s a need for a greater solution, something like a spreadsheet on steroids.
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 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
22 Apr 2020
LearnSQL.com Team
New SQL Monthly Challenge for April 2020!
The new Monthly Challenge on LearnSQL.com is ready! In April, we invite you to test your SQL knowledge with data from another area of business: automobile repair. What is an SQL Challenge? It is a set of 5 to 10 SQL exercises, prepared for people who want to sharpen their SQL skills. Each challenge is centered around a specific theme. Do you like pizza? One of the challenges focuses on this miracle of Italian cuisine.
Read more
21 Apr 2020
Kamil Bladoszewski
How to Join 3 Tables (or More) in SQL
Updated on: April 19, 2024 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! What Is SQL, and Why Should You Learn It? SQL is a language used to talk to databases, computer programs that hold data and can process it efficiently. SQL can select data from a database and perform various computations on the data, be they simple or complex.
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
Zahin Rahman
What is the Best SQL Training Online?
Updated on: April 16, 2024 Mastering SQL training is crucial, but let's face it—you won’t become an expert in just a couple of weeks. With countless resources available, it can be quite a challenge to even know where to begin your SQL journey. How do you effectively practice and hone these essential skills? Savvy and knowledgeable database professionals have consistently been in high demand over the last five years. If you are aiming to advance your career as a database developer, administrator, warehousing specialist, or analyst, SQL training and mastery is an absolute necessity.
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
9 Apr 2020
Jakub Romanowski
The Man Behind LearnSQL.com
If it wasn't for this guy, LearnSQL.com would never have been created. He manages the entire company, makes strategic decisions – and talks little about himself. Who is the man behind LearnSQL.com? Meet Vertabelo CEO Jarosław Błąd. SELECT interests, early_career, advice FROM Jarek AS the_man_behind_learnsql.com WHERE answer IS NOT Null AND success IS True; If you were to write one sentence about yourself, what would it be? I think I would say that I am an ordinary, simple guy who really likes what he does.
Read more
««
«
1
2
3
62
63
64
79
»
»»