Articles Cookbook
24 Nov 2022
Kamila Ostrowska

The Most Popular Databases in 2023

Have you heard about databases but you’re not sure which database to work with? In this article, you’ll find a list of today’s most popular databases and a quick summary of what each one does. Businesses run on data. But to get the most from that data, it needs to be stored in a structured way – usually in a database. If there’s a lot of data or if you need to do more than just basic analysis, Excel or any other spreadsheet might not be enough.
Read more
22 Nov 2022
Martyna Sławińska

How to Export Data from MySQL into a CSV File

A database is a primary platform for working with data and storing data. But often, you must take your data out of the database. Read on to find out how to export data from MySQL database into a CSV file. In this article, we’ll demonstrate how to export data into a CSV file. We’ll start by introducing what a CSV file is and why we use it. Then, we’ll export data from a MySQL database into a CSV file.
Read more
21 Nov 2022
LearnSQL.com Team

Black Week 2022 - Free SQL Training For Companies

Are you looking for the best SQL training for your employees? Now, with our Black Week special offer, they can learn for FREE at LearnSQL.com. Read on to find out more. Black Week 2022 is upon us, and we’re excited to bring some great offers to the table once again. This year, we’re particularly keen to involve our business users in the event, so we’ve put together a tailored proposal just for them.
Read more
21 Nov 2022
LearnSQL.com Team

Black Week 2022 - Free SQL Training For Educational Institutions

Are you looking for the best SQL training for your students? Now, with our Black Week special offer, they can learn for FREE with LearnSQL.com. Read on to find out more. With the arrival of Black Week 2022, we’re taking a fresh look at how we can further support the educational institutions that use our SQL training solution. We want to expand our existing program with an exclusive offer for education which, we hope, will go some way to showing our appreciation for the entire sector.
Read more
18 Nov 2022
Alexandre Bruffa

I’m a Software Developer. How Do I Learn SQL?

What do you need to know about relational databases and SQL as a software developer? In this article, we’ll explain the topics you need to know and how you can acquire this knowledge. If you are a software developer, you may have noticed that SQL skills are often required in some development roles. Although you are not a database manager or a data scientist, you will need solid SQL foundations to continue your developer journey.
Read more
17 Nov 2022
Luke Hande

What Is an SQL Database?

SQL databases have been used for decades and have grown in popularity, becoming one of the most common data management tools. They provide the user with an efficient way to store the data and an intuitive way to access or modify it. In this article, we’ll start by explaining what a database is and showing some examples. We’ll move on to how databases can be used to efficiently work with large amounts of structured data.
Read more
15 Nov 2022
Himanshu Kathuria

Top 6 Online SQL Courses for Beginners in 2023

Whether you’re dreaming of a career in data analytics or just want to develop yourself, learning SQL is worthwhile. But don’t waste your time on poorly-designed courses or other learning resources! In this article, I’ve collected the best online SQL courses for beginners. Pick one and start being awesome! SQL (Structured Query Language) has emerged as one of the top skills that recruiters look for when it comes to data related jobs.
Read more
10 Nov 2022
Tihomir Babic

How to Use GROUP BY in SQL

In this article, we’ll give you a step-by-step guide on using GROUP BY in SQL. Uncover the nuances of the GROUP BY clause and learn different ways of using it. GROUP BY is one of the most-used clauses in SQL. It moves you from simply selecting data from the database to grouping rows with the same column values into one group. When used with SQL’s aggregate functions, you can use GROUP BY to compute metrics like counting the number of instances or finding the total, average, minimum, or maximum value.
Read more
8 Nov 2022
Tihomir Babic

How to Use the PARTITION BY Clause in SQL

We’ll be dealing with the window functions today. Specifically, we’ll focus on the PARTITION BY clause and explain what it does. PARTITION BY is one of the clauses used in window functions. In SQL, window functions are used for organizing data into groups and calculating statistics for them. It sounds awfully familiar, doesn’t it? Even though they sound similar, window functions and GROUP BY are not the same; window functions are more like GROUP BY on steroids.
Read more
3 Nov 2022
Jakub Romanowski

SQL Track of the Season: SQL from A to Z in MS SQL Server

Maybe your company uses MS SQL Server and you’d like to join the data analysis team. Or maybe you want to add a new skill to your CV. Either way, our SQL Track of the Season: SQL from A to Z in MS SQL Server, will help. In this article, I’ll answer common questions about this awesome set of online MS SQL Server courses. If you’re reading this blog post, you probably already know that you should start learning SQL and working with databases.
Read more