Articles Cookbook
23 Jul 2024
Alexandre Bruffa

Types of Databases Explained

As an IT student or specialist, you can be sure that databases will be a key element of your professional life. So, you’ll need to understand the many types of databases available – what they do, when to use them, and how they’re different. That’s what we’ll cover in this article. Social media, online banking, e-commerce, AI assistants, and even your mobile phone could not exist without a database! Databases are essential for keeping data accessible and secure in any modern digital product.
Read more
18 Jul 2024
Tihomir Babic

SQL Project for Portfolio: Northwind Store

SQL portfolio projects are an important part of a data analyst’s education. How do you start a project, and where do you go with the insights you discover? We’ll use the Northwind store database to answer this. Doing a solid SQL project is an essential element of any data analyst’s learning process. An SQL project is a great tool for learning, as it makes you use SQL on a real-world dataset.
Read more
16 Jul 2024
Jill Thornhill

PostgreSQL CTE: What It Is and How to Use It

CTEs, or Common Table Expressions, are a powerful PostgreSQL tool that’s often ignored. This article looks at various PostgreSQL CTEs – including nested and recursive CTEs – and what you can do with them. If you write complex queries in SQL, you’ll soon find that your code becomes cluttered and hard to read. CTEs – also known as WITH clauses – are primarily a way of simplifying queries. However, they also allow you to use recursion.
Read more
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

Course of the Month: JOINs in PostgreSQL

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