Articles Cookbook
5 Jul 2023
Jakub Romanowski

Our New Interactive Course – SQL Practice: University

Are you a beginner looking for a hands-on online SQL course to solidify your skills? Or perhaps you're an SQL learner hungry for real-world applications of your new skills? LearnSQL.com, has crafted a robust practice-based learning experience to help you advance at your own pace. Here is SQL Practice: University! In today's data-driven world, mastering SQL is more than just a useful skill—it's a powerful tool that can open doors to many career opportunities.
Read more
4 Jul 2023
Nicole Darnley

How E-Commerce Businesses Can Benefit From SQL

Learn how SQL for e-commerce can empower your online business. When we talk about business in the modern age, the phrase "knowledge is power" takes on a whole new dimension. In the world of e-commerce, the real power lies in the ability to leverage data; one of the key tools in the arsenal of data management and analysis is SQL. SQL, or Structured Query Language, is essential for e-commerce businesses looking to extract valuable insights from their vast reserves of data.
Read more
1 Jul 2023
Jakub Romanowski

Course of the Month: Write Functions in PostgreSQL

Why learn to write user-defined functions? I’ll explain in this article – and how you can learn for free during July 2023 with this LearnSQL.com  PostgreSQL course! PostgreSQL is one of the most popular databases in the world. This is mainly due to its great functionality and the fact that it’s open source (i.e. free!). Postgres is fast, it runs on multiple systems, and it’s suitable for almost any application.
Read more
30 Jun 2023
LearnSQL.com Team

Here Are Our New SQL Flashcards

Preparing for an SQL exam or Data Job interview? Save these SQL Flashcards and always have them to hand, so you don’t forget anything during the most important moments. At LearnSQL.com, we understand that everyone has a unique learning style and pace. That's why we’ve created SQL Flashcards. They can help you during preparation for an exam or to consolidate your SQL knowledge. They are carefully crafted to help you reinforce your understanding of SQL concepts, syntax, and commands, making them an invaluable companion on your SQL learning journey.
Read more
29 Jun 2023
Radu Gheorghiu

How to Use COUNT() with GROUP BY: 5 Practical Examples

Using the COUNT() function with GROUP BY is one of the most common SQL constructs in aggregate queries. Read this article to find out how to use COUNT() with GROUP BY correctly using 5 examples. In this article, we will explain the importance of using COUNT with GROUP BY. We’ll talk about why it is essential in SQL and how it enables data analysis and summarization based on specific criteria.
Read more
27 Jun 2023
Jill Thornhill

How to Learn T-SQL Querying

T-SQL is the dialect of SQL used by Microsoft SQL Server databases. Find out the best way to learn T-SQL querying with interactive online courses. In today's data-driven world, increasing your database knowledge is always a good choice. Microsoft SQL Server is one of the most popular databases nowadays. Knowing T-SQL – the query language of SQL Server databases –is often recommended as a worthwhile skill for careers in IT, business, or research fields.
Read more
22 Jun 2023
Maria Durkin

7 Reasons Why AI Won't Replace SQL Developers

So you've heard all about AI and the famous ChatGPT. And you're wondering if these tools would be beneficial or detrimental to your profession. In this article, we will put your fears to rest and explain how SQL and AI can work together and make developers’ jobs easier. Let's start with an explanation of what Artificial Intelligence (AI) is. AI is an area of computer science concerned with creating machines capable of performing activities that would normally need human intelligence.
Read more
20 Jun 2023
Tihomir Babic

What Is a LEFT OUTER JOIN in SQL? 4 Practical Examples

Today’s article will discuss the LEFT OUTER JOIN in SQL. We’ll go through several examples of typical LEFT OUTER JOIN usage and compare it with INNER JOIN. A JOIN is an SQL feature that allows you to combine data from two or more tables. The nature of relational databases makes JOIN one of the most commonly used features in SQL. There are many different types of JOINs. We’ll focus on LEFT OUTER JOIN here.
Read more
15 Jun 2023
Dominika Florczykowska

An Overview of MySQL Window Functions

MySQL window functions are very helpful when you want to create meaningful reports with SQL. In this article, we’ll demonstrate the most common window functions in MySQL and explain how to use them. MySQL 8.0 introduced a new feature: window functions. These functions are very useful to data analysts and anyone who creates reports using MySQL. Using them, you can easily compute moving averages, cumulative sums, and other calculations over specified subsets of your data.
Read more
13 Jun 2023
Maria Durkin

Who Is a Data Manager?

Who are data managers? What are their responsibilities, and how do I become one? We’ll answer these questions and get you on your way to becoming a data manager! Simply put, data managers oversee the management of information or data within an organization. They manage data organization, storage, security, and accessibility, and they collaborate with other team members to guarantee data accuracy and usefulness in supporting decision-making. To ensure that data is effectively managed and used appropriately, they may also develop and implement policies and procedures pertaining to data management.
Read more