Articles Cookbook
1 Aug 2024
Jakub Romanowski

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 August 2024, you can complete this online PostgreSQL course for FREE! How can you get this free SQL course in August 2024? Create a free LearnSQL.com account or log in if you already have one. Start the course.
Read more
31 Jul 2024
LearnSQL.com Team

New Monthly SQL Practice for August 2024!

Ready for a new basic SQL challenge? This time, you will work with Alice, a yacht rental manager. She needs help with organizing and analyzing her rental data. Get ready to dive into the world of SQL queries as you help her enhance the yacht rental experience for all her customers. Welcome to the August SQL Practice course! In the August 2024 SQL Practice, you will meet Alice, the manager of a yacht rental business.
Read more
30 Jul 2024
Jakub Romanowski

Why Your Team Needs SQL Training

Training your team in SQL will bring many benefits from increased efficiency to better decision making. In this post, we’ll look at why investing in SQL training for your team is a good idea and how it will change your business. Your team can handle data tasks without always needing IT support. With SQL skills they can run their own queries and create reports, speed up processes and make everyone’s life easier.
Read more
26 Jul 2024
Jakub Romanowski

2024 Database Trends: Is SQL Still the King?

Want to know what database is most popular in 2024? In this article, I go through the 2024 Stack Overflow Developer Survey results. You’ll see why SQL is still top, PostgreSQL is on the rise and more developers are interested in SQLite. We’ll also talk about the benefits of learning SQL online, recommend resources, and how developers code outside of work for fun and professional growth. The annual Stack Overflow Developer Survey offers invaluable insights into the developer community, shedding light on trends, preferences, and emerging technologies.
Read more
25 Jul 2024
Kamila Ostrowska

What Is CRUD?

What is CRUD? In this article, we’ll explore the meaning of this acronym and its significance in the world of SQL and data analysis. CRUD is an acronym that stands for Create, Read, Update, and Delete. These are the four basic operations that can be performed on data stored in a database or other data storage systems. CRUD operations are fundamental to data management and are commonly implemented in database management systems (DBMSs), web applications, and Application Programming Interfaces (APIs).
Read more
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