Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
Other Assets
Flashcards
SQL Primer
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
Flashcards
SQL Primer
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
16 May 2023
Dmitri Vaitkun
The Most Important SQL Commands
In this article, we'll explore the most common SQL commands that everyone should know, including SELECT, INSERT, WHERE and more. We’ll also give examples of how to use each command. Are you ready to dive into the world of databases? SQL, or Structured Query Language, is a programming language that is designed specifically to interact with databases. It allows you to manipulate the data in databases in multiple ways – e.
Read more
11 May 2023
Jill Thornhill
Why Is Data a Valuable Resource for Your Business?
How do you build an effective data resource and make it work for you? In this article, I'll look at why data is so important to any organization and how to make the most of your data resources. Bad decisions are almost always based on incorrect or incomplete facts. Good decisions keep your organization competitive. In a nutshell, that’s why data is such an important business resource. Ever since the dawn of civilization, our ancestors have known the value of information.
Read more
9 May 2023
Maria Durkin
Why SQL Is the Perfect Database Language
Which programming language should you learn if you want to work with databases? We’ll explain why SQL is the top choice! Learning a database language can be an incredibly valuable skill in today's data-driven world. But with so many options out there, it can be difficult to know where to start. In this article, we'll make a compelling case for why SQL is the ideal choice for anyone looking to dive into the world of databases.
Read more
4 May 2023
Dominika Florczykowska
How to Write Multiple Joins in One SQL Query
Have you ever wondered how multiple joins work? Want to know how to join multiple tables in one query? Read this article to find out! If you are just beginning your SQL journey, you may have found it difficult to understand the concept of SQL JOINs, especially if you have to join more than two tables in one query. Worry not! In this article, we will explore how JOIN works and solve all its mysteries!
Read more
4 May 2023
LearnSQL.com Team
Star Wars Days 2023
May 4th is here! And that means one thing: World Star Wars Day. We're fans of the Skywalker saga and we're proud of it! That’s why we’ve decided to celebrate the anniversary of the premiere of the best film franchise in the history of cinema! Hello young Padawan. You have come to the planet Coruscant to study at the Jedi Temple. You want to become a Jedi master to tame the databases and defeat the Sith in a data battle.
Read more
2 May 2023
Nicole Darnley
Top 7 Advanced SQL Queries for Data Analysis
Explore essential advanced SQL queries for data analysis. Structured Query Language, or SQL, is an indispensable tool for data analysts. Most people pick up the language relatively quickly and can begin in-depth data analysis after just a few lessons. Because of this, many data analysts tend to stay in the beginner/intermediate level of using SQL. This level of understanding allows you to “get the job done”, but it might not be the most efficient way to write a query.
Read more
1 May 2023
Jakub Romanowski
Free Course of the Month – GROUP BY Extensions in PostgreSQL
Do you work with data? Want to be able to create better and more sophisticated SQL reports? Then check out our interactive GROUP BY Extensions in PostgreSQL course. In May 2023, you can complete this online PostgreSQL course for FREE! How can you get this free SQL course in May 2023? Create a free LearnSQL.com account or log in if you already have one. Start the course.
Read more
30 Apr 2023
LearnSQL.com Team
New Monthly SQL Practice for May 2023!
Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s the May 2023 SQL Practice course! You’ll be helping Sophie, who is running an online document editing app. She would like to gather some data that will help her to expand the business. She hired you as an SQL specialist to help her out. Can you find the average number of documents created by each user?
Read more
28 Apr 2023
Jakub Romanowski
MySQL Crash Course - An Interview With Rick Silva
If you've read my articles before, you probably already know that I love reading. What's more, I also collect SQL books. It may sound weird, but I enjoy comparing different approaches and ways of writing about databases. The best ones end up in our recommended books lists, like The Best SQL Books for 2023. One of those books, MySQL Crash Course, has just been released. I was able to talk to its author, Rick Silva, and this is what he told me.
Read more
27 Apr 2023
Tihomir Babic
How to Use the SQL RANK OVER (PARTITION BY)
Ranking data in SQL is a breeze if you know how to use RANK() to rank over a partition. This article shows you how to do it, as well as how RANK() differs from DENSE_RANK() and ROW_NUMBER(). If you work with SQL in a professional setting, you have had to rank data at least once. Think of ranking months/years/quarters by revenue or costs, best-selling products, most viewed posts or streamed songs, employees by salary, most profitable branches, you name it.
Read more
««
«
1
2
3
6
7
8
78
»
»»