Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
Guides
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
String Functions
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
Best Way to Learn SQL
SQL Primer
Flashcards
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
String Functions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
12 Jul 2022
Himanshu Kathuria
What Is SQL Used For?
So you’ve heard about databases and SQL, but you’re not sure what the big deal is. Read on to find out why data skills like SQL are so important. It seems like every other job requires you to know something about data, databases, and SQL. But what are these things, and what are they used for? Who even uses SQL? That’s what we’ll discuss in this article. Why Data Is So Important The Internet and the technology revolution have brought unprecedented opportunities.
Read more
7 Jul 2022
Tihomir Babic
An Overview of SQL Text Functions in MySQL
Do you work in MySQL as a data analyst? Then you should know how to use its text functions – data analysts don’t work only with numbers. Reporting requires computations, data classification, and label creation, and you can do all of that in MySQL. In this article, I’ll explain several of the most common and useful MySQL text functions by discussing what they do and showing how they do it.
Read more
1 Jul 2022
LearnSQL.com Team
New Monthly SQL Practice for July 2022!
Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s July’s SQL Practice course! This time, you will help Ruby. She is the creator of a language tandem app, that is, a chat application in which learners can find native speakers for practicing languages. Ruby would like to gather data to help expand her business, and she has hired you as an SQL specialist to help her out.
Read more
30 Jun 2022
Ignacio L. Bisso
Learn the OVER() Clause in SQL with 7 Examples
Learn how to use the OVER() clause in your SQL queries and you will take a step forward in your SQL knowledge. Most data analysts and SQL developers have a good handle on the SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses. However, these clauses are only a limited subset of the SQL language. There are other clauses, such as OVER(), which allow us to create flexible SQL reports and add an enormous expressive power to the SQL language.
Read more
28 Jun 2022
Kateryna Koidan
What Is SQL?
SQL may be something you hear about from your colleagues. Or you may see it in the job description for your dream role or notice it in a list of the most popular programming languages. So, what is SQL? Should you learn it? Let's find out. Do you think about a career in data analysis and data science? Do you need to interact with relational databases at work? Do you want to improve your performance as a marketer, HR specialist, or researcher by making more informed decisions?
Read more
23 Jun 2022
Tihomir Babic
An Overview of Microsoft SQL Server Text Functions
Data analysts use text values when creating SQL reports. You can create your own labels with functions, classify rows based on text value, or do computations based on it. This article covers how to do all that. The text values in databases are not just for reading. As with numeric values, we perform operations on them and manipulate the text. SQL Server has a fair number of text functions.
Read more
21 Jun 2022
LearnSQL.com Team
Prepare for a SQL Interview with LearnSQL.com
You've been working hard to get a SQL interview at your dream company. Now they’ve called – and you need to prepare if you’re going to ace it. In this article, I’ll show you the most efficient way to prepare for a job interview using the interactive SQL courses at LearnSQL.com. SQL is an essential skill for anyone working with data. Wanna be a data analyst, data scientist, software engineer, or tester?
Read more
16 Jun 2022
Himanshu Kathuria
Learn SQL in 4 Steps
Want to work with data? You’ll need SQL. Fortunately, you can learn SQL in just 4 steps! If you are interested in data crunching or working with data in general, you’ve probably heard something about SQL. Now that data storage is cheap and accessible, data from every transaction can be stored and analyzed. Hence, there’s great demand for people who can capture and work with this data. We’ve even seen entire companies profit from being proficient with data; for example, consider the ever-growing value of Google and Facebook (now Meta).
Read more
14 Jun 2022
Himanshu Kathuria
These SQL Queries Will Help You With Data Analysis
Need to streamline your everyday data analysis tasks? This article explains how basic SQL queries can help. If you are planning a corporate career or any field that involves working with data, you must have come across SQL, or Structured Query Language. SQL was first developed in the 1970s and it continues to be the industry standard for database interactions. Many of you may already have decided to learn this language, given how powerful it is.
Read more
9 Jun 2022
András Novoszáth
5 Tips for You From a Senior SQL Data Analyst
Are you looking for tips for becoming a better data analyst? Do you want to know about the mistakes and issues you may face? I have collected five tips for your everyday work based on my experience as a data analyst. You may have already read about what data analysts do, how much they earn, and how to become one. However, there is more to it than just becoming a data analyst.
Read more
««
«
1
2
3
24
25
26
80
»
»»