Articles Cookbook
25 Aug 2022
Lisandro Fernigrini

What's New in MS SQL Server 2022

Microsoft SQL Server 2022 is almost here! In this article, we’ll review what new enhancements and features will be coming to this popular relational database. The new version of MS SQL Server will become available almost three years after SQL Server 2019 was released. (You can learn more about the origins and different versions of SQL Server in A Brief History of MS SQL Server.) If you need to start implementing a software solution, there are plenty of changes and new features in SQL Server 2022 that makes it a great option.
Read more
23 Aug 2022
Kamila Ostrowska

How to Learn SQL

It takes quite an effort to learn SQL or any new skill for that matter. But pushing hard is not enough to learn it successfully. You can sit for hours and still feel like you're not making progress. So, what do you do? Let it go or try even harder? I say: work smart, not hard. SQL (Structured Query Language) is one of the most popular programming languages. It is an invaluable tool in a world overflowing with data.
Read more
19 Aug 2022
Jakub Romanowski

Track of the Season: Creating Database Structure

Summer is a great time to learn something new! Have you heard about data engineering? It’s one of today’s hottest skills. In this article, I'll show you why we selected our Creating Database Structures track as our SQL Track of the Season – and why it’s your ticket to a new career! LearnSQL.com offers online SQL training tracks – logically structured and well-thought-out learning paths that will help you work towards becoming an SQL expert.
Read more
18 Aug 2022
Tihomir Babic

An Overview of SQL Text Functions in Google BigQuery

Data analysts and Google BigQuery go hand in hand. Google's cloud data warehouse presents you with plenty of opportunities for using standard SQL text functions you can't avoid in your day-to-day work as a data analyst. BigQuery uses Google Standard SQL, an ANSI-compliant SQL dialect. This means you can use standard SQL text functions in BigQuery without needing to learn a variant of a given function. The Standard SQL Functions course is an excellent resource for learning those functions.
Read more
16 Aug 2022
Alexandre Bruffa

PostgreSQL vs. MySQL: Is It Difficult to Switch?

So you know PostgreSQL, but the boss has decided to switch to MySQL. What are the differences between these two SQL dialects? We discuss PostgreSQL vs. MySQL in this article. PostgreSQL has gained popularity in the last decade, and many developers and database specialists learned PostgreSQL as their first SQL dialect. But PostgreSQL is not the only relational database; during your IT career, you will probably be asked to use another SQL dialect – like MySQL.
Read more
11 Aug 2022
Tihomir Babic

How to Use Aggregate Functions in WHERE Clause

Filtering data according to the result of an aggregate function is a common data analysis task. So how do you use aggregates in the  WHERE clause? We’ll dedicate this whole article to answering that question.   Combining aggregate functions and filtering based on their results is often used in data analysis – e.g. showing branches with total sales above X,  countries where the number of posts is lower than Y, students with an average score below Z, and so on.
Read more
9 Aug 2022
Dmitri Vaitkun

What Is an SQL Query?

An SQL query is the most basic SQL command. It is a question you ask a database. In this article, we dive into the basics of SQL queries to kickstart your SQL journey with practical knowledge right away! What is SQL SQL, or Structured Query Language, is a programming language designed to interact with databases. When you want to access data in a database, be it to alter, delete, add, or simply extract information, you use SQL.
Read more
4 Aug 2022
Jakub Romanowski

Lesser-Known SQL YouTube Channels You Need to Follow Now!

Are you learning SQL? Many beginners start with YouTube tutorials. However, popular SQL clips are not always very helpful. You need to know which ones to watch so that you don't waste your time. In this article, I discuss SQL YouTube channels that, while not the most popular, deserve your attention. Click "subscribe" and watch! Those who follow my articles on LearnSQL.com know I'm not a huge fan of learning SQL from YouTube.
Read more
28 Jul 2022
Kateryna Koidan

How to Set Up a Corporate SQL Training Program

Are you looking to set up a business or corporate SQL training for your company's employees? In this article, we’ll discuss how to build an efficient SQL training program and why the LearnSQL.com platform is the choice of leading tech companies. If you are responsible for employees’ professional development – especially in a data-driven company – you know that SQL is essential for anyone who works with data. This programming language can enhance the performance of data and business analysts (for whom SQL is often a primary tool) as well as marketers, salespeople, HR specialists, auditors, and many more.
Read more
26 Jul 2022
András Novoszáth

How to Get More from Your BI Tools with SQL

Are you frustrated with the limitations of your business analytics tool? Do you wonder if there are other features you could tap into? Would you like to know how SQL compliments your work with Power BI and Tableau? Read this article to learn more! If you are a data analyst or if data analysis is part of your everyday job, Business Intelligence (BI) tools are crucial for your work. You also know that most databases run SQL queries in the background of such tools.
Read more