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
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
30 Jun 2023
LearnSQL.com Team
Here Are Our New SQL Flashcards
Preparing for an SQL exam or Data Job interview? Save these SQL Flashcards and always have them to hand, so you don’t forget anything during the most important moments. At LearnSQL.com, we understand that everyone has a unique learning style and pace. That's why we’ve created SQL Flashcards. They can help you during preparation for an exam or to consolidate your SQL knowledge. They are carefully crafted to help you reinforce your understanding of SQL concepts, syntax, and commands, making them an invaluable companion on your SQL learning journey.
Read more
30 Jun 2023
LearnSQL.com Team
New Monthly SQL Practice for July 2023!
Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the July SQL Practice course! You will help Isabella, the founder of an online home swap platform. On this platform, homeowners can find a place to stay for vacation by swapping homes with other homeowners. Isabella would like to gather data to help her expand the business, and she has hired you as an SQL specialist.
Read more
29 Jun 2023
Radu Gheorghiu
How to Use COUNT() with GROUP BY: 5 Practical Examples
Using the COUNT() function with GROUP BY is one of the most common SQL constructs in aggregate queries. Read this article to find out how to use COUNT() with GROUP BY correctly using 5 examples. In this article, we will explain the importance of using COUNT with GROUP BY. We’ll talk about why it is essential in SQL and how it enables data analysis and summarization based on specific criteria.
Read more
27 Jun 2023
Jill Thornhill
How to Learn T-SQL Querying
T-SQL is the dialect of SQL used by Microsoft SQL Server databases. Find out the best way to learn T-SQL querying with interactive online courses. In today's data-driven world, increasing your database knowledge is always a good choice. Microsoft SQL Server is one of the most popular databases nowadays. Knowing T-SQL – the query language of SQL Server databases –is often recommended as a worthwhile skill for careers in IT, business, or research fields.
Read more
26 Jun 2023
LearnSQL.com Team
53 Years of Relational Databases
If it weren't for him, there would be no modern databases. It is the 53st anniversary of the publication of his article that changed the rules of the game. Edgar Frank Codd is one of the fathers of SQL, and his name is one of the first to be mentioned in the history of databases. Or maybe even the history of computer development in general? See what we owe to Dr.
Read more
««
«
1
2
3
12
13
14
80
»
»»