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
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
SQL JOINs
Numeric Functions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
5 May 2020
Dorota Wdzięczna
You Want to Learn SQL? You've Come to the Right Place!
It is difficult to list all the benefits of learning SQL. You will work faster and more efficiently with a database, you will no longer be dependent on the IT department, and you will be able to analyze the data yourself and draw appropriate conclusions, among others. Add reporting to this, and you will get a very wide range of cool and useful skills. Maybe you want to change jobs or get a promotion?
Read more
1 May 2020
Rebecca McKeown
How to Practice SQL for a Technical Job Interview
You’ve scored yourself an interview for an SQL-related job. Nice work! But perhaps uncertainty is creeping in as your interview date looms closer. Do you know enough SQL to make the cut? What questions are you likely to be asked? What SQL practice should you be doing before your interview? Almost all SQL job candidates go through exactly the same nerve-wracking process. Here at LearnSQL.com, we have the lowdown on all the SQL practice and preparation you’ll need to ace those interview questions and take your career to the next level.
Read more
1 May 2020
LearnSQL.com Team
New SQL Monthly Challenge for May 2020!
The new LearnSQL.com Monthly Challenge is ready! In May, we invite you to use your SQL knowledge to help a bakery manager buy a new oven. Is this the first time you’ve ever come across our Monthly Challenge? Then you should know that it’s a set of 5 to 10 SQL exercises prepared for people who want to practice their SQL skills. Each challenge is designed around a specific theme.
Read more
30 Apr 2020
Kateryna Koidan
Is SQL a Programming Language?
Updated on: October 30th, 2023 SQL is a powerful tool for communicating with database management systems. When you write SQL queries, you give instructions to the computer and it performs these instructions—it sounds like programming. However, you cannot build an application with SQL as you can with Python or Java. So, is SQL a programming language? For over 50 years, SQL, or Structured Query Language, has been a cornerstone in the world of data management.
Read more
29 Apr 2020
LearnSQL.com Team
SQL Course of the Month – Window Functions
Spring has come. It is nicer outside. It's a great time to learn something new. Which course should you choose? In April, it's worth it to bet on SQL window functions. What are they, what are they used for, and why are they worth knowing? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, these questions. She has a PhD in mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw.
Read more
29 Apr 2020
LearnSQL.com Team
SQL Window Functions Cheat Sheet
Unlock the full potential of SQL with our comprehensive Window Functions Cheat Sheet! This indispensable guide is designed to elevate your analytics capabilities and make complex data manipulations effortlessly accessible. Welcome to the ultimate resource for mastering SQL window functions - the SQL Window Functions Cheat Sheet! This invaluable resource provides you with the essential syntax, a comprehensive list of window functions, and real-life examples to enhance your SQL skills and analytics capabilities.
Read more
28 Apr 2020
Dorota Wdzięczna
What Is a SQL Running Total and How Do You Compute It?
The SQL running total is a very common pattern, used frequently in finance and in trend analysis. In this article, you’ll learn what a running total is and how to write a SQL query to compute it. The best way to learn SQL is through practice. LearnSQL.com offers over 30 interactive SQL courses at various level of difficulty. Each course is interactive: there is a little bit of reading, followed by an exercise to practice what you've just read.
Read more
24 Apr 2020
Kate Stolarek
Is SQL Worth Learning?
We’re in the 21st century. These are the “ultimate data times” in which loads of information on all kinds of things is available. We want to explore this info even more, slice and dice it, understand where it comes from and what triggers it. With such large amounts of data coming in, people have discovered that spreadsheets aren’t enough. There’s a need for a greater solution, something like a spreadsheet on steroids.
Read more
23 Apr 2020
Arleta Więch
Top 3 Platforms to Learn SQL Online: A Complete Comparison
Do you want to learn SQL online? Where do you start? There are many choices on the internet, and it can be hard to decide. But don’t worry—I tested and compared three major platforms to help you find the best place to learn SQL online! E-learning is on the rise. It gives us infinite possibilities of growing our professional careers without leaving our homes. And increasing our competencies is especially important now that the labor market has become dynamic and unstable.
Read more
22 Apr 2020
Tihomir Babic
When Do I Use SQL Window Functions?
Have you heard one of your colleagues bragging about using SQL window functions? Do you know basic SQL but not much, or anything, about window functions? If you want to learn about window functions and how to use them in a business context, you’re in the right place! This happens often. You reach a certain level of knowledge, and you feel like the king (or queen) of the world.
Read more
««
«
1
2
3
61
62
63
79
»
»»