Articles Cookbook
15 Jul 2024
Jakub Romanowski

LearnSQL.com SQL Training For Your Business

Keeping your team’s skills sharp is essential. Investing in their development, particularly in SQL training, can bring significant benefits to your company, making it more efficient and competitive. In this article, I'll show you why implementing LearnSQL.com SQL training in your company is a smart move. As a manager, you know it's important to help your team grow. Updating team members’ skills regularly not only makes them more effective but also shows you the value of their contribution.
Read more
11 Jul 2024
Martyna Sławińska

20 SQL WHERE Practice Exercises for Beginners

In SQL, the WHERE clause filters data based on defined conditions. Read on to follow 20 WHERE practice exercises with beginner-friendly explanations and solutions. This article will review some of our SQL WHERE exercises. We’ll start by explaining the basic syntax, then we’ll examine 20 beginner-friendly exercises that come from the SQL courses listed below. These exercises cover the main uses of the WHERE clause and are perfect for practicing your SQL skills.
Read more
9 Jul 2024
Maria Durkin

SQL vs. MySQL: What’s the Difference?

Are SQL and MySQL the same thing? In this beginner-friendly guide, we'll explain the ddifferences of SQL and MySQL – and how they fit into the larger picture of relational database management systems. When you’re getting started with databases, it’s easy to feel overwhelmed by the terminology. SQL, MySQL, other acronyms… It can be a lot. And sometimes – like SQL and MySQL – the terminology can seem more similar than different.
Read more
4 Jul 2024
Jakub Romanowski

New Course! Have Fun With Self-Guided Practice Databases

If you're looking for a place to experiment with your SQL queries and see them in action, our new "SQL Databases for Practice" course is the perfect spot. Dive in and play around with real data, right where the action happens! We're thrilled to launch a brand-new resource on LearnSQL.com, called SQL Databases for Practice. This course is all about giving you the freedom to sharpen your SQL skills on your terms, using real databases from various industries like education, e-commerce, and more.
Read more
1 Jul 2024
Jakub Romanowski

Free Course of the Month – PostgreSQL JOINs

Our PostgreSQL JOINs course will help you consolidate your knowledge of working with data from two or more tables in a PostgreSQL database. Throughout the month of July 2024, this awesome SQL course is absolutely FREE! Wondering why we want to give you this SQL course for free? We've been doing this for a long time. Every month, we choose one of our interactive online SQL courses and give users free access to it.
Read more
30 Jun 2024
Lisandro Fernigrini

22 Exercises to Practice SQL Commands

Want to improve your SQL knowledge? Practice SQL commands in these 22 realistic exercises! There's an old saying that "there's no substitute for experience". But how can you achieve that experience when you’re just starting to learn something new? The best way is by practice, practice, and more practice! In this article, we’ll provide you with some real-world SQL command practice. All of our practice exercises are taken from courses on LearnSQL.
Read more
28 Jun 2024
LearnSQL.com Team

New Monthly SQL Practice for July 2024!

Ready for our new SQL challenge? This time, the tasks are slightly more difficult. In this course, you will assist Chinook’s management in analyzing company performance using SQL JOINs. Welcome to the July SQL Practice course! In our July 2024 SQL Practice, you will work with the Chinook database. Chinook is a digital music store. Its management has hired you, an SQL specialist, to gain important insights into the business.
Read more
27 Jun 2024
Martyna Sławińska

PostgreSQL Date Functions

Understanding date and time functions in your database is essential for effective data analysis and reporting. Read on to learn more about PostgreSQL date functions. This article covers some of the most useful PostgreSQL date and time functions and their applications in data analysis and reporting. SQL date functions facilitate different data analysis tasks, including sales analysis, financial reporting, website analytics, and more. This article presents you with the tools, in the form of PostgreSQL date and time functions, used to accomplish these tasks.
Read more
27 Jun 2024
LearnSQL.com Team

54 Years of Relational Databases

If it weren't for him, there would be no modern databases. It is the 54st anniversary of the publication of his article that changed the rules of the game. Edgar Frank Codd is one of the fathers of SQL, and his name is one of the first to be mentioned in the history of databases. Or maybe even the history of computer development in general? See what we owe to Dr.
Read more
25 Jun 2024
Ignacio L. Bisso

The SQL EXISTS Operator

Using the SQL EXISTS clause allows us to create complex queries in a simple way. Learn the pros and cons of the EXISTS operator in this article. In SQL, the EXISTS operator helps us create logical conditions in our queries. Essentially, it checks if there are any rows in a subquery. We’ll show you EXISTS syntax, provide some usage examples, and then give you several exercises to practice on.
Read more