Articles Cookbook
13 Dec 2022
Tihomir Babic

5 Practical Examples of SQL’s WITH Clause

These five practical use cases will make you want to use the SQL WITH clause daily. The WITH clause can help you write readable SQL queries  and break complex calculations into logical steps. It was added to SQL to simplify complicated long queries. In this article, we’ll show you 5 practical examples of the WITH clause and explain how using it makes SQL queries more readable. The WITH clause is also called a Common Table Expression (CTE).
Read more
8 Dec 2022
Martyna Sławińska

How to Export Data From Microsoft SQL Server to a CSV File

When working with data and databases, it is common to export data for further processing or transport to another database. Follow this article to learn how to export data from Microsoft SQL Server to a CSV file. In this article, we first recall what a CSV file is and why you would want to export data in this format from an MS SQL Server database. Then, we cut to the chase and export data to a CSV file using both SQL Server Management Studio (SSMS) and SQL Command Line (SQLCMD).
Read more
6 Dec 2022
Jill Thornhill

The Future of SQL

Is it worthwhile to learn SQL? Or will a language that’s over 40 years old soon be outdated? Have relational databases been eclipsed by the advent of other database solutions like NoSQL? In this article, we answer these questions. Do you need to upgrade your IT skills? What should you learn first? The choice is daunting. If you're looking to the future, you obviously want to invest your time in something that's still widely used and will continue to be in the years to come.
Read more
1 Dec 2022
Jakub Romanowski

Free Course of the Month – Common Functions in PostgreSQL

Do you want to be able to use popular PostgreSQL functions and process different types of data more easily? You've come to the right place! Here is the Common Functions in PostgreSQL course. Throughout the month of December 2022, this SQL course is absolutely FREE! You are probably wondering why LearnSQL.com is offering a free SQL course. Well, we've been doing this for a long time. We choose one of our courses every month and give users free access to it.
Read more
1 Dec 2022
LearnSQL.com Team

New Monthly SQL Practice for December 2022!

In our December 2022 SQL Practice, you will meet Lucas. He is a young entrepreneur and video game enthusiast. Lucas needs your help in creating queries and analyzing data for his gaming social hub, a place for people to buy and discuss games. Can you use your SQL skills to help him? It shouldn’t be too hard if you have finished our SQL Basics course and/or understand core SQL concepts.
Read more
29 Nov 2022
Ignacio L. Bisso

What Data Type to Choose for a Column When Creating a Table in SQL

Databases store data values of various kinds. For example, you may store the name of a product as a text string, the price of a product as a number, or the date a product is sold as a date value. These values – the product name, the price, and the sale date – are stored as different data types. In this article, we explain several SQL data types with real examples.
Read more
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