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
9 Oct 2020
Marija Ilic
How to Join the Same Table Twice
JOIN is one of the most common statements in SQL. As you may know, it is used to join and combine data from two or more tables into one common data set. In this article, I’m going to discuss special types of joins? in which you combine the same table twice—including joining a table to itself, also known as the self join. When and why do you need to do this?
Read more
8 Oct 2020
Marcin Koryszewski
5 Best Online SQL Courses for Business Analysts
Why bother to learn via an online SQL course? SQL is pure profit – it allows analysts to interpret data efficiently and companies to adopt better strategies. In this post, we’ll look at our top 5 SQL courses for business analysts. Being into finance, economics, and IT systems has brought you to business analysis. It’s a fascinating combination of skills; you’re combining business and technology, which makes you a valuable asset to your company.
Read more
7 Oct 2020
Marija Ilic
How to Create Your First Table in SQL
Creating a database table with SQL is one of the core skills you’ll need to work with data. And it’s easy to learn, so let’s get started! Imagine you’re analyzing data and want to store your results in a database table. Sure, you've done this a million times in Excel. But you’re not sure how to create a table with SQL. Or maybe you’ve noticed that data engineering is in high demand and you want to start learning its core concepts.
Read more
6 Oct 2020
Agnieszka Kozubek-Krycuń
Five Essential Features of a Good SQL Course
There are many different platforms offering SQL courses. If you’re a beginner, it may be difficult to choose the right one for you. Find out what we think are the essential features of a good SQL course. Remember, if you make a poor choice at the beginning, you may get discouraged or get into bad habits that will impact your work down the line. What Is SQL? SQL, or Structured Query Language, is a programming language you use to talk to databases.
Read more
2 Oct 2020
Martyna Sławińska
A Comprehensive Introduction to Window Functions in MySQL
Do a deep dive into the working principles, syntax, and applications of various MySQL window functions. There are many open source databases you could choose; MySQL is consistently one of the most popular. But until 2018, there was no provision for including window functions in MySQL. Fortunately, all that has changed – starting from MySQL 8.0, SQL window functions were now available to MySQL users. Please note that window functions are available only in MySQL 8.
Read more
1 Oct 2020
LearnSQL.com Team
New Monthly SQL Challenge for October 2020!
The new Monthly Challenge on LearnSQL.com is ready! In October, we invite you to try your SQL skills by learning about job positions and recruitment agencies. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers a new SQL challenge every month. Each challenge contains 5 to 10 SQL exercises designed for people who want to practice their SQL skills. It takes less than an hour to solve these tasks.
Read more
1 Oct 2020
LearnSQL.com Team
SQL Course of the Month: INSERT, UPDATE, DELETE Data
So, you've started learning SQL, and you already know what the SELECT command is and when to use it! Congratulations! Now, it's time to take the next step towards becoming an expert. You need to know the SQL UPDATE, INSERT, and DELETE commands to modify data in your tables. These are the basics that will allow you to work with tables. But what's the best way to learn them? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo.
Read more
30 Sep 2020
Kamila Ostrowska
How Will Learning SQL Make You a Better Boss?
Updated on: April 6, 2024 Looking to enhance the performance of your team, elevate your own productivity, or boost the efficiency of your entire department or company? Consider learning SQL! Why? Because its benefits are substantial and the return on investment is significant. What does learning SQL and being a better boss have to do with each other? Being a better manager can make your employees happier while growing your business.
Read more
29 Sep 2020
Tihomir Babic
Six Window Function Templates to Save in Your Code Editor
Do you use window functions often enough to know them well but not often enough to remember all the details? Here are six window function codes you should save as templates. Window functions are a handy SQL option, but it doesn’t mean you use them all the time. Maybe you only use them occasionally; if that’s the case, you probably find yourself needing to refresh your memory every time you use them.
Read more
28 Sep 2020
LearnSQL.com Team
New Course: Customer Behavior Analysis in SQL
Good news! A new SQL course is here! We’re happy to announce the release of our Customer Behavior Analysis in SQL course. Do you want to get to know your clients and better understand their needs and behavior? If so, this great interactive SQL course is for you. Discover the power of full customer lifecycle analytics in SQL and know more than your competitors. The LearnSQL.com team is happy to announce the release of a new SQL course on our platform: Customer Behavior Analysis in SQL.
Read more
««
«
1
2
3
52
53
54
79
»
»»