18 Most Important SQL Functions to Learn in 2018

Mastering the basics for a smooth start to SQL Learning a new programing language can seem intimidating. Like any other language, a programming language has a large vocabulary that you need to master. In this article, we’ll look at some of the most important SQL functions that you need to know. SQL is a rich language with many useful functions for working with different data types. Once you practice with some of the most important SQL functions, you’ll gain enough

Continue Reading

SQL Advent Challenge 2017: Get 25% OFF for Helping Santa (updated list of tasks)

Wanna be part of this year’s Christmas success? Santa needs your help organizing his Christmas deliveries. For this occasion, we’ve prepared a special Christmas database. While working on tasks, you’ll help Santa Claus deliver gifts to children. For this upcoming Christmas, we’ve prepared a 24-Day SQL Advent challenge. From now until Christmas Eve, we’ll publish daily SQL tasks for you to complete. If you’ve completed or recently started our SQL Basics course, or if you already have basic SQL knowledge,

Continue Reading

How to Draw a Christmas Tree in SQL

You can use SQL to manipulate all kinds of data, from huge analytical queries to brief single-purpose statements. But you can also use SQL just for fun, without any business requirements stifling your creativity. So, get out your jolly hat and prepare to sing O Christmas Tree as we create some quirky art with plain old SQL. Today, we’re going to generate some holiday-themed ASCII art, just for fun. That’s right. I said fun. This exercise has absolutely zero business

Continue Reading

18+ Best Online Resources for Learning SQL and Database Concepts (2018 revision)

We did it again! Each year, we review all SQL courses and tutorials on the market to help you find the best online resources to learn SQL. Find out which SQL courses are worth a try! But let’s get to the point and take a closer look at some of the best online resources that can help beginners get started with SQL. We’ll start with websites that focus on SQL syntax and basic SQL concepts. 1. Vertabelo Academy Vertabelo Academy offers

Continue Reading

The SQL Coalesce Function: Handling Null Values

Though the COALESCE function may seem complex, it’s actually very straightforward and useful. In this short article, we’ll look at several examples of how the COALESCE function can be used to work with NULL values in SQL. The Need for Coalesce Before we dive into the COALESCE function in detail, you should understand how NULL values behave in expressions. Simply put, a value of NULL indicates that there is currently no value for a particular entry in a table column.

Continue Reading

Digging Into Data: Explore and Analyze Survey Results With SQL

Excel is a powerful beast that lets you analyze complex data. Yet, operating on big chunks of data can sometimes be a daunting task. Let’s take a look at how SQL can help. Today, we’ll tackle a common problem with importing data to an SQL database, using a real-life example. Suppose your company conducted a survey on the most popular programming trends and preferences, striving to meet the expectations of its users. Your user base was overwhelmingly responsive, as the

Continue Reading

GET ACCESS TO EXPERT SQL CONTENT!