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
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
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
28 Jul 2022
Kateryna Koidan
How to Set Up a Corporate SQL Training Program
Are you looking to set up a business or corporate SQL training for your company's employees? In this article, we’ll discuss how to build an efficient SQL training program and why the LearnSQL.com platform is the choice of leading tech companies. If you are responsible for employees’ professional development – especially in a data-driven company – you know that SQL is essential for anyone who works with data. This programming language can enhance the performance of data and business analysts (for whom SQL is often a primary tool) as well as marketers, salespeople, HR specialists, auditors, and many more.
Read more
26 Jul 2022
András Novoszáth
How to Get More from Your BI Tools with SQL
Are you frustrated with the limitations of your business analytics tool? Do you wonder if there are other features you could tap into? Would you like to know how SQL compliments your work with Power BI and Tableau? Read this article to learn more! If you are a data analyst or if data analysis is part of your everyday job, Business Intelligence (BI) tools are crucial for your work. You also know that most databases run SQL queries in the background of such tools.
Read more
21 Jul 2022
Kateryna Koidan
Use SQL for Data Analysis With the New Google Analytics 4
As Google is sunsetting its Universal Analytics in favor of Google Analytics 4, data analysts need to adapt and learn how to get the most from the new tool. In this article, I'll discuss how to enhance your data analysis by using SQL with Google Analytics 4. Universal Analytics by Google has been helping data analysts and marketers in all industries everywhere understand their audience better. However, Google recently announced they would stop their support of Universal Analytics on July 1, 2023.
Read more
19 Jul 2022
Alexandre Bruffa
Switching from PostgreSQL to MS SQL Server
What are the differences in PostgreSQL vs. MS SQL Server? We discuss the similarities and the differences between these two popular SQL dialects. Many of us developers and database specialists began working with free relational databases like PostgreSQL or MySQL for personal projects or small organizations. Some of us have since moved on to organizations using MS SQL Server and have had to learn to use the new tool. You may be wondering how challenging that is and whether you would struggle with SQL Server under similar circumstances.
Read more
14 Jul 2022
Kamila Ostrowska
5 Tips for Learning SQL for Beginners
Being data-driven is a hot trend right now. Employers are looking for people who can work with databases. This is why you should learn SQL. In this article, I'll explain how to go about doing so. Yes, learning SQL may be the right thing for you even if you have never seen a line of code. As with any new skill, it requires the right approach and the right resources.
Read more
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
««
«
1
2
3
23
24
25
80
»
»»