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
26 Jul 2023
Jakub Romanowski
The Best Way to Learn SQL: A Complete Guide for Beginners
If you've ever wondered about the best way to learn SQL, you're in the right place. Whether you're a complete beginner or an experienced professional looking to upskill, this comprehensive guide will show you the way. In today's data-driven world, you can think of data as a treasure chest full of gold. And SQL (Structured Query Language) is your personal key to unlocking it. SQL is a potent tool that allows you to communicate with databases, enabling you to extract, shape, and make sense of data.
Read more
25 Jul 2023
Tihomir Babic
Using GROUP BY and ORDER BY Together: A Guide
Untangling how to use two basic SQL clauses – GROUP BY and ORDER BY – in one query. GROUP BY and ORDER BY are basic SQL clauses. As such, they are taught relatively early in the learning process. And they usually don’t present a big hurdle to beginners. However, using GROUP BY and ORDER BY together can be confusing. By the end of this article, your confusion on this subject will go away.
Read more
20 Jul 2023
Tihomir Babic
A Complete Guide to Working With Substrings in SQL
In this article, we’ll discuss how to work with substrings in SQL. It involves learning several approaches, so we’ll show you their ins and outs. To work with substrings in SQL, we first need to know what a string is. In programming, a string is any kind of textual data (a title, a description, a name). A string consists of any number and type of characters. In a SQL database, strings are typically stored as CHAR or VARCHAR data types.
Read more
18 Jul 2023
Maria Durkin
SQL for Data Analysis: What Should I Learn?
You may already be aware of SQL's importance in data analytics. But what features of SQL are important to data analysis and where can you learn them? In this article, we will answer your questions. Before we talk about using SQL for data analysis, it helps to know what we’re talking about. So, let’s define these two things. Structured Query Language (SQL) is a programming language that is used to manage data in relational databases.
Read more
13 Jul 2023
Alexandre Bruffa
How SQL Skills Can Boost Your Resume
You may wonder: does having SQL skills matter? In what areas could I use my SQL skills? In this article, I will explain how having SQL skills can boost your resume and add momentum to your professional career. We are living in the Big Data era. Every time we go online, we provide the websites we visit with a lot of information. If we voluntarily give our data by creating an account, filling out a form, or making a purchase, we give them even more information.
Read more
11 Jul 2023
Maria Durkin
How to Master SQL
You've heard SQL is a must-have skill for furthering your career. You want to learn it. In this article, we look at why it is so beneficial to master SQL and how you can reach that level of mastery. Master SQL, and unlock the power of relational databases, the most used databases for managing structured data. But what makes SQL so important? SQL, or Structured Query Language, is a must-have skill for anybody navigating today's data-driven world.
Read more
6 Jul 2023
Jill Thornhill
Google BigQuery SQL Syntax: A Comprehensive Guide
What is Google BigQuery? What can it do for your organization? Is BigQuery SQL a valuable skill? Where can you learn it, and where can you get some practice? Very few organizations today are not computerized. Many processes now make use of the IoT (Internet of Things), where all kinds of devices are networked and continually feed real time data into computer systems. The result is a vast amount of data available for decision-making.
Read more
5 Jul 2023
Jakub Romanowski
Our New Interactive Course – SQL Practice: University
Are you a beginner looking for a hands-on online SQL course to solidify your skills? Or perhaps you're an SQL learner hungry for real-world applications of your new skills? LearnSQL.com, has crafted a robust practice-based learning experience to help you advance at your own pace. Here is SQL Practice: University! In today's data-driven world, mastering SQL is more than just a useful skill—it's a powerful tool that can open doors to many career opportunities.
Read more
4 Jul 2023
Nicole Darnley
How E-Commerce Businesses Can Benefit From SQL
Learn how SQL for e-commerce can empower your online business. When we talk about business in the modern age, the phrase "knowledge is power" takes on a whole new dimension. In the world of e-commerce, the real power lies in the ability to leverage data; one of the key tools in the arsenal of data management and analysis is SQL. SQL, or Structured Query Language, is essential for e-commerce businesses looking to extract valuable insights from their vast reserves of data.
Read more
1 Jul 2023
Jakub Romanowski
Free Course of the Month: Write Functions in PostgreSQL
Why learn to write user-defined functions? I’ll explain in this article – and how you can learn for free during July 2023 with this LearnSQL.com PostgreSQL course! PostgreSQL is one of the most popular databases in the world. This is mainly due to its great functionality and the fact that it’s open source (i.e. free!). Postgres is fast, it runs on multiple systems, and it’s suitable for almost any application.
Read more
««
«
1
2
3
11
12
13
80
»
»»