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
12 Sep 2023
Maria Durkin
SQL for Project Managers: Enhancing Decision-Making
Did you know that SQL is a vital component in the project manager’s toolkit? In this article, we'll delve into how SQL for project managers enhances their workflow, promotes informed decision-making, and boosts operational efficiency. Data has become the foundation of decision-making across industries. In today's data-driven world, it's critical to arm yourself with the correct tools for dealing with the influx of data. One such tool that has stood the test of time is Structured Query Language, better known as SQL.
Read more
11 Sep 2023
Valentyn Kucherenko
An SQL Basics Primer for Non-IT Professionals
You don’t need to be an IT professional to understand SQL. Our quick primer of SQL basics is perfect for beginners without any computer science or programming background. If you’ve ever tried to learn a new software program, you know it takes more than just a few minutes. But it doesn’t mean you can’t learn it! The same is true if you want to learn SQL and databases. Even if you don’t have an IT background, you can do it.
Read more
7 Sep 2023
Ignacio L. Bisso
COUNT OVER PARTITION BY: An Explanation with 3 Examples
In SQL, combining the COUNT() function with the OVER() clause and PARTITION BY opens the door to a totally different way to count rows. In this article, you’ll learn how to do several COUNTs in a single query and calculate expressions based on the result of the COUNT function. In this article, we will cover how you can use the COUNT() function combined with the clauses OVER() and PARTITION BY.
Read more
5 Sep 2023
Tihomir Babic
SQL Joins: 12 Practice Questions with Detailed Answers
In this article, we dig into our SQL JOINS course and give you 12 join exercises to solve. But don’t worry – all the exercises have solutions and explanations. If you get stuck, help is there! This is, after all, made for practicing and learning. SQL joins can be tricky. It’s not just the syntax, but also knowing what joins to use in what scenarios. Joins are used when combining data from two or more tables in SQL.
Read more
4 Sep 2023
LearnSQL.com Team
SQL Server Cheat Sheet
Welcome to the SQL Server Cheat Sheet! Whether you're just starting out with SQL Server or you're a seasoned developer looking for a quick reference, this guide is tailored for you. This cheat sheet is a comprehensive guide to SQL Server, offering a quick reference to its essential commands. It covers the basics of creating and displaying databases and tables, the commands to modify tables, and the fundamental syntax for T-SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
Read more
1 Sep 2023
LearnSQL.com Team
Free Course of the Month – SQL Practice Set in PostgreSQL
Do you know the basics of PostgreSQL but still need some practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of September, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice.
Read more
31 Aug 2023
Jakub Romanowski
How SQL Helps the Healthcare Sector
Why does the healthcare industry need SQL? Find out how you can use SQL for healthcare in this article. The digital age has ushered in a new era where data is at the heart of every industry. From finance to retail, data drives decision-making and strategy, shaping the way businesses operate and grow. The healthcare sector, with its vast and complex data sets, is no exception to this trend. The rise of digital health records, patient databases, and common integration of hospital inventory management software has underscored the importance of efficient data management in healthcare.
Read more
29 Aug 2023
Maria Durkin
How AI & SQL Can Accelerate Your Data Analysis Workflow
Did you know that using AI for data analysis can be a total game changer for SQL developers and data analysts? In this article, we’ll learn about how AI can help you level up your data analysis skills and why it’s a must-have tool in every data professional’s toolkit. Artificial Intelligence (AI) has emerged as a game-changer in the workforce, transforming industries and redefining how professionals deal with data. Specifically, the use of AI for data analysis is becoming increasingly critical in making informed decisions.
Read more
29 Aug 2023
LearnSQL.com Team
New Monthly SQL Practice for September 2023!
Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the September SQL Practice course! This time, you will help Evelyn, the owner of a local art gallery. She would like to gather data to grow her business and has hired you as an SQL specialist to help her out. Which art pieces have not been exhibited? What is the transportation cost for each art piece?
Read more
25 Aug 2023
LearnSQL.com Team
SQL for Data Analysis Cheat Sheet
Welcome to our SQL for Data Analysis Cheat Sheet — a must-have resource for anyone looking to harness the power of SQL in the realm of data analysis. Whether you're a data enthusiast, a business analyst, or a seasoned data professional, this cheat sheet is designed to empower you to extract valuable insights from your datasets. Inside, you'll find a carefully curated collection of SQL commands and tips that will elevate your data analysis game.
Read more
««
«
1
2
3
9
10
11
80
»
»»