Articles Cookbook
14 Jul 2021
Jakub Romanowski

Track of the Season: SQL Reporting in MS SQL Server

It's the best time of the year for a change! Learn something new and boost your career! This is our SQL Track of the Season: SQL Reporting in MS SQL Server! In this article, we’ll answer common questions about this track. Summer is here. Does the sun make you want to learn something new? Maybe surfing or Portuguese? Maybe you've wanted to learn crocheting all your life? Follow your dreams!
Read more
13 Jul 2021
Andrew Bone

What Is the SQL GROUPING SETS Clause, and How Do You Use it?

GROUPING SETS are groups, or sets, of columns by which rows can be grouped together. Instead of writing multiple queries and combining the results with a UNION, you can simply use GROUPING SETS. GROUPING SETS in SQL can be considered an extension of the GROUP BY clause. It allows you to define multiple grouping sets in the same query. Let’s look at its syntax and how it can be equivalent to a GROUP BY with multiple UNION ALL clauses.
Read more
12 Jul 2021
LearnSQL.com Team

LearnSQL.com For Your Business

Are you thinking about SQL training for your employees? See how much you have to gain by choosing LearnSQL.com and how we can help you grow your business. .pre-header { color: #006DFF; text-transform: uppercase; letter-spacing: 2px; font-size: 14px; font-weight: 400; line-height: 16px; margin-top: 60px; } We live in a time when the ability to process data is crucial. Data is a key resource, the use of which can give you an edge in the market.
Read more
9 Jul 2021
Kamila Ostrowska

Best SQL Certifications for Leveling up Your Career

If you want to build and strengthen your position in the IT industry, you should look into these SQL certifications. We always encourage you to learn, to gather new skills and experience. Training is really important; without it, you will not make much progress if you want to advance in IT or specifically in the SQL industry. That said, you also need something that can validate your competencies, like SQL certifications.
Read more
8 Jul 2021
Andrew Bone

What Is the INSERT Statement in SQL?

The INSERT statement in SQL is used to add new data to your database. This article will explain how to use it and show you practical examples along the way. When you learn SQL, you focus on getting data out of a database, working mostly with SELECT. In SQL, there are also statements that let you modify data in a database. The first one is the INSERT statement: it adds data to a table.
Read more
7 Jul 2021
Martyna Sławińska

Primary Key vs. Unique Key: Explaining the Differences

When designing a database, we often need to decide between defining a primary key vs. a unique key. Both of them are crucial during the design and further phases of a database. They allow us to uniquely identify each row, ensure the uniqueness of values in the column(s), and more. Let’s take a deep dive to learn more. This article will go through the primary and unique keys, their functions, and features.
Read more
6 Jul 2021
Tihomir Babic

RANGE Clause in Window Functions: 5 Practical Examples

What is a RANGE clause in SQL window functions? Five practical examples will show you how and when to use it. The RANGE clause is used quite rarely in SQL window functions. I don't know why; maybe people are not used to it. This is a shame, because it's far from a pointless clause; it can be very useful, and I'll show you that in five examples. To learn how window functions work, what functions there are, and how to apply them to real-world problems, it’s best to take the Window Functions course.
Read more
2 Jul 2021
Karolina Niewiarowska

How to Learn SQL Faster

Struggling with learning SQL? Does it seem like you’re doing everything right, but not making progress as fast as you’d like? Don't worry, I'll help you. Here are some tips for learning SQL quickly and painlessly. Are you wondering how to learn SQL faster? If so, I’m here to help with some practical tips. And once you’ve found the right motivation and the right sources of knowledge, you’ll be able to learn faster.
Read more
1 Jul 2021
Jakub Romanowski

Course of the Month: Recursive Queries in SQL Server

Do you want to become a SQL expert? To do this, you need to learn SQL CTEs or Common Table Expressions. They can make your queries clearer and more readable. And during July 2021, you can learn CTEs for free using our interactive Recursive Queries in MS SQL Server course! How can you get this free SQL course? Create a free LearnSQL.com account or log in if you already have one.
Read more
30 Jun 2021
Zahin Rahman

Top 15 SQL Interview Questions in 2021

If you are on the lookout for a job in the field of data, you’re almost guaranteed to face SQL interview questions. You might even be asked to complete some kind of SQL coding test. According to KDnuggets, irrespective of the specific role in data – data analyst, data engineer, data scientist, or business intelligence analyst – SQL lands in the top three skills found in postings across Indeed, SimplyHired, and Monster.
Read more