Articles Cookbook
16 Oct 2020
Adrian Więch

Google Analytics and SQL

Google Analytics is a very popular tool among website and blog owners alike. With a simple and quick setup, it lets you gather data about your web page visitors easily. However, did you know that you can export data from Google Analytics to create your own SQL reports? Read this article to find out how. Google Analytics is an extremely popular and powerful solution that lets you collect and analyze various kinds of information about your website.
Read more
15 Oct 2020
Rebecca McKeown

How to Boost Your Company With SQL Courses

SQL has the power to supercharge the capabilities and performance of your entire company. But if you don’t dip your toes in the water and give some SQL courses a go, you’ll never realize the vast potential of the language. SQL, or Structured Query Language, is your ticket to expanding the scope and the results of your business or organization, no matter what sector you operate in. Whether you’re the owner or manager of your company or simply an employee interested in improving operations, learning SQL is undoubtedly, unquestionably, for you.
Read more
14 Oct 2020
Zahin Rahman

SQL HAVING Tutorial

Learn how to use the SQL HAVING clause to filter groups using your own specified conditions. The SQL HAVING clause is often a challenging concept to grasp, especially for beginners. Additionally, its specific use cases can be difficult to visualize without specific examples based on real-world datasets. In this tutorial, you will learn how to apply the SQL HAVING clause to filter groups of records based on specified conditions. You’ll see examples where we apply this concept to solving business problems on a realistic dataset.
Read more
13 Oct 2020
Martyna Sławińska

What Is a Self Join in SQL? An Explanation With Seven Examples

The self join is a popular special case of the SQL JOIN. While most JOINs link two or more tables with each other to present their data together, a self join links a table to itself. This is usually done by joining a table to itself just once within a SQL query, but it is possible to do so multiple times within the same query. Typically, each table in a database stores a specific type of information.
Read more
9 Oct 2020
Marija Ilic

How to Join the Same Table Twice

JOIN is one of the most common statements in SQL. As you may know, it is used to join and combine data from two or more tables into one common data set. In this article, I’m going to discuss special types of joins? in which you combine the same table twice—including joining a table to itself, also known as the self join. When and why do you need to do this?
Read more
8 Oct 2020
Marcin Koryszewski

5 Best Online SQL Courses for Business Analysts

Why bother to learn via an online SQL course? SQL is pure profit – it allows analysts to interpret data efficiently and companies to adopt better strategies. In this post, we’ll look at our top 5 SQL courses for business analysts. Being into finance, economics, and IT systems has brought you to business analysis. It’s a fascinating combination of skills; you’re combining business and technology, which makes you a valuable asset to your company.
Read more
7 Oct 2020
Marija Ilic

How to Create Your First Table in SQL

Creating a database table with SQL is one of the core skills you’ll need to work with data. And it’s easy to learn, so let’s get started! Imagine you’re analyzing data and want to store your results in a database table. Sure, you've done this a million times in Excel. But you’re not sure how to create a table with SQL. Or maybe you’ve noticed that data engineering is in high demand and you want to start learning its core concepts.
Read more
6 Oct 2020
Agnieszka Kozubek-Krycuń

Five Essential Features of a Good SQL Course: What to Look for When Choosing a Course for You

There are many different platforms offering SQL courses. If you’re a beginner, it may be difficult to choose the right one for you. Find out what we think are the essential features of a good SQL course. Remember, if you make a poor choice at the beginning, you may get discouraged or get into bad habits that will impact your work down the line. What Is SQL? SQL, or Structured Query Language, is a programming language you use to talk to databases.
Read more
2 Oct 2020
Martyna Sławińska

A Comprehensive Introduction to Window Functions in MySQL

Do a deep dive into the working principles, syntax, and applications of various MySQL window functions. There are many open source databases you could choose; MySQL is consistently one of the most popular. But until 2018, there was no provision for including window functions in MySQL. Fortunately, all that has changed – starting from MySQL 8.0, SQL window functions were now available to MySQL users. Please note that window functions are available only in MySQL 8.
Read more
1 Oct 2020
LearnSQL.com Team

New Monthly SQL Challenge for October 2020!

The new Monthly Challenge on LearnSQL.com is ready! In October, we invite you to try your SQL skills by learning about job positions and recruitment agencies. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers a new SQL challenge every month. Each challenge contains 5 to 10 SQL exercises designed for people who want to practice their SQL skills. It takes less than an hour to solve these tasks.
Read more