Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
Other Assets
Flashcards
SQL Primer
Log in
Create free account
fullName
User profile menu open
Open user profile menu
fullName
Dashboard
My Profile
Payment & Billing
Log out
MENU
CLOSE
Courses
Pricing
For Students
Articles
Cookbook
Cheat Sheets
Flashcards
SQL Primer
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
12 Oct 2023
Dominika Florczykowska
What Does ORDER BY 1 Mean in SQL?
Have you ever seen the "ORDER BY 1" syntax in SQL queries and wondered what it means? In this article, we'll explore this syntax, clarify its purpose, and make it easier to grasp. Whether you're an experienced SQL user or just starting to explore this language, you've likely encountered the ORDER BY clause before. In SQL, the ORDER BY clause is used to sort the rows in a table based on one or more columns.
Read more
10 Oct 2023
Martyna Sławińska
SQL JOINs Explained: 5 Clear SQL INNER JOIN Examples for Beginners
Looking for a clear explanation of joins in SQL? Check out these five SQL INNER JOIN examples! In SQL, INNER JOINs can be a bit difficult for beginners to master. But once you start working with them, you’ll learn they’re very useful! Let’s discuss five examples of SQL INNER JOINs. But first, let’s do a quick review of why JOINs matter. In relational databases, data is organized and stored within tables.
Read more
5 Oct 2023
Jill Thornhill
BigQuery Window Functions Explained
Keeping up with data analysis trends gives your organization – and your CV – the cutting edge. In this article, we'll look at BigQuery window functions and how you can use them to gain deeper insights into your data. Google's BigQuery, launched in 2010, is gaining traction as a popular choice with organizations needing to analyze large quantities of information quickly and to compare their own data against statistical data in the public domain.
Read more
3 Oct 2023
Maria Durkin
How SQL for Business Can Boost Profit and Effectiveness
Are you ready to unleash the power of SQL and transform your business? In this article, we'll look at all of the ways SQL can improve your company's performance, from decision-making capabilities to operational efficiency. Having the correct tools to traverse the sea of information is critical in today's data-driven corporate climate. Structured Query Language, or SQL, is an essential tool for this task—and it’s one that has endured the test of time.
Read more
1 Oct 2023
Jakub Romanowski
Free Course of the Month – Basic SQL Practice: Blog & Traffic Data
Why practice SQL with real-life scenarios? We'll explain in this article – and we’ll show how you can do it for free during October 2023 with this LearnSQL.com course! SQL is the backbone of many data-driven applications and businesses. It's a powerful language that allows you to interact with databases, retrieve data, and make insightful decisions. If you're looking to improve your SQL skills, our Basic SQL Practice: Blog & Traffic Data course is the perfect opportunity.
Read more
28 Sep 2023
Ignacio L. Bisso
How to Use ROW_NUMBER OVER() in SQL to Rank Data
Sometimes you need to know the position of rows in a result set. Learn how using ROW_NUMBER and OVER in SQL can make it happen! Have you ever needed to add a sequential number to the records returned by an SQL query? Or perhaps you need to create a ‘top n’ report based on a specific ranking. In any of these cases, you need to calculate the position of the row in the ranking.
Read more
28 Sep 2023
LearnSQL.com Team
New Monthly SQL Practice for October 2023!
In our October 2023 SQL Practice, you meet Sophie. She manages an online business for publishing and printing books and needs you to access and present various statistics to help her grow her business. Can you use your SQL skills to help? It should not be too hard if you have finished our SQL Basics courses or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice.
Read more
26 Sep 2023
Kamila Ostrowska
How SQL Can Help You Understand Your Clients Better
In this article, we will delve into how SQL can help businesses analyze customer data, uncover patterns, and make informed decisions to meet their clients' needs. Managing and understanding clients is crucial for any business, and this requires data. Client data, such as purchasing habits, preferences, and feedback, is typically stored in databases. To access and analyze this data, you need to be proficient in SQL, the language designed for managing and querying data in databases.
Read more
21 Sep 2023
Tihomir Babic
What Is FULL JOIN in SQL? An Explanation with 4 Examples
What is FULL JOIN – one of the often neglected SQL join types? In this article, we’ll show you how useful FULL JOIN can be and teach you how to apply it to different scenarios. The four examples cover some of the typical uses. An SQL join is a construction for combining data from two or more tables. FULL JOIN is one of the types of joins. You’ll get the most from this article if you’re already familiar with SQL joins and how they work.
Read more
19 Sep 2023
Alexandre Bruffa
Python vs. SQL for Data Analysis
You surely have heard about SQL and Python. Maybe you’ve even worked with one of those languages. Both have strengths and weaknesses. When it comes to data analysis, which should you use? This article will demonstrate how Python and SQL are useful for data analysis and how knowing both languages can boost your data analysis journey. Decided to get into data analytics? Great! An increasing number of companies are looking for people who can analyze data and draw conclusions from it.
Read more
««
«
1
2
3
78
»
»»