Articles Cookbook
1 Oct 2020
LearnSQL.com Team

SQL Course of the Month – How to INSERT, UPDATE, and DELETE Data in SQL

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?

Want to improve the performance of your team, of your own, of your department, or of your entire company? Try SQL! Why should you learn SQL? Because it just pays off! 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. When employees feel a sense of fulfillment, they are more motivated to do well.
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
25 Sep 2020
Jakub Romanowski

SQL Courses in New York City

If someone asks me where to learn SQL, I answer simply: online! A good interactive SQL course is much better than any classroom activity or bootcamp. First, you do everything at your own pace. You can always ask the tutor about anything, be a part of an online community, and read interesting things elsewhere on the web (e.g. on our blog). However, there are those who prefer full-time courses. They are traditionalists.
Read more
25 Sep 2020
LearnSQL.com Team

SQL Basics Cheat Sheet

Download this 2-page SQL Basics Cheat Sheet in PDF or PNG format, print it out, and stick to your desk. The SQL Basics Cheat Sheet provides you with the syntax of all basics clauses, shows you how to write different conditions, and has examples. You can download this cheat sheet as follows: Download 2-page SQL Basics Cheat Sheet in PDF format (A4) Download 2-page SQL Basics Cheat Sheet in PDF format (Letter) Download 1-page SQL Basics Cheat Sheet in PDF format (A3) Download 1-page SQL Basics Cheat Sheet in PDF format (Ledger) You may also read the contents here:
Read more
25 Sep 2020
LearnSQL.com Team

SQL JOIN Cheat Sheet

Ready to master SQL JOINs? Get your downloadable cheat sheet now! Your shortcut to becoming an SQL JOINs expert is one click away. Dive deep into the world of SQL JOINs with our detailed SQL JOIN Cheat Sheet, a must-have resource for data enthusiasts at every level. Whether you are just starting out or looking to sharpen your skills, this guide is tailored to provide you with the quick reference needed to use SQL JOINs efficiently.
Read more
24 Sep 2020
Ignacio L. Bisso

What Is the MySQL OVER Clause?

If you want to learn window functions in MySQL, you need to understand the OVER clause. In this article, we use real-world examples to explain what the MySQL OVER clause is, how it works, and why it’s so awesome. In 2018, MySQL introduced a new feature: window functions, which are accessed via the OVER clause. Window functions are a super powerful resource available in almost all SQL databases. They perform a specific calculation (e.
Read more
23 Sep 2020
Jakub Romanowski

SQL Means Business - The Way of an Engineer

Have you been wondering why some companies fail and others achieve success? It's not a matter of luck but of the right people. Łukasz Kubicki at Vertabelo deals with business and product development. I asked him how he started his adventure with programming, how an engineer got into business, and if he liked playing computer games. Here's what he said. If you were to write one sentence about yourself, what would it be?
Read more
22 Sep 2020
Jakub Romanowski

Did You Know LearnSQL.com Has Free SQL Courses?

Who doesn't like getting something for free? Each month, we give LearnSQL.com users a bit of help in their learning journey – a free, fully interactive SQL course. Since April, we have been giving our users the opportunity to learn SQL for free. Each month, we choose one of our SQL courses and give you full access to it for that month – completely free of charge! Cool, right?
Read more