Articles Cookbook
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
13 Feb 2020
Rebecca McKeown

How Long Does It Take to Learn SQL?

Is it hard to learn SQL? How long does SQL mastery take? This article will answer those questions and get you started with the most useful SQL commands. How long does it take to learn SQL? If you’ve ever dabbled in Spanish or French, you know that learning a new language is tough and can take years. Luckily, mastering SQL is a much faster journey than conquering por/para or un, deux, trois.
Read more
11 Feb 2020
Kamila Ostrowska

How to Study Online: 5 Steps to Effective Learning

If you suffer from procrastination or lack of motivation, you’re not alone. We have some online learning tips to make your learning journey smoother and more enjoyable. One of the best things about being an adult is that we can do what we want: go to sleep late at night, party until morning, eat junk food. Besides all those small pleasures, as adults we are responsible for ourselves, our choices, and our mistakes.
Read more
6 Feb 2020
Ignacio L. Bisso

HAVING vs. WHERE in SQL: What You Should Know

This article is about SQL’s WHERE and HAVING clauses. Both clauses are part of the foundations of the SQL SELECT command. They have similar uses, but there are also important differences that every person who uses SQL should know. Let’s see what’s behind the HAVING vs. WHERE debate. In this article, we’ll suppose we work for a government social agency supporting people or families whose income is below a certain threshold.
Read more
28 Jan 2020
Jakub Romanowski

How to Practice SQL

Are you familiar with SQL's core concepts like aggregation functions, JOINs, GROUP BY, and ORDER BY? That's a great start. But to truly master SQL – especially for data analyst roles and job interviews – it's crucial to understand how to practice SQL effectively. This article provides a comprehensive guide to the best methods to practice SQL. You’re here because you're eager to enhance your SQL skills and become an independent database user.
Read more
3 Jan 2020
Rebecca McKeown

SQL INSERT, SQL UPDATE, SQL DELETE – Oh My!

Need to understand SQL INSERT, UPDATE, or DELETE? We'll get you up to speed with a comprehensive How-To and useful examples! SQL INSERT, UPDATE, and DELETE statements—what are they all about? If you're a data engineer, a database administrator, or even just your average data fanboy or girl, one day you're going to find yourself with a database that becomes your "baby." Charged with this special bundle of joy, you're going to need to feed and change the little fella.
Read more
24 Dec 2019
Jakub Romanowski

SQL, Databases, and Hollywood Movies

Policemen, doctors, lawyers, scientists, teachers: These are the professions that we often see in Hollywood movies. But are movies also trying to show what the work of data analysts looks like? Here is a list of six movies in which screenwriters, directors, and producers decided to cast SQL and databases in the main roles. Data analysis is most often associated with business, reporting, and making key decisions for the company.
Read more
10 Dec 2019
Shanika Wickramasinghe

Difference between GROUP BY and ORDER BY in Simple Words

For someone who is learning SQL, one of the most common places to get stuck is when learning the GROUP BY command. GROUP BY and ORDER BY are two important keywords in SQL that we use to organize data. The difference between GROUP BY and ORDER BY is that ORDER BY is more simple than GROUP BY and is usually introduced early in an SQL course. Sometimes, people are quite confused over these two concepts (SQL ORDER BY vs.
Read more