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
1 Jul 2023
Jakub Romanowski
Free Course of the Month – Writing User-Defined 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
22 Jun 2023
Maria Durkin
7 Reasons Why AI Won't Replace SQL Developers
So you've heard all about AI and the famous ChatGPT. And you're wondering if these tools would be beneficial or detrimental to your profession. In this article, we will put your fears to rest and explain how SQL and AI can work together and make developers’ jobs easier. Let's start with an explanation of what Artificial Intelligence (AI) is. AI is an area of computer science concerned with creating machines capable of performing activities that would normally need human intelligence.
Read more
20 Jun 2023
Tihomir Babic
What Is a LEFT OUTER JOIN in SQL? An Explanation With 4 Examples
Today’s article will discuss the LEFT OUTER JOIN in SQL. We’ll go through several examples of LEFT OUTER JOIN usage and compare it with INNER JOIN. A JOIN is an SQL feature that allows you to combine data from two or more tables. The nature of relational databases makes JOIN one of the most commonly used features in SQL. Why? In practice, you’ll very seldom have all the required data in one table.
Read more
15 Jun 2023
Dominika Florczykowska
An Overview of MySQL Window Functions
MySQL window functions are very helpful when you want to create meaningful reports with SQL. In this article, we’ll demonstrate the most common window functions in MySQL and explain how to use them. MySQL 8.0 introduced a new feature: window functions. These functions are very useful to data analysts and anyone who creates reports using MySQL. Using them, you can easily compute moving averages, cumulative sums, and other calculations over specified subsets of your data.
Read more
13 Jun 2023
Maria Durkin
Who Is a Data Manager?
Who are data managers? What are their responsibilities, and how do I become one? We’ll answer these questions and get you on your way to becoming a data manager! Simply put, data managers oversee the management of information or data within an organization. They manage data organization, storage, security, and accessibility, and they collaborate with other team members to guarantee data accuracy and usefulness in supporting decision-making. To ensure that data is effectively managed and used appropriately, they may also develop and implement policies and procedures pertaining to data management.
Read more
««
«
1
2
3
4
5
6
78
»
»»