Articles Cookbook
17 Mar 2020
Pierre Timms

How to Start Writing SQL Reports

So, you’ve started, or want to start, learning SQL. You understand that a database is a repository for raw data and that data in business forms the backbone of the decision-making process. But how do you gain meaningful insights from raw data? How can you take a vast amount of information from a database and use SQL to give it a real-world utilization? Learn how to write SQL reports!
Read more
11 Mar 2020
Rebecca McKeown

Learning SQL? 14 Ways to Practice SQL Online

If you’re currently learning SQL, you may have found yourself knee-deep in reading material and wondering how on earth you can bridge the gap between book knowledge and real-life SQL application. In this article, we bring you 14 of the most effective ways to practice SQL online – taking you from a bookworm to a database butterfly in no time at all! “All theory and no practice will make you a frustrated SQL user!
Read more
10 Mar 2020
Kateryna Koidan

How to LEFT JOIN Multiple Tables in SQL

Can you LEFT JOIN three tables in SQL? Yes, indeed! You can use multiple LEFT JOINs in one query if needed for your analysis. In this article, I will go through some examples to demonstrate how to LEFT JOIN multiple tables in SQL and how to avoid some common pitfalls when doing so. The best way to practice different types of joins is our interactive SQL JOINs course. It contains over 90 hands-on exercises that cover simple 2-table joins, joining multiple tables, LEFT JOIN, FULL JOIN, and many more.
Read more
5 Mar 2020
Tihomir Babic

Best Online SQL Courses for Finance & Economics Majors

Are you studying finance and wondering how you can use your knowledge in this technical world? Maybe you’ve just started working as a data analyst and you want to bring new tools and skills to your workplace? This article could help you with the list of the SQL courses worth trying. Maybe you’re studying finance and find your studies too theoretical. How will you put this knowledge into practice?
Read more
4 Mar 2020
Marija Ilic

Should I Learn SQL as a Data Analyst?

So, you are a data analyst—someone who relies on data. You like to gather, clean, and transform data and come to conclusions based on data. You are a data detective. Which tool do you choose to do your job in an elegant, reproducible, and simple way? Excel? R? Python? Or should you learn SQL? Stay tuned! In this article, I will explain why SQL is a must-have skill for data analysts.
Read more
3 Mar 2020
Jakub Romanowski

Top 10 Websites That Will Help You Find the Perfect SQL Job

People learn SQL for many reasons. In my case, I wanted to find a better job that would allow me to earn more and have more free time. But where do you find such a job? Here is my list of the 10 best websites with database jobs. Although SQL is over 40 years old, it is appearing in more and more job advertisements. Data has become an essential tool for businesses, and they are looking for people to squeeze every bit of information from their databases.
Read more
26 Feb 2020
Jakub Romanowski

How to Stay Healthy When Learning SQL

So, maybe you’re learning SQL. Congratulations! Or maybe you already work as a data analyst, DBA, or data scientist. That’s great too! Either way, you are most likely spending hours in front of a computer. I will give you tips on how to avoid bad habits and take care of your health while learning and/or working with SQL. Have you ever wondered how sitting in front of a computer affects your health?
Read more
25 Feb 2020
Magdalena Wojtas

What Programming Language Should You Learn?

If you've ever been wondering which programming language you should learn first, you know that's a tough nut to crack. It’s especially difficult if you are new to IT and programming. In this article, I give suggestions for what to learn first and what perspectives each language can give you in IT. There are hundreds of programming languages, and new ones are showing up all the time. Getting to know all of them is simply impractical and impossible.
Read more
20 Feb 2020
Tihomir Babic

8 Common Entry Level SQL Developer Interview Questions

Have you ever been interviewed for an entry-level SQL position? Are you planning to apply for such a job? This article will help you to know what to expect and prepare for common SQL developer interview questions. After gaining some basic knowledge of SQL and programming, you're probably wondering what to do next. Or maybe you're not wondering! You know that what you've learned will soon disappear if you don't use it regularly.
Read more
18 Feb 2020
Emil Drkušić

How to Become an SQL Developer

There is no simple answer to the question “How do you become an SQL developer?” However, if the answer were too complex, there would be no point in writing this article, and yet I’m doing it. So, somewhere along the way, we’ll find the answer. As said in the intro, there is no magic wand that will turn you into an SQL developer. But reading this article will save you some time and help you focus on what is important to achieve your goal.
Read more