Articles Cookbook
2 Apr 2020
Agnieszka Kozubek-Krycuń

How to Get the First Day of the Week in SQL Server

This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. This interactive course will teach you how to analyze customer lifecycle in a SQL database in over 70 hands-on exercises. You will learn how to find out compare registration rates between periods of time, compute conversion rates in SQL, compare customer cohorts, analyze customer activity and customer churn over time. This course is essential for anyone doing customer analysis in their job.
Read more
2 Apr 2020
Agnieszka Kozubek-Krycuń

How to Group Data by Week in SQL Server

This is additional content for the LearnSQL.com course Customer Behavior Analysis in SQL Server. In this course, we showed you how you can analyze the customer lifecycle (customer acquisition, conversion, activity, retention, and churn) with SQL. We discussed customer registration cohorts, or groups of customers who registered during the same period (e.g. same week, same month). Analyzing customer registration cohorts lets you see registration trends and relate registration cohorts with marketing campaigns.
Read more
1 Apr 2020
Jakub Romanowski

Types of Database Jobs

Do you dream of high earnings and interesting work? Are you fed up with your boss and his or her annoying vacation stories in exotic countries? Is it time to change your job? Why not learn SQL? Here are some examples of the types of database jobs that may lead you to a better life. What types of database jobs use SQL? Here are some examples, but first, a small caveat.
Read more
31 Mar 2020
Rebecca McKeown

The 50 Best Resources for Learning SQL (Updated for 2024)

Do you want to know where to learn SQL? We’ve got you covered with the ultimate list of 50 SQL learning resources, including the best SQL courses, tutorials, books, and much, much more! Learning SQL can be hard enough without wading through thousands of websites and articles. So, we thought we’d do you a solid and put the top SQL resources here in this handy slice of the internet.
Read more
27 Mar 2020
Agnieszka Kozubek-Krycuń

Why Window Functions Are Not Allowed in WHERE Clauses

Window functions are extremely powerful, but there are a lot of nuances and little details you need to learn about using window functions in order to use them correctly and efficiently. A fairly common question SQL users have is why window functions are not allowed in WHERE. TL;DR: You can use window functions in SELECT and ORDER BY. You cannot use window functions in WHERE, GROUP BY, or HAVING.
Read more
25 Mar 2020
Kamil Bladoszewski

How to Rank Rows in SQL: A Complete Guide

Don’t struggle with SQL ranking functions anymore! This article will guide you through the most common ranking use cases. Rankings are used around us every day. Sports tournaments, the best movies and TV series on Netflix, stores with the cheapest products—these are only a few examples of rankings you might’ve seen recently. Using SQL RANK functions might be hard sometimes. The variety of different constructions is enormous. You can easily get lost in everything there is to learn about ranking.
Read more
24 Mar 2020
Emil Drkušić

How to Practice SQL JOINs

There is no better way to learn how to practice SQL joins than through hands-on experience. However, there will probably be obstacles along the way. I’ll cover some of these obstacles and give ideas for how to overcome them. While this article won’t turn you into SQL JOINs expert, it will show you how to become one. So, let’s start! Diving into the world of databases? Then you've likely come across SQL joins.
Read more
20 Mar 2020
LearnSQL.com Team

Stay at Home and Learn SQL for Free with LearnSQL.com

Working remotely is a dream come true for some. You ditch commuting and have more time for the people you love and the things you enjoy. For others, it's a challenge to maintain their focus when there are new distractions. It's also an opportunity to invest the few gained hours in learning something new. Staying at home can be a time when you might find yourself busier than you've ever been, but not getting many things done, and worse, not learning what you planned to.
Read more
19 Mar 2020
Kate Stolarek

Video Tutorial or Interactive SQL Course – Which Is Better?

Are you ready to get started with SQL but unsure which learning method is the most effective? In this post, we’ll talk about the pros and cons of learning SQL from an instructional video vs. an interactive online course. Are you a chronic Internet-using student who’s planning to learn SQL? Maybe you did some research but still don’t know which kind of training is worth your (limited) time. We all have families, hobbies, and other after-work commitments, and finding the right resource for learning SQL will save you some time.
Read more
18 Mar 2020
Tetyana Skorykh

How Will Learning SQL Improve My Daily Work?

Whether you're focused on advancing your career, mastering in-demand skills, or exploring something new and captivating, learning SQL is key to your progress. This vital skill makes professional life more manageable and also sets you up for success in a data-centric world. Are you thinking of learning SQL but aren’t sure if it's a good idea? If you’re not in a data- or IT-related job, learning SQL may seem completely useless.
Read more